using-pgdbm

What problem does it solve?

This skill clarifies how to design and operate a scalable pgdbm setup using one shared pool and per-service schemas, including template-based queries and per-module migrations.

Core Features & Use Cases

• ONE pool to rule them all: centralized connection management to minimize database load.
• Schema isolation: each service/module operates in its own PostgreSQL schema for safe multi-tenancy.
• Template-driven queries: {{tables.*}} syntax ensures portability across deployment modes.
• Migrations per module: run migrations independently for each service while sharing the pool.
• Production patterns: example architectures for microservices, libraries, and FastAPI-style apps.

Quick Start

Instantiate a shared pool with a DatabaseConfig, create AsyncDatabaseManager instances per schema, and run migrations for each module. Then perform queries using the template syntax {{tables.*}}.