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

---
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.