PostgreSQL

Technical Journal // PostgreSQL
May '26

Building a Poor Document Store inside PostgreSQL

A forensic analysis of why abusing JSONB for schemaless architecture leads to write amplification, TOAST bloat, and catastrophic query planner failures.

May '26

How to Handle PostgreSQL Database Migrations in Go with Goose

A breakdown of database migration strategies and implementation guide using PostgreSQL, Golang, and the Goose migration engine.

Mar '26

ClickHouse vs. Postgres: When to Move Your Logs Out of a Relational DB

Postgres is the swiss-army knife of databases, but when you hit the 10-million row mark for write-heavy logs, the relational wall becomes real. Here is why we moved our observability stack to ClickHouse.

Apr '23

Setting Up a PostgreSQL Container: A Quick Guide

Learn the simple and fast process of creating a PostgreSQL container using Docker. This guide provides both the command and a detailed explanation of the container and PostgreSQL database configuration.