Skip to content

Mirth and FHIR #4648

Answered by narupley
rjkroll asked this question in Q&A
Jul 23, 2021 · 1 comments · 1 reply
Discussion options

You must be logged in to vote

The reason why XML is stored in the database is so that we could leverage XPath queries to do some more advanced things:
destination-search-script.js#L111
Search Utility Methods.js#L56

Yep, there's absolutely nothing stopping you from using JSON instead of XML. Recent versions of PostgreSQL support the JSONB data type with JSONPath functionality too I think. You're right, using the one monolith "resource" table would probably not scale well in the long run. You could perhaps only store the most recent version of a resource in that table, and store historical versions elsewhere. Or maybe you want to use a completely normalized table structure where resources actually get split up and store…

Replies: 1 comment 1 reply

Comment options

You must be logged in to vote
1 reply
@rjkroll
Comment options

Answer selected by rjkroll
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet
2 participants