sqlite as beckend in asp.net website

Question

0.00/5 (No votes)

See more:

Hello,

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

Will it work fine with asp.net? Please explain.

Posted 9-Sep-11 20:38pm

mmdullah

Updated 9-Sep-11 20:47pm

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Wendelius · Answer 1 · 2011-09-09T20:46:00

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: http://www.sqlite.org/faq.html#q5[^]

Posted 9-Sep-11 20:46pm

Wendelius

Comments

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.

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 : http://www.microsoft.com/sqlserver/en/us/editions/express.aspx[^]

OriginalGriff · Answer 2 · 2011-09-09T20:52:00

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.

Posted 9-Sep-11 20:52pm

OriginalGriff

Comments

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.