Pigsty Blog Articles
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, own your own Supabase is even better. Here’s a comprehensive tutorial for self-hosting production-grade supabase on local/cloud VM/BMs. What is Supabase? Supabase is an open-source Firebase alternative, a Backend as a Service …
Supabase is great, own your own Supabase is even better. Here’s a comprehensive tutorial for self-hosting production-grade supabase on local/cloud VM/BMs. What is Supabase? Supabase is an open-source Firebase alternative, a Backend as a Service …
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.
The ideal way to deliver PostgreSQL Extensions
November 02, 2024 in PostgreSQL
PostgreSQL Is Eating the Database World through the power of extensibility. With 390 extensions powering PG, we may not say it's invincible, but it’s definitely getting much closer.
PostgreSQL Is Eating the Database World through the power of extensibility. With 390 extensions powering PG, we may not say it's invincible, but it’s definitely getting much closer.
Pigsty v3.1: One-Click Supabase, PG17 Default, ARM & Ubuntu 24
October 28, 2024 in Pigsty
Pigsty v3.1 makes PostgreSQL 17 the default, delivers one-click Supabase self-hosting, adds ARM64 and Ubuntu 24.04 support, and simplifies configuration management.
Pigsty v3.1 makes PostgreSQL 17 the default, delivers one-click Supabase self-hosting, adds ARM64 and Ubuntu 24.04 support, and simplifies configuration management.
Open-Source "Tyrant" Linus's Purge
October 25, 2024 in Database
The Linux community is essentially imperial — and Linus himself is the earliest and most successful technical dictator. People are used to Linus's generosity but forget this point.
The Linux community is essentially imperial — and Linus himself is the earliest and most successful technical dictator. People are used to Linus's generosity but forget this point.
WordPress Community Civil War: On Community Boundary Demarcation
October 17, 2024 in Cloud
When open source ideals meet commercial conflicts, what insights can this conflict between open source software communities and cloud vendors bring? On the importance of community boundary demarcation.
When open source ideals meet commercial conflicts, what insights can this conflict between open source software communities and cloud vendors bring? On the importance of community boundary demarcation.