I found the final part of the podcast [1] where DRH talks about having a design for a "Git killer" intriguing. He describes it as a possible future project distinct from Fossil, which he calls only an incremental improvement upon Git. I would have liked to hear more of a hint at the novel design involved, though. Before that DRH discusses his early career and how SQLite and Hwaci came to be, which was also interesting.
Overall, I thought the podcast was well worth listening even if you're reasonably familiar with SQLite itself and its history.
Has someone a speech regognition software like Dragon NaturallySpeaking on hand to create a transcript? 1:23 is too long, and a transcript would be handy to skip through the interview.
i'm richard have been you're listening to the change log and have it type collector who won this bit she's long time they're both have people get this this episode two zero and the invaders now i've got to purchase this creature
If anyone knows how to train Sphinx to understand technospeak, I would love to know also.
I found this episode very interesting, especially the discussion of the long term support contract required by Airbus since SQLite is used on some aircraft.
Hopefully, this one is more informative, than another one from couple years ago, which was disappointingly untechnical (and SQLITE is not a trivial piece of software, despite what one may think, just try to understand the semantics of error handling when it comes to rollbacks, for example).
"Why is SQLite so ubiquitous?" "Its goal is that it just works .... Apparently we win competitions ... I don't know why or how." 30:20
"SQLite is ... not client-server. Why didn't I do this? ... I'm not a database person. I didn't know I was supposed to." 34:25
On "flexible typing" 40:22
"People tell me I could have made a lot of money off this if I had any business sense .... But you know what? We make enough." at 1:06:10