4 ms·
Why not start with SQLite? There are benchmarks out there proving that for some use cases (i.e. many small updates) where using SQLite is faster than using the
by lpapez 2y ago
Why not start with SQLite?
There are benchmarks out there proving that for some use cases (i.e. many small updates) where using SQLite is faster than using the filesystem. [1]
So not only do you get all of the benefits of a relational database, and literally centuries of engineering hours and bugfixes invested into SQLite, you might also get better performance (which is why I presume you even considered rolling your own).
[1] https://www.sqlite.org/fasterthanfs.html https://www.sqlite.org/fasterthanfs.html