Aidbox
Fhirbase
Case Studies
Company
FHIR Meetups
Contact us

SQL on FHIR in PostgreSQL

Nikolai Ryzhikov
November 8, 2024
5 min read

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 apps
SQL on FHIR Runners
ETL: in memory runner
ETL: in memory runner
ELT: in-database runners
Compare ETL and ELT
FHIR Server with SQL on FHIR
How to store & query FHIR in PostgreSQL
Translate ViewDefinition to SQL
How does translation works
What 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

How did you like the article?

contact us

Get in touch with us today!

By submitting the form you agree to Privacy Policy and Cookie Policy.
Thank you!
We’ll be in touch soon.

In the meantime, you can:
Oops! Something went wrong while submitting the form.

Never miss a thing
Subscribe for more content!

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
By clicking “Subscribe” you agree to Health Samurai Privacy Policy and consent to Health Samurai using your contact data for newsletter purposes
1891 N Gaffey St Ste O, San Pedro, CA 90731
+1 (818) 731-1279
hello@health-samurai.io