I am searching a multi user database without server

Question

1.16/5 (4 votes)

See more:

I am a desktop apps developer,
I have to create a Multi User Application
Without Hard process to installation at client side
I want to just install a application like portable mode.
So i want a Suggestion for Database for faster
And Multiuser same time.
Please Suggest

What I have tried:

Sqlite,access database tried myself

Posted 18-Oct-22 7:51am

Soft Management

Updated 18-Oct-22 23:57pm

Add a Solution

Comments

Dave Kreskowiak 18-Oct-22 19:11pm

Without a server, and a server-based database engine, you don't have a multi-user database.

3 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)

Richard MacCutchan · Answer 1 · 2022-10-18T08:00:00

Solution 1

SQL Server[^] is most likely the best choice.

Posted 18-Oct-22 8:00am

Richard MacCutchan

Comments

Soft Management 18-Oct-22 14:03pm

But my clients couldn't Install Sql server properly and it takes times to install it

Richard MacCutchan 18-Oct-22 14:08pm

Sorry, that is not something we can help with.

OriginalGriff 18-Oct-22 15:20pm

He's been trying for a couple of days to use a single user Db in multiuser - and doesn't like the answer "for the sake of everybody's sanity, don't do it". :sigh:

I'm guessing he'll go ahead with his plan, and spend the next few years picking up the pieces after it all goes pear shaped. Some people just don't want to listen when they ask a question.

Richard MacCutchan 18-Oct-22 16:28pm

And I get the impression someone is actually paying him. Well good luck to them all.

OriginalGriff 18-Oct-22 17:35pm

I do hope not ... :D

merano99 · Answer 2 · 2022-10-18T08:49:00

Solution 2

Whats wrong with SQLite?
Note1: "SQLite is an open-source, embedded, relational database management system. It is a lightweight database, with zero configuration, no requirements of a server or installation. Despite its simplicity, it is equipped with common functions of database management systems."

Note2: "The fact that the entire database is portable as a single file made migrating content from one system to another easy and fool-proof."

//Edit: Various limitations should be considered.
SQLite Frequently Asked Questions[^]

Perhaps you will also look at:
https://www.g2.com/products/sqlite/competitors/alternatives[^]

Posted 18-Oct-22 8:49am

merano99

Updated 18-Oct-22 13:11pm

v2

Comments

k5054 18-Oct-22 17:12pm

SQLite is not a "multi-user" database. The entire database is locked for update. There are many use cases where that is not acceptable. The OP needs to either go with a DB that can do the heavy lifting for them, or will need to "roll your own" data access, which, of course, is far more difficult than plugging in to SQLServer or Postgresql or MySql.

merano99 18-Oct-22 19:04pm

Thanks for the advice. So sure, various limitations should be considered.
Multiple users would work - but just not well in parallel and I didn't assume "heavy work".
At least SQLite uses reader/writer locks and seems to contain synchronization for multiple processes and is (allegedly) threadsafe. For Windows more restrictions are documented, but usually multiple users don't really work in parallel on a Windows desktop system.
Restrictions are mentioned here:
https://www.sqlite.org/faq.html#q5

The questioner does not tell us whether multiple users actually work in parallel, whether multithreading is necessary, and whether multiple users should be able to write at all. I interpret in the given information that the database does not have to be networkable, at least it is not explicitly required.

If one actually has very high requirements, the effort will be accordingly high.

Soft Management 30-Oct-22 12:40pm

Right... Already Using Sqlite For Single User Database

Alexandrnn · Answer 3 · 2022-10-18T23:57:00

Solution 3

I have a library for creating and working with fields in DBF tables. For the windows API, a DLL or object library. There is no SQL-transact capability. It is possible to connect tables via ODBC to MS Access or other SQL systems in order to access tables via SQL-transact.

Posted 18-Oct-22 23:57pm

Alexandrnn

Comments

Soft Management 30-Oct-22 12:42pm

Where I can Get thease Library and Documents For Testing In My Project?