Which database to choose?

Question

I have the following criteria

• The database must be protected with a username and password. It is not possible to copy the database file and use it otherwise than MS Access.

• There will be no central database server. Each machine will start its own database server locally, and the user will begin synchronization. The concept is based on a distributed version control system, such as Git. Therefore, it must have good replication support.

• Strong consistency is not required. If necessary, users will synchronize the database with each other. In case of conflicts, it should be possible to find the conflict and present it (from the application) to the user to correct it.

• Revision of data, if available, would be good. For example, the entire invoice change history.

• I have researched a document-oriented database and am inclined to do the same. But I do not know what to choose.

• The database is small, it will not even reach 1 GB in the next few years (say, 3 years).

Please feel free to suggest any database that you think might be appropriate. Any pointers are highly appreciated.

Thanks in advance.

Answer 1

The following is what I'm looking for:

: CouchDB - , .

, CouchDB , . , ( , ) , , .

, couchDB ? Mysql . , - . , . .

Answer 2

. . Bestpractical Prophet ( SD- ). , , , ( ).

, , - :

, , , , , .

Answer 3

, ClipMate , " ".
(DBISAM Elevatesoft, , Delphi) " " Armadillo.
, - , ( CD) . , " " ( Armadillo). ethernet, , .., , . , , /. "" , , . , . . , , .

In any case, to repeat: the database is encrypted, and the encryption code is only available (to the program that reads the database) when the program is correctly registered on a specific user / computer.

You CAN do this with Access, MySQL, etc. Just encrypt the data either at the database level (I suppose they support this, no?), Or at the field level if you want to get the final control and in order with using a custom external application to read the thing.