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
extensionActively 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
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
Check Database Schema for technical details on schema and query capabilities.
Required and optional PostgreSQL Extensions
Last updated
Was this helpful?