2 ms·
Why don’t more people store all the uploaded files inside BLOBS in a relational database instead of a file system? What are the downsides? I see the biggest do
by EGreg 4y ago
Why don’t more people store all the uploaded files inside BLOBS in a relational database instead of a file system? What are the downsides?
I see the biggest downside being that the webserver will call your PHP app which will then proxy the data through itself one time. Well, maybe you can use ReactPHP or Swoole and then it’s faster than Node.js even…
Also you then have more programmable options, for example around access control lists or capabilities to access stuff, caching and expiring caches.
How does MySQL compre to ext3 for storing terabytes of data?
As a side note - what do y’all think of FUSE to Amazon S3? Just map a path to it and let it do the rest. GOOFYS I think skimps on the POSIX compliance in favor of speed.
- Gigachad 4y agoYou usually want as much of your database stored in memory as possible. Binary blobs would bloat out the db pretty quick. Fuse for s3 might work but you risk the chance of a generic abstraction triggering a massive set of actions that cost a lot. Something like running find or checking the size of a directory could end up costing you thousands.