Pigsty Blog Articles
Database as Business Architecture
Databases are the core of business architecture, but what happens if we go further and let databases become the business architecture itself?
Databases are the core of business architecture, but what happens if we go further and let databases become the business architecture itself?
Escaping Cloud Computing Scam Mills: The Big Fool Paying for Pain
A user consulted about distributed databases, but he wasn't dealing with data bursting through server cabinet doors—rather, he'd fallen into another cloud computing pig-butchering scam.
A user consulted about distributed databases, but he wasn't dealing with data bursting through server cabinet doors—rather, he'd fallen into another cloud computing pig-butchering scam.
Pig, The Postgres Extension Wizard
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
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
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
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)
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
Supabase is an open-source PostgreSQL-based BaaS. It provides authentication, Realtime, Edge Functions, object storage, and REST APIs generated from the database schema; enabling pg_graphql on demand also provides GraphQL APIs. Self-hosting can make …
Supabase is an open-source PostgreSQL-based BaaS. It provides authentication, Realtime, Edge Functions, object storage, and REST APIs generated from the database schema; enabling pg_graphql on demand also provides GraphQL APIs. Self-hosting can make …
Self-Hosting Supabase on PostgreSQL
Supabase is great, owning your own Supabase is even better! A comprehensive tutorial for self-hosting production-grade Supabase on local/cloud VMs with Pigsty.
Supabase is great, owning your own Supabase is even better! A comprehensive tutorial for self-hosting production-grade Supabase on local/cloud VMs with Pigsty.
Modern Hardware for Future Databases
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.
Was this page helpful?
Thanks—your feedback helps us improve this page.
What got in the way? (optional)