Menu
The Omenabyte Blog
Notes from the build.
Field notes on shipping AI products, securing what you build, and running infrastructure with fewer moving parts. Everything here is tested before it ships — including the parts that turned out to be a bad idea.

I Replaced 8 Services With Postgres. Here's Where It Actually Breaks.
Eight swaps, one instance — then the part nobody writes: where sharding, extreme ingest, pooler limits and single-instance blast radius actually stop you.
Read the post →
Databases · 10 posts

Let Your Database Generate the API and Guard the Door
PostgREST turns your schema into a documented REST API and RLS moves authorization below the application layer — plus the owner bypass nobody warns you about.

Two People Bought the Last Ticket. Both Got a Confirmation Email.
A race condition is not a crash. It is the ordinary result of two requests arriving at once. The bug is the gap between checking and writing, not the code on either side of it.

"Find What's Nearby" Doesn't Need a Separate GIS Stack
A geography column plus a GiST index turns "what's near this point" into an ordinary spatial query — and the coordinate trap that fails silently instead of erroring.

Stop Recomputing Your Dashboard on Every Page Load
A materialized view pre-computes the aggregation once, REFRESH CONCURRENTLY hot-swaps it without locking readers, and pg_cron schedules it in-database. No ETL pipeline, no warehouse.

Billions of Log Rows, One Command to Make Them Disappear
Declarative partitioning plus a BRIN index prunes the scan to one partition — and retention becomes a single DROP TABLE, not a bulk delete job.

You Don't Need MongoDB for "Flexible" Data. You Need One Column Type.
jsonb plus a GIN index gives you document flexibility without a second database — and the "document" still joins against your relational tables in one transaction.

Your AI Feature Doesn't Need Pinecone. It Needs pgvector.
pgvector with an HNSW index puts embeddings in the same row as everything else — semantic and relational in one query, one transaction.

Postgres Can Do Typo-Tolerant Search. You Don't Need Elasticsearch Yet.
tsvector plus pg_trgm give you stemmed, ranked, typo-tolerant search inside the database you already run — no second cluster, no sync job.

I Replaced Redis and RabbitMQ With 15 Lines of Postgres
The FOR UPDATE SKIP LOCKED clause turns an ordinary table into a safe, concurrent job queue — tested for duplicates, crashes and reclaims before this post was written.