]
07-20-2023, 02:48 PM
This question cannot be answered without considering the requirements of storing those binaries vs. the requirements of storing the structured data.
For structured data we will typically have ACID and if that is also a requirement for the binaries, then there is no alternative to storing them in the database.
Another requirement that might exist is horizontal scalability. If we need that and can ditch ACID, then a solution like S3 or min.io could work.
The filesystem becomes an option only if we can ditch ACID as well as horizontal scalability. But then it is a very efficient option.
For structured data we will typically have ACID and if that is also a requirement for the binaries, then there is no alternative to storing them in the database.
Another requirement that might exist is horizontal scalability. If we need that and can ditch ACID, then a solution like S3 or min.io could work.
The filesystem becomes an option only if we can ditch ACID as well as horizontal scalability. But then it is a very efficient option.