Also, what are the realistic limits using sqlite over a true SQL database? If I were to do an online backup using the sqlite backup I assume this grabs everything in the index folder and the images (dicomstorage) would still need to be copied separately?
Also, what are the realistic limits using sqlite over a true SQL
database? If I were to do an online backup using the sqlite backup I
assume this grabs everything in the index folder and the images
(dicomstorage) would still need to be copied separately?
In theory SQLite guarantees atomicity and uncommitted changes should
not impact data integrity. Similarly Orthanc's storage is content-
addressed and uses immutable objects, and as such should provide data
integrity on its own.
I still wouldn't recommend doing online backup from under Orthanc.
Instead, consider transferring the data via Orthanc's HTTP API.
You cannot safely do a hot backup of a SQLite database. If you need hot backup, either run the replication procedure (which uses the REST API), or switch to a PostgreSQL database.