Persistent SQLite Index DB on AWS EBS or EFS

Hello everyone,

Apologies in advance if this might have been answered previously. I searched both forum and manual, but I couldn’t find an answer specific to my question.

I will be running Orthanc as a container on a private EC2 Instance using the S3 plugin for storing the DICOM files.

I understand that the SQLite database index is stored “locally” on the server, or can alternatively be stored in a separate database, in which case it requires switching to PostgreSQL, MySQL or ODBC.

I’d like to stick to the built-in SQLite database index, but I’d like to decouple it from the EC2 instance itself.

Is it possible to “mount” it to an EBS volume or EFS file system?

Many thanks.

I don’t have any experience in this, but it is worthwhile trying and reporting back to see how it goes.

An alternative might be https://litestream.io which will allow you to stream the sqlite to S3 for backups and replication.

HTH

1 Like

Hello @antonioriccelli

We are using Orthanc instances with the SQLite files stored on EBS volumes and this is working well for us.

HTH

1 Like

Hi @benjamin.golinvaux,

Thanks for confirming this. By any chance, are you deploying instances via ECS or just as standalone servers on which you later install Orthanc?