pgdbm Database Pattern Selector FAQs

Question 1

When should I use the Dual-Mode Library pattern?

Accepted Answer

Use it when building a package intended for PyPI or shared internal use where you don't control the final database configuration and need to support both standalone and embedded modes.

Question 2

Can I share a connection pool across different OS processes?

Accepted Answer

No, database connection pools cannot be shared across OS processes. Each process (like a separate background worker container) should use the Standalone pattern.

Question 3

What is the benefit of the Shared Pool pattern in FastAPI?

Accepted Answer

It allows multiple service modules or routers to share a single connection pool while maintaining schema isolation, which maximizes performance and avoids hitting PostgreSQL connection limits.

Question 4

Why is the module_name mandatory in migrations?

Accepted Answer

The module_name is essential for tracking migration history accurately within the database, especially when multiple services or libraries are managing their own schemas in the same database.

Question 5

How does pgdbm handle multi-tenancy?

Accepted Answer

pgdbm facilitates multi-tenancy using the Shared Pool pattern combined with schema isolation, allowing many tenants to occupy the same database while keeping data logically separated.

pgdbm Database Pattern Selector

Key Features

Use Cases

pgdbm Database Pattern Selector

Key Features

Use Cases