Organize PostgreSQL Projects

Prerequisites

Spinning Up a Modular Database in 2 Minutes

pgpm Workspaces: A New Way to Organize PostgreSQL Projects

Initializing a Workspace for Modular PostgreSQL Development

Creating Your First PostgreSQL Database Module

Testing Your Database Module

Adding Your First Database Change

Change Naming Conventions

Plan Files and Deployment Plans

Spinning Up Temporary Testing Databases for Postgres

How to Test Row-Level Security (RLS) in PostgreSQL

Advanced RLS Testing Scenarios - Simulating Many Users and Roles

Seeding PostgreSQL Test Databases

Supabase Testing for the Modern Developer

Setting Up Local Supabase Database Testing

Writing Your First Supabase Test in TypeScript

Testing Row-Level Security Policies in Supabase

Common Issues and Solutions