postgresql-sql

What problem does it solve?

PostgreSQL database design, migrations, queries, indexing, and performance optimization standards and practices; it helps teams enforce robust schemas and maintainable SQL workflows.

Core Features & Use Cases

• Schema design conventions and naming standards for tables, columns, keys, and constraints.
• Version-controlled migrations with up/down scripts and safe patterns for adding columns, renames, and indexing.
• Toolchain integration examples with sqlc, SQLx, Squirrel, and pg.zig for type-safe or generated SQL across Go/Rust/Gleam/Zig projects.
• Real-world use case: designing a new user or order schema and implementing migrations and queries with best practices.

Quick Start

Create a new PostgreSQL schema following the conventions, initialize the migrations folder, and start adding up.sql and down.sql scripts with a type-safe toolchain.