Blog
Notes from Churros
Product updates, technical writeups, and the thinking behind what we ship.
-
SQL Date Format: A Postgres-First Practical Guide
A practical Postgres-first guide to SQL date formatting, ISO 8601, TO_CHAR, cross-dialect patterns, timezone handling, and index-friendly date filters.
-
SQL Query to Add Column with Default Value: A Guide
A practical PostgreSQL guide to adding a column with a default value, covering ALTER TABLE syntax, locking behavior, table rewrites, and safer production migration patterns.
-
How to Postgres Delete User: The Safe Way (2026 Guide)
A production-minded sequence for removing a Postgres role — terminate sessions, audit database and object ownership, REASSIGN OWNED, DROP OWNED, then DROP USER — with a cluster-wide script for multi-database cleanup.
-
8 SQL CASE Statement Examples in Postgres
Eight practical CASE patterns — from categorical mapping and conditional aggregation to pivots, custom sorts, conditional updates, and window-function running totals — with the workflow for testing each one before it ships.
-
Your Next SQL Client for Mac: The 2026 Developer Guide
What to actually look for in a SQL client when you live in Postgres on macOS — native feel, safe editing, schema-aware autocomplete, and connection ergonomics that match how cloud Postgres works today.
-
Start a Postgres Server on Mac: A Complete Guide
Four realistic ways to run Postgres locally on macOS — Homebrew Services, Postgres.app, Docker, and manual pg_ctl — with the trade-offs, gotchas, and the failures that waste the most time.
-
Subtraction in SQL Query: Postgres Guide 2026
A practical Postgres guide to subtraction — numeric arithmetic, date and time math, set subtraction with EXCEPT, window-function comparisons, and the NULL and casting pitfalls that bite in production.