Database

Posts in 2025
  • In the AI Era, Software Starts at the Database

    April 27, 2025 in Database

    In the AI Era, Software Starts at the 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

    MySQL vs. PostgreSQL @ 2025

    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

    Database Planet Collision: When PG Falls for DuckDB

    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

    Comparing Oracle and PostgreSQL Transaction Systems

    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

    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?

Posts in 2024
  • Solving Poker 24 with a Single SQL Query

    December 03, 2024 in Database

    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)

    December 03, 2024 in Database

    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

    November 25, 2024 in Database

    Supabase is great, but owning your own Supabase is even better. Here’s a comprehensive tutorial for self-hosting production-grade Supabase on local or cloud VMs/BMs. What is Supabase? Supabase is an open-source Firebase alternative and a …

    Supabase is great, but owning your own Supabase is even better. Here’s a comprehensive tutorial for self-hosting production-grade Supabase on local or cloud VMs/BMs. What is Supabase? Supabase is an open-source Firebase alternative and a …

  • Modern Hardware for Future Databases

    November 20, 2024 in Database

    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.

  • Can MySQL Still Catch Up with PostgreSQL?

    November 05, 2024 in Database

    Can MySQL Still Catch Up with PostgreSQL?

    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.