If you want to know more of the origins of SQLite I can highly recommend this episode of the Corecursive podcast

https://corecursive.com/066-sqlite-with-richard-hipp/