Free portable database

Question

Hi I am developing desktop portable free application and I`m looking for portable database:

• free
• without install
• up to 20K records
• standalone application
• supports encryption (optional)
• SQL92 spec

thanks for advice

can you write some advantages and disadvangtages?

Solution 1

SQLite:

self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.

-Adam

Solution 2

Firebird embedded

About:

Firebird is an open source relational database offering many ANSI SQL-99 features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, powerful language support for stored procedures and triggers.

Solution 3

If you're working in Java, HSQLDB might be a good fit. Otherwise, SQLite.

Solution 4

SQL Server Compact

Solution 5

Not sure it meets the no install requirement but if you need more than SQLite check Apache Derby.

View more solutions