pgdbm Database Pattern Selector

概要

This skill provides an interactive decision framework to determine whether a project should utilize standalone, shared pool, or dual-mode library patterns for the pgdbm Postgres manager. It eliminates the need for manual documentation deep-dives by analyzing specific deployment requirements—such as process isolation, PyPI distribution needs, and connection efficiency—to recommend the most robust and scalable database architecture for Python applications.

主な機能

• Interactive decision tree for selecting database patterns
• Guidelines for connection pool optimization and process isolation
• Detailed comparison of standalone, dual-mode, and shared pool setups
• Schema isolation strategies for multi-tenant and microservice architectures
• Identification of red flags for improper pattern implementation
• 0 GitHub stars

ユースケース

• Developing a reusable Python library for PyPI that requires flexible database connectivity
• Architecting a FastAPI monolith with multiple services sharing a single database
• Configuring background workers in separate processes to optimize connection limits