Vol. I · A Postgres Handbook

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

AdvancedAdvanced PostgreSQL

Backend Deployment: Docker & K8s #47

The query

SQL
-- Q: Deploying Spring Boot + PG to Kubernetes (Scenario 47)
-- A: Use StatefulSets for PostgreSQL, Deployments for Spring Boot.
-- Always inject DB credentials using Kubernetes Secrets.
-- Avoid running PostgreSQL in Docker for large productions without volume mounts.
Tested against PostgreSQL 16

Note

“When deploying Spring Boot, use readiness and liveness probes to ensure DB connectivity before accepting traffic.