3 ms·
SQLite is a fantastic database for desktop applications. https://www.sqlite.org/appfileformat.html https://www.sqlite.org/appfileformat.html is a great essay on
by simonw 9y ago
SQLite is a fantastic database for desktop applications. https://www.sqlite.org/appfileformat.html https://www.sqlite.org/appfileformat.html is a great essay on its benefits for this kind of use-case.
- redwolf2 9y agoNot only desktop, but most mobile platforms as well. Beeing coded in a single C file makes it portable as hell. Their documentation is also a prime example, with great insight.
- cheez 9y agoIt's not coded that way, it's combined as part of a script.fd
- fnord123 9y agoNot only desktop and mobile, but it can be used as the storage format for larger scale distribued systems. For example it's the on disk format for FoundationDB. >Beeing coded in a single C file makes it portable as hell. It's not coded in a single C file...
- simonw 9y agoIt kind of is... the SQLite "amalgamation" process takes all of SQLite's source code (across 100+ files) and concatenates it together into a single sqlite3.c file: https://www.sqlite.org/amalgamation.html https://www.sqlite.org/amalgamation.html
- fnord123 9y agoThat's horrifying and interesting. Thanks for linking it! I wonder if the alleged 5-10% performance gains are compared with usage of LTO.
- simonh 9y agoA fun trick is to ask a colleague at work how many SQL databases they think are in the room. They almost never bear in mind SQLite is heavily used on phones, not even just smartphones.