Re: Where to store Blobs?

2019-04-22 Thread Jamesie Pic
Thanks for your feedback. In my case, Bob the manager said this would "make backups easier" xD The general pro that I see is "transactional". While I can understand that, it's irrelevant in our case: users upload files through AJAX, that happens **before** they submit the form. That means, the fil

Re: Where to store Blobs?

2019-04-19 Thread Jamesie Pic
I forgot to mention that my deployments include automated migrations as often as possible, sometimes destructive for refactoring purpose, as such, to maintain PostgreSQL on a basic linux box I am: - for having an automated backup prior in the automated deployment script that may play destructive m

Re: Where to store Blobs?

2019-04-19 Thread Jamesie Pic
Storing files in the database has already been demonstrated as not an efficient trade-off [0]. As such, this post provides a subjective story about files in the database, rather than an objective compare. So, I have this ridiculous situation where dumping a database with 12k user-submitted forms w

Re: Where to store Blobs?

2019-03-13 Thread Jamesie Pic
Make dump/restore of database data unnecessarily expensive in terms of time and space imho.