Database
In the AI Era, Software Starts at the Database
April 27, 2025 in Database
Future software = Agent + Database. No middle tiers, just agents issuing CRUD. Database skills age well, and PostgreSQL is poised to be the agent-era default.
Future software = Agent + Database. No middle tiers, just agents issuing CRUD. Database skills age well, and PostgreSQL is poised to be the agent-era default.
MySQL vs. PostgreSQL @ 2025
April 17, 2025 in Database
A 2025 reality check on where PostgreSQL stands relative to MySQL across features, performance, quality, and ecosystem.
A 2025 reality check on where PostgreSQL stands relative to MySQL across features, performance, quality, and ecosystem.
Database Planet Collision: When PG Falls for DuckDB
March 12, 2025 in Database
If you ask me, we’re on the brink of a cosmic collision in database-land, and Postgres + DuckDB is the meteor we should all be watching.
If you ask me, we’re on the brink of a cosmic collision in database-land, and Postgres + DuckDB is the meteor we should all be watching.
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.
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?
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 …
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.
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.