Introduction I started contributing to PostgreSQL around 2020. In 2025 I wanted to work harder, so I’ll explain the PostgreSQL features I developed and committ...

Blocking When Two Users Update the Same Record If two users attempt to modify the same row, the session that issues the UPDATE later is blocked until the first...

System‑wide “ANY” privileges and the Data Dictionary When a user is granted a system‑wide ANY privilege e.g., SELECT ANY TABLE, DROP ANY TABLE, the user still...

Navigating the Labyrinth: Effective Database Indexing Strategies In the realm of data management, efficiency is paramount. As datasets grow, the time taken to r...

The Problem with Early Backend Decisions Most projects don’t fail because of a lack of ideas. They slow down for a more structural reason: backend decisions ar...

Query Handling When a query is sent to a ThingsDB node, the node first checks its own status. - If the node is in AWAY mode, it does not process the request lo...

Project Initialization Start by setting up your Node.js environment with TypeScript. We use tsx for modern, fast execution. bash mkdir prisma-postgres-2025 cd...

Deadlocks in a Banking API – What They Are, How to Reproduce Them, and How to Fix Them Forever TL;DR: You can reproduce the deadlock locally using Docker. Get...

Article URL: https://brooker.co.za/blog/2025/12/15/database-for-ssd.html Comments URL: https://news.ycombinator.com/item?id=46334990 Points: 4 Comments: 2...

📚 About the Author As a best‑selling author, I invite you to explore my books on Amazonhttps://www.amazon.com/stores/Aarav-Joshi/author/B0DQYNVXZ7?ref=ap_rdr&...

Differences of Database Sharding and Partition What is Database Sharding - Horizontal Data Distribution – Data is split into shards, each stored on a separate...

Article URL: https://sqlite.org/testing.html Comments URL: https://news.ycombinator.com/item?id=46303277 Points: 85 Comments: 8...