docker icon indicating copy to clipboard operation
docker copied to clipboard

Question about multi-location / multi-user sqlite setups

Open Virgus opened this issue 1 year ago • 0 comments

Hello I'm a new Wallabag user and I just took example from this docker compose file to set up Wallabag with sqlite database.

Since in my use case I'll be in France or in Italy and will need to access my links also in case of faulty connection (or in case my raspberry goes down as sometimes might happen) I chose to avoid using maria-db. This would give me the option of easily migrating the saved images/files, with the sqlite database and just change the server url in the mobile app.

A first question about this setup: what composer entry could I use to store the sqlite database file with the rest of the data ? Alternatively how can I export/import the sqlite file from one container to the other to manually sync the two ? Would it be necessary to wipe the android app cache at every server swap or just updating the sqlite and other files would be fine ?

Second issue: while in France I would be the only wallabag user while in Italy the users will be two. To get a fast usable setup I simply created two separate containers for each user and two subdomains. In this particular case are there other better solutions ?

Thanks for this wonderful tool. I've been looking for something like this for so long ! V.

EDIT: I just double checked for wallabag.sqlite file and added the following line to the volumes section of the docker compose file. - /DATA/AppData/wallabag/sqlite:/var/www/wallabag/data/db Unfortunately, with that extra line, the container exits right after start and Portainer gives me Exit code 1 Status "Unhealty". I'm not skilled enough (yet) to troubleshoot this. Any help will be greatly appreciated.

Virgus avatar Jun 23 '23 19:06 Virgus