Pigsty Blog Articles
Pig, The Postgres Extension Wizard
December 23, 2024 in PostgreSQL
Why would we need yet another package manager for PostgreSQL & extensions?
Why would we need yet another package manager for PostgreSQL & extensions?
Pigsty v3.2: The pig CLI, Full ARM Support, Supabase & Grafana Enhancements
December 19, 2024 in Pigsty
Pigsty v3.2 introduces the pig CLI for PostgreSQL package management, complete ARM64 extension repository support, and Supabase & Grafana enhancements.
Pigsty v3.2 introduces the pig CLI for PostgreSQL package management, complete ARM64 extension repository support, and Supabase & Grafana enhancements.
OpenAI Global Outage Postmortem: K8S Circular Dependencies
December 14, 2024 in Cloud
Even trillion-dollar unicorns can be a house of cards when operating outside their core expertise.
Even trillion-dollar unicorns can be a house of cards when operating outside their core expertise.
Solving Poker 24 with a Single SQL Query
December 03, 2024 in Database
An interesting but tricky puzzle: solving the 24 game with SQL. The PostgreSQL solution.
An interesting but tricky puzzle: solving the 24 game with SQL. The PostgreSQL solution.
7 Databases in 7 Weeks (2025)
December 03, 2024 in Database
Is PostgreSQL the king of boring databases? Here are seven databases worth studying in 2025: PostgreSQL, SQLite, DuckDB, ClickHouse, FoundationDB, TigerBeetle, and CockroachDB—each deserving a week of deep exploration.
Is PostgreSQL the king of boring databases? Here are seven databases worth studying in 2025: PostgreSQL, SQLite, DuckDB, ClickHouse, FoundationDB, TigerBeetle, and CockroachDB—each deserving a week of deep exploration.
Self-Hosting Supabase on PostgreSQL
November 25, 2024 in Database
Supabase is great, but owning your own Supabase is even better. Here’s a comprehensive tutorial for self-hosting production-grade Supabase on local or cloud VMs/BMs. What is Supabase? Supabase is an open-source Firebase alternative and a …
Supabase is great, but owning your own Supabase is even better. Here’s a comprehensive tutorial for self-hosting production-grade Supabase on local or cloud VMs/BMs. What is Supabase? Supabase is an open-source Firebase alternative and a …
Modern Hardware for Future Databases
November 20, 2024 in Database
A survey on how hardware developments affect database design, covering key advancements in networking, storage, and computing.
A survey on how hardware developments affect database design, covering key advancements in networking, storage, and computing.
Don't Upgrade! Released and Immediately Pulled - Even PostgreSQL Isn't Immune to Epic Fails
November 16, 2024 in PostgreSQL
Never deploy on Friday, or you'll be working all weekend! PostgreSQL minor releases were pulled on the day of release, requiring emergency rollback.
Never deploy on Friday, or you'll be working all weekend! PostgreSQL minor releases were pulled on the day of release, requiring emergency rollback.
PostgreSQL 12 End-of-Life, PG 17 Takes the Throne
November 14, 2024 in PostgreSQL
PG17 achieved extension ecosystem adaptation in half the time of PG16, with 300 available extensions ready for production use. PG 12 officially exits support lifecycle.
PG17 achieved extension ecosystem adaptation in half the time of PG16, with 300 available extensions ready for production use. PG 12 officially exits support lifecycle.
Can MySQL Still Catch Up with PostgreSQL?
November 05, 2024 in Database
Percona founder Peter Zaitsev discusses whether MySQL can still keep up with PostgreSQL. His views largely represent the MySQL communitys perspective.
Percona founder Peter Zaitsev discusses whether MySQL can still keep up with PostgreSQL. His views largely represent the MySQL communitys perspective.