Joplin Server: Use Postgress or Storage Driver

Support
1

Operating system

Linux

Joplin version

3.0.13

Sync target

Joplin Server

What issue do you have?

Hi,

my local joplin consists of more than 23000 elements, rapidly growing.

Should I use the standard Postgress DB or switch to local storage with Storage Driver variable?

What about backups? What is more convenient?

2

SQL DBs are not designed to store unstructured binary data.. you can do but it doesn't scale well. I think storage drive is more efficient.

But as long it works for you it should be good. In this case you only need to backup your DB and everything is good. It your number/size of attachments is growing storage drive help keeping your DB small but make backup (little) more complex - you need to backup both DB and storage.. but this has advantages as well - you can to incremental/differential backups only backup new/changed files, while for DB storage you always have to backup full DB.

3

And storage drive can aslo be used whenJoplin server runs as a docker container? Or only on local file systems

4

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.