https://news.ycombinator.com/from?site=sqlite.org
* efficient
* easy to use
* well documented (docs not just extensive but readable)
* many very useful features
All this making it great for many side projects, which is what a lot of people are very passionate about.