5 ms·
sqlite files are binary files, so a non-starter. If I open them in Notepad I can't read the values like I can with CSV.
by unnouinceput 5y ago
sqlite files are binary files, so a non-starter. If I open them in Notepad I can't read the values like I can with CSV.
- postalrat 5y ago"If I open them in Notepad" Well there's your problem.
- munk-a 5y agoThere is a definite demand for some import format that you can trivially edit - CSV excels at this right now and JSON isn't that bad. Binary dump formats definitely do have a time and a place but there is also a separate need for trivially human readable formats.
- postalrat 5y agoI guess my point is that CSVs or any text files aren't really "human readable". You still need some application top view them.
- HanaShiratori 5y agoSo what's the alternative? Good old pen and paper?
- vertere 5y agoDoesn't count, you still need light to make it human-readable. /s
- icelancer 5y agoI can - and do - read a CSV by opening it in Notepad++ to view basic data. This isn't possible with a SQLite file.
- creata 5y agoIn some incredibly pedantic sense, sure. But the difference is that every computer comes with what a human needs to read a CSV file. That's not true of an SQLite database.
- euroderf 5y agoHow about an app that opens an SQLite DB so that strings and numbers can easily be edited, and then on file save, SQLite's internal pointers and markers are updated ? Maybe an Emacs mode ?