Pigsty Blog Articles
Pigsty v3.3: 404 Extensions, Turnkey Apps, New Website
February 20, 2025 in Pigsty
Pigsty v3.3 pushes available extensions to 404, adds turnkey app deployment with app.yml, delivers Certbot integration for automated HTTPS, and launches a redesigned website.
Pigsty v3.3 pushes available extensions to 404, adds turnkey app deployment with app.yml, delivers Certbot integration for automated HTTPS, and launches a redesigned website.
PostgreSQL Ecosystem Frontier Developments
January 24, 2025 in PostgreSQL
Sharing some interesting recent developments in the PG ecosystem.
Sharing some interesting recent developments in the PG ecosystem.
Database as Business Architecture
January 22, 2025 in Database
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
January 13, 2025 in Cloud
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
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, 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 …