Install
Please confirm you are human
This browser or connection looks automated. Press and continuously hold the control for 3 seconds to enable Google-hosted web results and, when separately allowed, AI-assisted answers.
A successful check enables 100 search requests. Interactive access does not authorize scraping, systematic collection, or reuse of search output.
News
Ditch H2: PostgreSQL Repository Tests with Testcontainers and @ServiceConnection in Spring Boot 4
3+ hour, 31+ min ago (204+ words) Your repository tests are green. Then production throws a column “metadata” is of type jsonb but expression is of type character varying…Continue reading on Medium » Ditch H2: PostgreSQL Repository Tests with Testcontainers and @ServiceConnection in Spring Boot 4 Your repository tests…...
Distributed Locks
8+ hour, 21+ min ago (110+ words) One-liner: A distributed lock ensures that only one node in a cluster can perform a critical operation at a time — preventing race conditions across services. In a single-server world, a mutex or semaphore handles concurrency. But in distributed systems: Classic…...
Database Isolation Levels: What Can Concurrent Transactions Actually See?
5+ hour, 43+ min ago (743+ words) Transactions do not execute in isolation from reality. Isolation levels define how much of that reality they are allowed to observe. In the previous topic, we explored Optimistic and Pessimistic Concurrency Control. Now we can go one level deeper. What…...
EXPLAIN Describes a Query. Production Is Everything Else That’s Running.
8+ hour, 9+ min ago (1398+ words) A while back I wrote about migrating a terabyte of banking data from Oracle to PostgreSQL with no downtime. The part people …...
Every text-to-SQL benchmark score you've seen was measured without access control
12+ hour, 45+ min ago (955+ words) Spider, BIRD, LiveSQLBench. If you have evaluated a text-to-SQL system in the last five years you have quoted a number from one of them. All three ask the same question: given a schema and an English question, does the system…...
Our users’ phones were the backup: rebuilding a lost database from app caches
13+ hour, 45+ min ago (223+ words) How expired cache entries on readers’ devices, server logs, and a year-old dump were merged back into MongoDB without …...
Vanilla PostgreSQL vs Amazon Aurora PostgreSQL
14+ hour, 21+ min ago (1187+ words) At the application level, Amazon Aurora PostgreSQL looks like PostgreSQL. You connect with PostgreSQL drivers, run SQL, use transactions, indexes, MVCC. Underneath, it is a different database architecture. One sentence explains most of the difference: Vanilla PostgreSQL couples the database engine…...
IEnumerable vs. IQueryable in C#
14+ hour, 49+ min ago (429+ words) This distinction sounds simple stated this way, but it has real, concrete consequences for where computation happens, how much data crosses the network, what C# expressions are even legal to write, and a specific, common class of bug that this…...
Decoding a UUID by hand: version, variant, and the embedded timestamp
22+ hour, 39+ min ago (404+ words) The reason was practical. IDs arriving from other systems come with no documentation. When you generate them yourself you know the scheme; when you receive them you are guessing. The spec makes this mechanically decidable, so I wrote the reader....
Building a rate limiter, why even use Redis.
22+ hour, 57+ min ago (106+ words) Well I failed a amazon OA because of a rate limiting question, So I have built this rate limiter from... Tagged with redis, typescript, software, beginners....