Standard Search

Reading your own writes with WAIT FOR LSN in Postgres 19

https://rednafi.com/system/wait-for-lsn/ · 12 Jun 2026

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.

Untitled

https://johnbeales.com/micro/2026-06-09t174853-0400/ · 9 Jun 2026 · 🦋 Bluesky

I'm migrating analytics to a new database structure for 4RoadService, it looks like this will take a few days. This should enable faster, better, and more accurate reporting for our customers.

analytics database database design migration reporting

Untitled

https://johnbeales.com/micro/2026-05-26t200821-0400/ · 27 May 2026

I am now a member of the "Claude code deleted something that it shouldn't have from my database" club! Good thing it was a development database.

agentic development ai claude claude code database

Repositories, transactions, and unit of work in Go

https://rednafi.com/go/repo-txn-uow/ · 21 Mar 2026

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.

go database design patterns

How do you handle transactions with the repository pattern?

https://rednafi.com/shards/2026/03/transactions-with-repository-pattern/ · 20 Mar 2026

Adding transaction support to a repository interface without leaking storage details.

go database

Do you need a repository layer on top of sqlc?

https://rednafi.com/shards/2026/03/repository-layer-over-sqlc/ · 16 Mar 2026

Decoupling business logic from storage with a small interface in Go.

go database

On newly created database schemas

https://ledger.leaflet.pub/3mgvlokalck27 · 12 Mar 2026

If you've just created new schemas and have multiple user roles, make sure to execute these commands.

database postgresql

Hierarchical rate limiting with Redis sorted sets

https://rednafi.com/misc/hierarchical-rate-limiting/ · 12 Jan 2025

Build multi-level rate limiting with Redis sorted sets and Lua. Enforce global and category-specific limits with ZREMRANGEBYSCORE and ZCARD commands.

database python system redis

Seed your Supabase database with this simple pattern

https://mikebifulco.com/posts/seed-your-supabase-database · 23 Jul 2024

Learn how to seed your Supabase database with this simple pattern.

supabase database typescript postgres

Sorting a Django queryset by a custom sequence of an attribute

https://rednafi.com/python/sort-by-a-custom-sequence-in-django/ · 9 May 2023

Sort Django querysets by custom attribute sequences using Case and When expressions for database-level ordering with SQL CASE statements.

python django database