Overview

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. Check Database Schema for technical details on schema and query capabilities.
2. Required and optional PostgreSQL Extensions
3. AidboxDB