Stream: ibm
Topic: other database supported?
Xiaocheng Luan (Nov 07 2019 at 19:18):
Besides DB2 and Derby, would the FHIR server work with other database systems, e.g., MySQL, through configuration (i.e., without code customization)?
Lee Surprenant (Nov 07 2019 at 19:31):
Thanks @Xiaocheng Luan. You are correct that we've only tested with DB2 and Derby to date. It is possible to run Derby in "Network" mode instead of Embedded. But for MySQL support I think you'd definitely need some minor tweaks to the SQL.
Xiaocheng Luan (Nov 07 2019 at 19:33):
Got it, thanks! In that case, will play around with Derby first and see how it goes...
Lee Surprenant (Nov 07 2019 at 19:33):
great, we're definitely around so just ask if you have any questions
Lee Surprenant (Nov 07 2019 at 19:34):
If you do want to attempt MySQL, we'd love to hear where it falls over. Our Db2 schema actually makes use of a couple stored procedures (for performance), so I think you'd be best served by tweaking the Derby logic for MySQL.
Last updated: Apr 12 2022 at 19:14 UTC
