Re:File Attachments: Databases can now store files and images
by hot_gril on Thursday August 31, 2023 @02:30AM
(#37333252)
I'm on board with using temporary solutions for small projects, but I feel like BLOB isn't super convenient either unless you have some particular reason you only want Postgres as a dependency. I can either set up something like S3 where I upload via some simple API and get URLs to send back to clients, or I can build an image serving HTTP handler that queries the DB. The BLOB way is a little more manual if anything.
Similar story with caches. Sometimes I've used Postgres as a cache, but writing the little logic for that is already more hassle than just plopping in memcached or Redis and using a basic client.
Similar story with caches. Sometimes I've used Postgres as a cache, but writing the little logic for that is already more hassle than just plopping in memcached or Redis and using a basic client.