Technology: PostgreSQL (Default Database).
PostgreSQL is the official default relational database for all new services within our organization. It is selected for its industry-standard reliability, extensive extension ecosystem (e.g., PostGIS, pgvector), and its ability to handle both traditional relational workloads and modern document (JSONB) or AI-driven (Vector) requirements.
Why We Use It.
- Engineering Consistency: Using a single RDBMS engine allows us to share expertise, query optimization strategies, and security patterns across all squads.
- Operational Maturity: By standardizing on Postgres, our platform teams provide deep support for monitoring, backup recovery, and performance tuning.
- Vendor Neutrality: Unlike cloud-specific proprietary databases, the Postgres wire protocol and SQL dialect remain consistent, facilitating our long-term goal of cloud portability.
Deployment Strategy & Flavors.
Teams should use the solution of PostgreSQL provided by the platform they are utilizing:
| Solution | Primary Use Case | Platform |
|---|---|---|
| AWS RDS Aurora | High-scale, mission-critical global applications. | AWS-native workloads |
| Self-Hosted (K8s) | Services requiring tight integration with Kubernetes or specific compliance needs . Using Zalando Postgres Operator Automated lifecycle management (backups, scaling, HA) within Kubernetes. | Private Cloud / K8s clusters |
Future Outlook: Multi-Cloud Convergence.
While we currently support multiple hosting flavors, our roadmap includes a transition toward a Unified Managed Postgres Provider (e.g., Aiven, Crunchy Bridge, PlaneScale, or Yugabyte). The goal of this convergence is to:
- Reduce Operational Divergence: Move away from managing K8s operators and cloud-specific RDS configurations separately.
- Enable Portability: Utilize a single "Managed Service" interface that works identically across AWS, GCP, and Azure.
- Managed-Native Experience: Gain the benefits of a fully managed service (24/7 DBA support, automated patching) without the lock-in of a single cloud vendor's internal tooling.
More info: https://easypark.jira.com/wiki/spaces/pet/pages/2152333401/aurora+information+for+developers
Platform: global-platform, parkopedia, flowbird, permit