3 ms·
You can also do the same with a file and you can even open it in plain text and read it too.
by encryptluks2 4y ago
You can also do the same with a file and you can even open it in plain text and read it too.
- Rapzid 4y agoI mean, the database IS a file. The key here is that it colocates indexes and other metadata that can be used to efficiently access large data sets without having to hand-roll indexes and/or process them on-the-fly everytime you load the data up...
- VHRanger 4y agoSQLite is made to replace "dread" by being generally better than storing the data as a json blob or csv There's still an argument for columnar formats like arrow, but compatibility is iffy compared to SQLite which "just works"