PostgreSQL Requirements

Aidbox uses PostgreSQL as its database engine, leveraging its robust JSON capabilities, reliability, and performance for healthcare data storage.

Version compatibility

• Minimum: PostgreSQL 12 (required for JSON path support). For older versions, use PostgreSQL with jsonknife extension
• Actively supported: Three most recent versions (currently 17, 16, 15)

Deployment options

Compatible with all PostgreSQL deployments

• cloud-managed services (such as AWS RDS, Google Cloud SQL , Azure Database, etc)
• self-hosted installations
• on-premises deployments

Database Management

• Initialization: Aidbox automatically creates all database objects, including tables, starting indexes, and other required structures
• Schema migrations: Automatically handled during Aidbox version upgrades
• Monitoring:
  • Aidbox provides OpenTelemetry metrics for PostgreSQL monitoring
• Backup/Restore: Use standard PostgreSQL methods:
  • Native PostgreSQL backup tools
  • Cloud provider solutions
  • Kubernetes operators
  • Custom scripts

What's next

1. 1.
   Check Database Schema for technical details on schema and query capabilities.
2. 2.
   Required and optional PostgreSQL Extensions