Tag

#database

5 posts

Backend DevelopmentJune 17, 202610 min
Postgres 18 UUIDv7 Primary Keys: Practical Guide (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.
Backend DevelopmentMay 13, 202616 min
Postgres 18 Zero-Downtime Upgrade: pg_createsubscriber 2026
Upgrade Postgres 17 to 18.3 with zero downtime using pg_createsubscriber and logical replication. Docker walkthrough with sequences, cutover, rollback.
Backend DevelopmentSeptember 18, 202510 min
The Complete Guide to SQL: From Basics to Advanced Queries
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).
Backend DevelopmentJanuary 15, 202311 min
Easy Hands on Guide how to get Started With SQL
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+.
Backend DevelopmentJanuary 15, 20236 min
Practical SQL Guide an Overview of Where to Start With SQL
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.

Every post in #database (5)

Postgres 18 UUIDv7 Primary Keys: Practical Guide (2026)