OT, perhaps, but I thought this was fun: an interview with Richard Hipp, the creator of SQLite, with lots of details from the early days of SQLite. A podcast, but with transcript (July 2021).
SQLite with Richard Hipp
As a postgres aficionado, I especially like his story about the huge test-suite of SQL-statements that crashed all RDBMS-comers *except* PostgreSQL. But it also shows how well tested SQLite is. Hipp:
"Shane Harrelson did this for us about 10 years ago. He came up with this huge corpus of SQL statements, and he ran them against every database engine that he could get his hands on. We wanted to make sure everybody got the same answer, and he managed to segfault every single database engine he tried, including SQLite, except for Postgres. Postgres always ran and gave the correct answer. We were never able to find a fault in that. The Postgres people tell me that we just weren’t trying hard enough. It is possible to fault Postgres, but we were very impressed.
We crashed Oracle, including commercial versions of Oracle. We crashed DB2. Anything we could get our hands on, we tried it and we managed to crash it, but the point was that we wanted to make sure that SQLite got the same answers for all of these queries."