Postgres 18 UUIDv7 Primary Keys: Practical Guide (2026)
June 17, 2026
Use Postgres 18's built-in uuidv7() for primary keys: default DDL, uuidv7 vs uuidv4 vs bigint, migrating off uuidv4, and the timestamp-leak caveat to know.
#database
Postgres 18 Zero-Downtime Upgrade: pg_createsubscriber 2026
May 13, 2026
Upgrade Postgres 17 to 18.3 with zero downtime using pg_createsubscriber and logical replication. Docker walkthrough with sequences, cutover, rollback.
The Complete Guide to SQL: From Basics to Advanced Queries
September 18, 2025
SQL from beginner to advanced queries: CRUD, JOINs, subqueries, CTEs, Window Functions, indexes — covering Postgres, MySQL, and SQLite (most examples are portable; vendor-specific differences are noted where they apply).
Easy Hands on Guide how to get Started With SQL
Updated: March 27, 2026
SQL from zero — SELECT, JOIN, GROUP BY, window functions, CTEs. Hands-on exercises using real tables; works in Postgres, modern SQLite, and MySQL 8.0+.
Practical SQL Guide an Overview of Where to Start With SQL
Updated: March 27, 2026
Practical SQL guide: where to start, what to learn first, and the core query patterns every developer uses. Core SQL is portable across Postgres, SQLite, and MySQL; vendor-specific extensions (JSONB, etc.) are flagged as such.