All geek questions in one place

Easy client / server database?

I like the simplicity of SQLite, but by design it does not support concurrent access. The applications that I write do not have heavy needs, so I would like to avoid more difficult solutions, such as MySQL, which are more difficult to deploy (remote clients usually do not have a personal computer).

Does anyone know of a good solution that will offer the following features?

  • Client is available for VB.Net applications
  • The server itself should not be a .Net application. In fact, I would prefer a white metal server so that it can work even on embedded Linux hosts with less RAM / CPU than a regular PC
  • Easy installation: the client should either be statically linked inside the client application, or be accessible as a separate DLL, and the server should just be one listening to EXE requests, à la Fossil ( http://www.fossil-scm.org )
  • clients can find the server on the local network by transmitting data collected by the server, so users do not need to record the IP address and insert it into each client
  • open source or reasonably priced.
+3
source share
4 answers

I would recommend Firebird SQL http://www.firebirdsql.org

It can be built-in and can work as a separate server. Very little space with high features.

+1
source

SQL Server? Compact Edition (, ), Express Edition ( , , ), , .

0

HSQLDB is also very lightweight, and the upcoming 2.0 release will support concurrency in the form of MVCC. It is based on Java, but there is an ODBC connector available.

0
source

You can also consider Derby ... Its free and open source.

0
source

Source: https://habr.com/ru/post/1743335/

More articles:


All Articles