Pigsty Blog Articles
What Can We Learn from NetEase Cloud Music's Outage?
August 18, 2024 in Cloud
NetEase Cloud Music experienced a two-and-a-half-hour outage this afternoon. Based on circulating online clues, we can deduce that the real cause behind this incident was...
NetEase Cloud Music experienced a two-and-a-half-hour outage this afternoon. Based on circulating online clues, we can deduce that the real cause behind this incident was...
Whoever Integrates DuckDB Best Wins the OLAP World
August 13, 2024 in PostgreSQL
Just like the vector database extension race two years ago, the current PostgreSQL ecosystem extension competition has begun revolving around DuckDB. MotherDuck's official entry into the PostgreSQL extension space undoubtedly signals that competition has entered white-hot territory.
Just like the vector database extension race two years ago, the current PostgreSQL ecosystem extension competition has begun revolving around DuckDB. MotherDuck's official entry into the PostgreSQL extension space undoubtedly signals that competition has entered white-hot territory.
StackOverflow 2024 Survey: PostgreSQL Has Gone Completely Berserk
July 25, 2024 in PostgreSQL
The 2024 StackOverflow Global Developer Survey results are fresh out, and PostgreSQL has become the most popular, most loved, and most wanted database globally for the second consecutive year. Nothing can stop PostgreSQL from devouring the entire database world anymore!
The 2024 StackOverflow Global Developer Survey results are fresh out, and PostgreSQL has become the most popular, most loved, and most wanted database globally for the second consecutive year. Nothing can stop PostgreSQL from devouring the entire database world anymore!
Switzerland Mandates Open-Source for Government Software
July 24, 2024 in Database
Switzerland's government leads the way with open source legislation, showing IT developing countries how to ensure software sovereignty and control. True autonomy and control stem from "open source communities," not some "nationalist" style "domestic software."
Switzerland's government leads the way with open source legislation, showing IT developing countries how to ensure software sovereignty and control. True autonomy and control stem from "open source communities," not some "nationalist" style "domestic software."
Blue Screen Friday: Amateur Hour on Both Sides
July 23, 2024 in Cloud
Both client and vendor failed to control blast radius, leading to this epic global security incident that will greatly benefit local-first software philosophy.
Both client and vendor failed to control blast radius, leading to this epic global security incident that will greatly benefit local-first software philosophy.
Pigsty v2.7: The Extension Superpack
July 12, 2024 in Pigsty
Pigsty v2.7 bundles 255 PostgreSQL extensions, plus Docker templates for Odoo, Supabase, PolarDB, and Jupyter, with new PITR dashboards.
Pigsty v2.7 bundles 255 PostgreSQL extensions, plus Docker templates for Odoo, Supabase, PolarDB, and Jupyter, with new PITR dashboards.
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.