Is SQLite suitable for a RESTful web service? It would handle a website with a moderate traffic (about 10 million requests per month). From what I've read SQLite is very underestimated and can be really performant. Is it performant enough to handle this with ease?
Edit: I am using .NET
The issue with SQLite isn't performance per se, but specifically performance with simultaneous queries. For just SELECT queries it could very well handle that kind of load, but if there are more than a few UPDATE queries it'll struggle. Something like PostgreSQL would be a much better choice, and it's easy to set up with most distributions and with packages for most platforms.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments