context-tree/infrastructure/infrastructure-postgresql-is-our-main-database.md

metadata

id: infrastructure-postgresql-is-our-main-database
title: PostgreSQL is our main database
topic: infrastructure
type: decision
importance: 5
facts:
  - PostgreSQL is the primary database.
  - pgBouncer is used for connection pooling.
  - The setup is intended to support 1000+ concurrent connections efficiently.
  - This choice affects schema design, data access, and integrations.
updatedAt: '2026-05-26T19:51:16.287Z'

Why:

• Single source of truth for app data.
• Connection pooling helps maintain performance and scalability under high concurrency.

Next Steps:

• Use PostgreSQL for new data models.
• Route database access through pgBouncer.
• Avoid introducing another primary database.
• Update future implementation notes to reference PostgreSQL and pgBouncer.