Sql-server – Which database is best for deeply embedded database or through C DLL

encryptionfull-text-searchMySQLrdbmssql server

I want a deeply embedded database. Deeply embedded means that the server is started by an application and closed by the application with no tcp/ip or 0 port. The main features of consideration are:

  1. At least 10 GB Database
  2. Database encryption and search in encryption
  3. Full text Search
  4. Possible updating of database through Online [This is only additional benifit]
  5. Must have C DLL

There are many options available like MySQL, Oracle, MSSQL. An opensource database would be great.

Best Answer

Have a look at PostgreSQL, it has unlimited database size, what appears to be many options for encryption, support for full text search and interfaces for several languages (C as well via libpg). It is also open source. See the about-page for PostgreSQL for more info.

Related Question