Pigsty Blog Articles
MySQL is dead, Long live PostgreSQL!
July 08, 2024 in Database
This July, MySQL 9.0 was finally released—a full eight years after its last major version, 8.0 (@2016-09).
This July, MySQL 9.0 was finally released—a full eight years after its last major version, 8.0 (@2016-09).
CVE-2024-6387 SSH Vulnerability Fix
July 04, 2024 in Database
This vulnerability affects EL9, Ubuntu 22.04, Debian 12. Users should promptly update OpenSSH to fix this vulnerability.
This vulnerability affects EL9, Ubuntu 22.04, Debian 12. Users should promptly update OpenSSH to fix this vulnerability.
Self-Hosting Dify with PG, PGVector, and Pigsty
June 22, 2024 in PostgreSQL
Dify is an open-source LLM app development platform. This article explains how to self-host Dify using Pigsty.
Dify is an open-source LLM app development platform. This article explains how to self-host Dify using Pigsty.
Can Oracle Still Save MySQL?
June 21, 2024 in Database
Percona founder Peter Zaitsev publicly expressed disappointment with MySQL and Oracle, criticizing the declining performance with newer versions.
Percona founder Peter Zaitsev publicly expressed disappointment with MySQL and Oracle, criticizing the declining performance with newer versions.
Oracle Finally Killed MySQL
June 20, 2024 in Database
Peter Zaitsev, founder of Percona, criticizes how Oracles actions and inactions have killed MySQL. About 15 years after acquiring Sun and MySQL.
Peter Zaitsev, founder of Percona, criticizes how Oracles actions and inactions have killed MySQL. About 15 years after acquiring Sun and MySQL.
MySQL Performance Declining: Where is Sakila Going?
June 19, 2024 in Database
Higher MySQL versions mean worse performance? Percona monitoring shows slow migration from 5.7 to 8.x. PostgreSQL is pulling ahead.
Higher MySQL versions mean worse performance? Percona monitoring shows slow migration from 5.7 to 8.x. PostgreSQL is pulling ahead.
PGCon.Dev 2024, The conf that shutdown PG for a week
June 17, 2024 in PostgreSQL
Experience & Feeling on the PGCon.Dev 2024
Experience & Feeling on the PGCon.Dev 2024
PostgreSQL 17 Beta1 Released!
May 24, 2024 in PostgreSQL
The PostgreSQL Global Development Group announces PostgreSQL 17's first Beta version is now available. This time, PostgreSQL has truly burst the toothpaste tube!
The PostgreSQL Global Development Group announces PostgreSQL 17's first Beta version is now available. This time, PostgreSQL has truly burst the toothpaste tube!
How Ahrefs Saved US$400M by NOT Going to the Cloud
May 22, 2024 in Cloud
After Alibaba-Cloud's epic global outage on Double 11, setting industry records, how should we evaluate this incident and what lessons can we learn from it?
After Alibaba-Cloud's epic global outage on Double 11, setting industry records, how should we evaluate this incident and what lessons can we learn from it?
Why PostgreSQL is the Future Standard?
May 16, 2024 in PostgreSQL
One of the biggest trends in software development today is PostgreSQL becoming the de facto database standard. This article explains why.
One of the biggest trends in software development today is PostgreSQL becoming the de facto database standard. This article explains why.