Pigsty Blog Articles
Alicloud’s rds_duckdb: Tribute or Rip-Off?
March 06, 2025 in Cloud
Does bolting DuckDB onto RDS suddenly make open-source Postgres ‘trash’? Business and open source should be symbiotic. If a vendor only extracts without giving back, the community will spit it out."
Does bolting DuckDB onto RDS suddenly make open-source Postgres ‘trash’? Business and open source should be symbiotic. If a vendor only extracts without giving back, the community will spit it out."
Comparing Oracle and PostgreSQL Transaction Systems
February 27, 2025 in Database
The PG community has started punching up: Cybertec’s Laurenz Albe breaks down how Oracle’s transaction system stacks against PostgreSQL.
The PG community has started punching up: Cybertec’s Laurenz Albe breaks down how Oracle’s transaction system stacks against PostgreSQL.
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.