Fun fact: Fossil uses sqlite. And sqlite uses fossil. Think about that.
SQLite is what I consider a well-engineered product.
And Richard Hipp is an excellent engineer. Listen to his podcast episodes on the changelog. It's fun. His mentality is interesting.