Search code examples
databasems-accessconcurrencyberkeley-db

File database suggestion with support for multiple concurrent users


I need a database that could be stored network drive and would allow multiple users (up to 20) to use it without any server software.

I'm considering MS Access or Berkeley DB.

Can you share your experience with file databases?
Which one did you use, did you have any problems with it?


Solution

  • I would suggest SQLite because the entire database is stored in a single file, and it quite safely handles multiple users accessing it at the same time. There are several different libraries that you can use for your client application and there is no server software needed.

    One of the strengths is that it mimics SQL servers so closely that if you need to convert from using a database file to a full-fledged SQL Server, most of your queries in your client won't need to change. You'll just need to migrate the data over to the new server database (which I wouldn't be surprised if there are programs to convert SQLite databases to MySQL databases, for example.)