sql
Browse all articles, tutorials, and guides about sql
4posts
Posts
⌘K
DevOps
|13 min read
Zero-Downtime Database Migrations for PostgreSQL in Production
A single ALTER TABLE can take down a busy PostgreSQL database for minutes. This post shows why that happens and how to ship schema changes safely with lock timeouts, the expand-and-contract pattern, and copy-paste SQL recipes for indexes, columns, constraints, and type changes.
Terraform
|9 min read
How to Apply SQL Scripts to RDS Databases With Terraform
Learn different approaches for running SQL scripts and migrations against RDS databases during Terraform deployment, including provisioners, external tools, and dedicated migration resources.
Linux
|6 min read
How to Check Which Version of PostgreSQL You Are Running
Learn multiple ways to check your PostgreSQL version, including psql commands, SQL queries, and system commands. Find version numbers from the server, client, and package manager.