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

AidboxDB Distribution

• AidboxDB is a PostgreSQL distribution based on the official PostgreSQL release
• Includes Aidbox-specific extensions and the WAL-G backup tool
• Standard PostgreSQL installations remain fully supported

What's next

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