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
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
Get in touch with us today!