SQL LITE is single user or database can be shared in LAN

Question

0.00/5 (No votes)

See more:

database

SQL LITE is single user or database can be shared in LAN?

Posted 24-Feb-13 18:30pm

Aarti Meswania

Updated 25-Feb-13 0:20am

v2

Add a Solution

2 solutions

Solution 2

Hi,

Check the following link...

Appropriate Uses For SQLite

[^]

one sqlite database to multiple autoit users[^]

Regards,
GVPrabu

Posted 25-Feb-13 0:48am

gvprabu

Updated 25-Feb-13 0:51am

v2

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)

OriginalGriff · Accepted Answer · 2013-02-25T00:46:00

Solution 1

SQLite can support multiple users across a lan, but I would strongly suggest against it.

It is a file based database system, so locks the file when it writes (as you would expect) and no other user can access the file until the write is complete and the lock is released. Which means you will have to code continually for "file in use" errors and retry, which is a PITA. In addition, the whole file will continuously be transferred across the network to each station when you query it, which can have a significant impact on performance.

If you want multiple simultaneous users, I would suggest you use a "proper" multiuser database like SQL server or MySql - it will save a lot of delay, and grief in the long run.

Posted 25-Feb-13 0:46am

OriginalGriff

Comments

Aarti Meswania 25-Feb-13 6:52am

can postgreSQL be used in LAN?

OriginalGriff 25-Feb-13 7:01am

Never used it, so I couldn't comment. But given that MsSql and MySql both have free editions, I'd go with one of them if I could.

Aarti Meswania 25-Feb-13 7:06am

Is MS-SQL free?
I want to use it in LAN/WAN As shared database

OriginalGriff 25-Feb-13 7:09am

The Express edition is:
https://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx

It has a few limitations, but probably nothing you need to worry about unless your DB starts to get huge.

Aarti Meswania 25-Feb-13 7:11am

and one last query :)
SQL Express edition will not allow to share database on LAN/WAN I mean not support remote connection, right? It's standalone edition. Am I right?

OriginalGriff 25-Feb-13 7:27am

"Am I right?"
No - it's the full monty. Network connections, internet connections (if you like to risk your data) - the express version has pretty much everything the full one does.
See here: http://www.sqlmag.com/article/sql-server/sql-server-express-2012-editions-143625

Aarti Meswania 25-Feb-13 7:59am

but sql-server-express-2012 editions donot provide agent service so, how it will possible to establish remote connection?

Aarti Meswania 25-Feb-13 8:10am

Thank you for clear my doubts and provide support so kindly.
:)