3 ms·
If you're using SQLite as a pile of files, you're not doing much querying if the compressed data inside. > Newer machines are faster, but it is still bothersom
by tedunangst 8y ago
If you're using SQLite as a pile of files, you're not doing much querying if the compressed data inside.
> Newer machines are faster, but it is still bothersome that changing a single character in a 50 megabyte presentation causes one to burn through 50 megabytes of the finite write life on the SSD.
That's funny, since Firefox would burn through gigabytes of writing to SQLite. All comes down to quality of implementation.
- manigandham 8y agoThe point is that you don't just use it as a pile-of-files when you have SQL access to the data and instead use a high-level data model. This is not possible at all with ZIP.