An OLTP banking system is implemented, emphasizing data integrity and atomicity, and leveraging constraints, triggers, stored procedures, views, and indexing to enhance query performance.
Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL
Oracle-style global temporary tables for PostgreSQL
Parch and Posey database was used to explore different functional aspects of SQL from basic to ad...
Generate a Go ORM tailored to your database schema.
The ultimate ORM for Node and Typescript
PostgreSQL Audit Extension
Performing Stored Procedures and Triggers in PostgreSQL Database - PL/pgSQL
Database Naming Conventions & Best Practices