• April 22

  Start with a clean slate: Integration testing with PostgreSQL

  

  dogac.dev

  We have been using PostgreSQL as our primary database in production for 4 over years, however...

  We have been using PostgreSQL as our primary database in production for 4 over years, however over time, as our database grew bigger and reached over 500 tables in a single monolithic application, we had to come up with smart ways to manage it. PostgreSQL is a database that is capable of handling hundreds of tables ...

  databasesopen-sourceprogrammingtesting

  1

More like this (3)

• March 8

  Postgres Just Cracked the Top Fastest Databases for Analytics

  

  mooncake.dev

  Zhou Sun2025-01-14TLDR: We spent a few months optimizing PostgreSQL and made it to the Top 10...

  Zhou Sun2025-01-14TLDR: We spent a few months optimizing PostgreSQL and made it to the Top 10 on ClickBench, a benchmark typically dominated by specialized analytics databases. What’s more, all compute is within Postgres, and all tables are managed directly by PostgreSQL—it’s not a simple wrapper. This is the story ...

  1
• March 4

  Scaling with PostgreSQL without boiling the ocean

  

  shayon.dev

  Scaling with PostgreSQL without boiling the ocean Scaling PostgreSQL successfully doesn’t always require a full team...

  Scaling with PostgreSQL without boiling the ocean Scaling PostgreSQL successfully doesn’t always require a full team of DBAs and experts. The beauty of PostgreSQL is that solutions often lie within the database itself - by rethinking your data access patterns from first principles, you can solve many business problems at scale.

  databasespostgresqlscaling

  2
• February 14

  Simple declarative schema migration for SQLite

  rothlis.net

  By David Rõthlisberger and William Manley. Published 30 Apr 2022. At my company we use a...

  By David Rõthlisberger and William Manley. Published 30 Apr 2022. At my company we use a small SQLite database. We define the schema in a single file with SQL CREATE TABLE statements. If we add tables, columns, or indexes, our application will create them automatically the next time it starts up. This is superior to...

  databases

  1