SQLite the only database you will ever need in most cases
I love SQLite, I do all of my projects prototyping before I move to postgres which is also awesome.
One if the major problems in facing is that heroku for example in every build will override/delete the SQLite DB since it treats it the same as every file - which is a shame.