Organize Postgres Projects

Prerequisites

Spinning Up a Modular Database in 2 Minutes

pgpm Workspaces: A New Way to Organize Postgres Projects

Initializing a Workspace for Modular Postgres Development

Creating Your First Postgres 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 Postgres

Advanced RLS Testing Scenarios - Simulating Many Users and Roles

Seeding Postgres 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

How to Setup Drizzle ORM for End-to-End Testing

Testing Row-Level Security with Drizzle ORM

Common Issues and Solutions