I use it for a personal notes app, any Android app I have made. I don't think I have needed a serious DB like postgres for any project in the last 5 years, sqlite has been more than enough.

If I were at the same scale as Facebook or Google I would probably pick something with a better concurrency story though.