PostgreSQL 19's new WAIT FOR LSN command lets a replica block until it has replayed your write. The read-after-write problem it solves, the workarounds it replaces, and what the timeout, status, and mode options are actually for.
PostgreSQL 19's new WAIT FOR LSN command lets a replica block until it has replayed your write. The read-after-write problem it solves, the workarounds it replaces, and what the timeout, status, and mode options are actually for.
When a partitioning change to our petabyte-scale ClickHouse cluster caused critical billing jobs to stall, standard metrics showed no obvious errors. This post explores how we identified severe lock contention in ClickHouse's query planner and built upstream patches to fix it.
Learn how to deploy PlanetScale Postgres and MySQL databases via Cloudflare and connect Cloudflare Workers.
Decoupling business logic from storage in Go, adding transaction support without leaking SQL details, and coordinating atomic writes across multiple repositories using a unit of work.
Decoupling business logic from storage in Go, adding transaction support without leaking SQL details, and coordinating atomic writes across multiple repositories using a unit of work.
Adding transaction support to a repository interface without leaking storage details.
Adding transaction support to a repository interface without leaking storage details.
J
Around the world, cultural workers are striking, protesting, running campaigns and mobilizing in relation to the use of AI in the workplace, such as Hollywood writers, game performers in the US and voice actors in Brazil. This tracker aims to document strikes, protests, campaigns and mobilizations by cultural workers — broadly understood as the arts, culture and media sectors — in relation to…
Decoupling business logic from storage with a small interface in Go.
Decoupling business logic from storage with a small interface in Go.
J
Discover, Track and Compare Open Source; Indexing 255,914 open source projects
N
The Department of Homeland Security is threatening to put legal observers monitoring ICE activity on a domestic terrorist watchlist, according to a new lawsuit.
Politico, citing the lawsuit, reports that DHS agents used facial recognition technology and license plate readers to monitor observers in Maine who were keeping tabs on federal immigration agents. The federal law enforcement officers…
Build multi-level rate limiting with Redis sorted sets and Lua. Enforce global and category-specific limits with ZREMRANGEBYSCORE and ZCARD commands.
Sort Django querysets by custom attribute sequences using Case and When expressions for database-level ordering with SQL CASE statements.
Poll multiple data sources in a single thread using Python generators with itertools.cycle to alternate between infinite data streams efficiently.
Use Django query expressions like Replace, Upper, Lower, Concat, and Substr for efficient database-level text manipulation without fetching data.
Accelerate Django bulk_update operations by 4x using multiprocessing to parallelize database writes across chunked record batches.
Practical SQLite recipes for Python: execute statements, batch operations, transactions, row factories, and context managers with sqlite3.
Emulate Python's random.choice in SQLite using JSON arrays and the random() function. Populate tables with realistic test data efficiently.
Speed up Django bulk operations with ProcessPoolExecutor while preserving signals and hooks that bulk_create/bulk_update bypass.
Page 1