3 ms·
I would presume there’s a tipping point where storing media as a SQLite database becomes irresistible, since the hard drive could DMA a giant file of this sort
by hinkley 3y ago
I would presume there’s a tipping point where storing media as a SQLite database becomes irresistible, since the hard drive could DMA a giant file of this sort into memory as a giant linear read.
- ElectricalUnion 3y agoAs-is (no need for a future tipping point), for most applications, it's already a SQLite database. https://www.sqlite.org/appfileformat.html https://www.sqlite.org/appfileformat.html > Conclusion > SQLite is not the perfect application file format for every situation. But in many cases, SQLite is a far better choice than either a custom file format, a pile-of-files, or a wrapped pile-of-files. SQLite is a high-level, stable, reliable, cross-platform, widely-deployed, extensible, performant, accessible, concurrent file format. It deserves your consideration as the standard file format on your next application design.