My technology is document database bla, bla It's cool in ..... We store FHIR resources this way....
How to setup env and load data into database
Short description of database schema Example how to store and retrieve resource from you database
INSERT INTO patient (id, resource)
values ('pt-1', '{"name": [{"given": ["Nikolai"]}]}');
SELECT resource FROM patient;
How to search specific resourceType by specific element
SELECT resource
FROM patient
WHERE resource#>>'{name,0,given}' ilike 'Niko%'
;
More complicated queries
SELECT resource
FROM patient
WHERE
resource#>>'{name,0,given}' ilike 'Niko%'
AND
resource->>'birthDate'::timestamp > '1970'
;
How to represent references between resources
How to search and retrieve related resources
More complicated queries with aggregation etc