Installation Questions¶
Why do the App and Clinical databases need to be on the same server?¶
Answer
UPDATE 2022-05-05 - As of Leaf v3.11, the App and Clinical databases do not need to be on the same database server.
Old answer (pre-v3.11): The reason for this is that after Leaf has executed a ‘Find Patients’ query, it caches the patient IDs in the app database. When users navigate to the ‘Visualize’ or ‘Patient List’ screens, Leaf performs a JOIN query between the cached patient IDs in the app database and patients in the clinical database to quickly retrieve patient demographics. Thus currently both databases need to be on the same server in order for the JOIN operation to work.
I'd like to use an RDBMS besides SQL Server. Does Leaf support any?¶
Answer
As of Leaf v3.11, Leaf does! For the Clinical DB, Leaf supports:
Note that the Leaf App DB must be deployed using SQL Server, however.