Click here to Skip to main content
13,091,145 members (62,468 online)
Rate this:
Please Sign up or sign in to vote.
See more:

We can embade sqlite as beckend and it works fine with desktop application.
But what if we embade it for website? In web site multiple user will connect to the database concurrently.

Will it work fine with Please explain.
Posted 9-Sep-11 20:38pm
Updated 9-Sep-11 20:47pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Multiple connections can be taken to SQLite. However, when modifications are made, only a single transaction can modify the data at any time. So if you're planning to have a high amount of concurrent modifications, I don't believe that SQLite will scale very well.

More info, see:[^]
mmdullah 10-Sep-11 2:53am
Thanks for your solution. I need not high amount of concurrent modifications, but I need concurrent modification. Number of my web user will be 20-50. but I need concurrent access of the database.
Mika Wendelius 10-Sep-11 2:56am
SQLite locks the whole database for the time of the modification so it sounds like you should have a look at for example SQL Server Express Edition :[^]
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

If you are using it for reading, then Sqlite is fine. If you want to have multi user writes, then I would STRONGLY suggest that it is a bad solution, and you should look at a either MsSQL or MySql - they are specifically designed for multiuser and should give you a lot less problems.
mmdullah 10-Sep-11 2:58am
Actually I need an embaded database. Thats why I need it. Also There will be small workload from the users but I need the concurrent access to the database
OriginalGriff 10-Sep-11 3:55am
None of the embedded databases support concurrent updates well - they all lock the file for the update period. You really would be better off with a "proper" multiuser database.
mmdullah 11-Sep-11 2:18am
Would you please suggest any multiuser embadable database?
OriginalGriff 11-Sep-11 3:30am
As I said: "None of the embedded databases support concurrent updates well"
You need to move to a non-embedded database: the code is a lot more complex and only really works if you have a single application talking to the database, and a bunch of applications then talk to it. Look at MsSql (there is a free, Express version) or MySql. Most hosting providers provide one or the other if you are not handling the hosting yourself.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.170813.1 | Last Updated 10 Sep 2011
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100