I used SQLite for a few applications several years ago. One time, the database got corrupted and all the data was lost. That was the day I stopped using SQLite.

Also, the lack of enforced column data types was always a negative for me.