Guides

AI Guides for Builders

How-to content for builders, indie hackers, and AI engineers. Less theory, more shipped code.

Intermediate

PostgreSQL 18 UUIDv7: Better Primary Keys

Use Postgres 18 uuidv7() for ordered primary keys, smaller indexes, fewer page splits.

8 min read·Kodetra Technologies

19d ago

Intermediate

Build a reliable production job queue using only Postgres FOR UPDATE SKIP LOCKED.

12 min read·Kodetra Technologies

20d ago

Intermediate

Persist agent state to Postgres so LangGraph agents survive any crash.

3 min read·Kodetra Technologies

23d ago

Intermediate

Run DuckDB-powered OLAP queries directly inside Postgres for 100x faster analytics on Parquet.

10 min read·Kodetra Technologies

26d ago

Intermediate

Build a Redis + Postgres idempotency layer that survives retries, races, and crashes.

9 min read·Kodetra Technologies

27d ago

Intermediate

Guarantee events publish even when Kafka is down. Outbox pattern with Postgres, step-by-step.

7 min read·Kodetra Technologies

Apr 29