Is SQL Lite robust enough?

[Shawn Anderson]

Does anyone have any experience using a SQL Lite database with say, 100 concurrent users?

Would that be a foolish thing to do when one has a MySql server available?

The main thing I like about using a SQL Lite db is the simplicity of backup and restore (a simple file copy).

I'm worried that it would be robust enough. This particular application would only have 3 or 4 tables and would use simple queries.

Suggestions? Comments?

[Chris Holbrook]

Does anyone have any experience using a SQL Lite database with say, 100 concurrent users?

If you are thinking of using naked SQLite for this, why not post on [email protected] and get it from "the horse's mouth"? Quite possibly the question has already been answered in that forum.

Let us know what they say!

[Shawn Anderson]

Thanks Chris, I did.

I've read many things, some conflicting, about concurrent users on a Sqlite database. The feeling I get is that Sqlite is good for a standalone desktop database, but should not be used in a concurrent user situation (like a website with many users).

I'll let you know what sqlite-users say.

[Chris Holbrook]

The feeling I get is that Sqlite is good for a standalone desktop database, but should not be used in a concurrent user situation (like a website with many users).

I won't try to guess their answer, but Q5 in their FAQ is relevant. It would be interesting to test it with 100 users!

Maybe a SQLite-based server such as SQLitening would help, have you thought about using it?

[Shawn Anderson]

Yes, #5 ( http://www.sqlite.org/faq.html#q5 ) exactly explains how this works. It looks like it could be handled.

I'd love to find somebody with real-world experience with lots of users.

[Paul Squires]

There is also info on the SQLite site as follows:

http://www.sqlite.org/whentouse.html

Websites
SQLite usually will work great as the database engine for low to medium traffic websites (which is to say, 99.9% of all websites). The amount of web traffic that SQLite can handle depends, of course, on how heavily the website uses its database. Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite. The 100K hits/day figure is a conservative estimate, not a hard upper bound. SQLite has been demonstrated to work with 10 times that amount of traffic.

I bet that Fred and mine's SQLitening would work well for you. It is a pretty good client/server implementation of SQLite.

[Chris Holbrook]

I wouldn't be too impressed by the hits per day statistic. The crunch comes when they all want to save data at the same time, like when it's time to go home.

You're not powering the world's stockmarkets by any chance?