News for hackers. Stuff that matters.

A comment on We’re happy with SQLite and not urgently interested in a fancier DBMS (2016). Parent comment

Re:We’re happy with SQLite and not urgently interested in a ... by redwolf2 on Friday May 04, 2018 @01:23PM (#16996333)
Not 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.
[ Parent | on HN ]
Re:We’re happy with SQLite and not urgently interested in a ... by simonh on Friday May 04, 2018 @01:50PM (#16996611)
A 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.
[ Parent | on HN ]
Re:We’re happy with SQLite and not urgently interested in a ... by fnord123 on Friday May 04, 2018 @01:36PM (#16996463)
Not 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...

[ Parent | on HN ]
Re:We’re happy with SQLite and not urgently interested in a ... by simonw on Friday May 04, 2018 @01:42PM (#16996522)
It 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
[ Parent | on HN ]
Re:We’re happy with SQLite and not urgently interested in a ... by fnord123 on Friday May 04, 2018 @02:08PM (#16996779)
That's horrifying and interesting. Thanks for linking it!

I wonder if the alleged 5-10% performance gains are compared with usage of LTO.

[ Parent | on HN ]
Re:We’re happy with SQLite and not urgently interested in a ... by cheez on Friday May 04, 2018 @01:33PM (#16996430)
It's not coded that way, it's combined as part of a script.fd
[ Parent | on HN ]