SQLite can probably handle a lot of SELECT queries at once, but only one process can be writing to the database at once. I think it's a hard question to answer

SQLite can probably handle a lot of SELECT queries at once, but only one process can be writing to the database at once. I think it's a hard question to answer, "what's the upper limit on SQLite?" Better question would probably be, "We have this app, what database should I use?" I use SQLite for a lot of smaller apps. Applications that have a focus on single-business, low-volume use. They might do a good amount of computation and data-fetching, but they don't make heavy use of the database. If you need features Postgres has, use that. If you need features MS SQL has, use that... if you don't need anything special, think about using SQLite :)