Day: December 18, 2025
JSON in PostgreSQL
PostgreSQL’s JSONB type is fast, indexable, and incredibly flexible for semi-structured data. But it’s not a silver bullet, sometimes a traditional normalized table is still the better choice.Since I have PostgreSQL running on my laptop, I’ll show you real examples you can copy-paste and run yourself, complete with actual psql screenshots. When to use JSONB…
Read More