I use SQLite for web apps and I don't think there's any reason not to, since my sites receive around 200/300 pageviews a day on average.