ebvtrnog
ebvtrnog

Reputation: 4377

SQLite for a RESTful web service

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

Upvotes: 1

Views: 230

Answers (1)

user554538
user554538

Reputation:

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.

Upvotes: 2

Related Questions