Which database is best for deeply embedded database or through C DLL? 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:


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


There are many options available like MySQL, Oracle, MSSQL. An opensource database would be great.
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.