SQL on FHIR in PostgreSQL

Two types of SQL on FHIR View Runners - ETL (in-memory) & ELT (in-database) and demo the ELT implementation for PostgreSQL using: Aidbox Open-source ViewDefinition Builder Grafana

The slides FHIR Database & FHIR Server for FHIR-first appsSQL on FHIR RunnersETL: in memory runnerETL: in memory runnerELT: in-database runnersCompare ETL and ELTFHIR Server with SQL on FHIRHow to store & query FHIR in PostgreSQLTranslate ViewDefinition to SQLHow does translation worksWhat we can do with view def (query) Run aidbox:

mkdir aidbox && cd aidbox curl -JO https://aidbox.app/runme && docker compose up

in aidbox sandbox - https://aidbox.app

in viewbuilder - https://sqlonfhir.aidbox.app

Related article - SQL on FHIR: What is a ViewDefinition, and how does it work?

Author: Nikolai Ryzhikov, CTO at Health Samurai

See also: SQL on FHIR: What is a ViewDefinition?.