Hello,
I noticed that avatars and attachments go to files directory as the config.yml states. However this results a bit uncomfortable since all data reside in the database.
Is a good idea put the attachments into the database or at least have a config option to do that? A lot of applications, usually, operate in that way.
Thanks.
As far as I know it’s not really a thing to put binary blobs of files in the db. It is certainly possible but I don’t know any advantages of it once you start to add bigger files to it.
What other applications do you know which do this?
request tracker (rt) - bugzilla - crm like sugarcrm/suitecrm - smf forum - and so on
If for example I would like to run Vikunja over a galera cluster, I need to find a way to replicate/propagate files.
Anyway, for what I’ve seen until now, usually, applications put everything into a db, so that means that a database dump has everything instead of collect all pieces.
That’s nice when you have a few files but once you have multiple GB (or even TB) of data the backups will balloon in size.