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

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

  • Backup/Restore: Use standard PostgreSQL methods:

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

Last updated

Was this helpful?