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

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

10 min read·Kodetra Technologies

26d ago

Advanced

Configure io_method, io_workers, and io_uring for big PostgreSQL read throughput gains.

9 min read·Kodetra Technologies

Apr 29