CODEWITHSUNDEEP
javasqldatabase
James P.
James P.

Reputation: 19607

Database persistence without an SQL server

I'm seeking a solution that would allow persistence without requiring an SQL server to be installed on the host and could be bundled along with a desktop application. Does such a thing exist?

Upvotes: 4

Views: 2146

Answers (3)

Thomas
Thomas

Reputation: 64635

You might look at SQL Server Compact Edition. It has many of the same features as the full version of SQL Server, is free and does not require a separate installation.

Upvotes: 2

Pascal Thivent
Pascal Thivent

Reputation: 570325

You could use an embeddable database written in Java like Java DB (Sun's supported distribution of Apache Derby), HSQLDB, or H2 (by the creator of HSQLDB). H2 has my preference performance wise and features wise (some comparisons here, here and here) and because of the compatibility mode with other databases (very nice when H2 is not your target database but maybe irrelevant in your context).

Upvotes: 9

ChristopheD
ChristopheD

Reputation: 116137

I think you want something like SQLite (Java bindings) (a fast flat-file general purpose embeddable database).

Upvotes: 5

Related Questions