Stream: implementers
Topic: SQL
Gustavo Jose Marcano Valero (May 31 2021 at 11:40):
Good morning everyone, hope you are all doing well. I am new working with Fhir, so I was wondering if there is a way to generate the whole Database model in MSSQL, where I can see all the tables and relations and constraints
Josh Mandel (May 31 2021 at 12:33):
We don't have a standard/recommend way to represent FHIR in SQL; many real-world servers that provide FHIR API support on top of a relational database wind up using techniques like JSON columns for core resource content, plus explicit indexes for search parameters
Josh Mandel (May 31 2021 at 12:35):
If you're asking about db schema as a kind of educational tool for visualizing the spec rather than an operational tool for hosting a DB, that's an interesting twist.
Gustavo Jose Marcano Valero (May 31 2021 at 12:42):
Oh thanks very much @Josh Mandel , Is just that I was going over the directories of the localserver and noticed there are a few sql files, and exactly what you said, it would be more of a educational purpose, though I am guessing there should be at some level relational database involved (in my humble opinion, and forgive me if I'm wrong), given that by default it is stored in SQLite
Josh Mandel (May 31 2021 at 12:55):
It sounds like you're not asking a question about FHIR but about a specific software project. Maybe #hapi ? (If so, I'd recommend asking in that channel.)
Yunwei Wang (May 31 2021 at 15:30):
And there is a #storage for FHIR steam for database related topics
Frank Oemig (May 31 2021 at 15:31):
It sounds like an endavour as HTB did in the past with V3. It's doable but most probably very inefficient because of many subtables.
Last updated: Apr 12 2022 at 19:14 UTC
