TechnoguyficationGarage is an open source S3-compatible object storage cluster designed for self hosting
Thoughts on this vs postgres blob storage? I know they aren’t the same thing.
adr1anBuckets have a lot of features that postgres don’t. Like mounting via FUSE. And Garage in particular offers some integrations to apps, websited, and so on. I would go with this instead of having a column of byte data in a DB table. The pgsql solution might work in small and simple cases (e.g. storing the user’s avatar in a forum) but even so, if I could or had to choose, I wouldn’t do it.
Great points.
For isolated projects in the past I’ve had great success storing things in postgres,. (generally large documents that are relationally tied to other more traditional PG data, in a db driven project) Just saying size and recall have been pretty happy.
As you say the other features are distinguishing.
I’m always personally wary of storing blobs in a database if for no other reason it’s going to totally be more expensive to store on a server rather than in some sort of blob storage.