CODEWITHSUNDEEP
javadatabasecomparisonfirebirdhsqldb
İbrahim Akgün
İbrahim Akgün

Reputation: 1567

Choosing between Firebird and HSQLDB in Java

I want to write a small (5-6 table) desktop app in Java. I want to use Firebird 2.1. database. But I googled and see HSQLDB. I want to make a decision between Firebird and hsqldb.

So which database I have to use?

Upvotes: 3

Views: 5666

Answers (5)

Senad Uka
Senad Uka

Reputation: 1131

I recomend HSQLDB because it's implemented in Java (so you have the same platform as the application) and I guess that you don't need any of the feature for the project of that size that could FireBird provide.

Upvotes: 2

Hugues Van Landeghem
Hugues Van Landeghem

Reputation: 6808

Firebird is very good embedded database and just win an award at SouceForge this year

SQLite have good press for embedded Database too.

Upvotes: 2

David Rabinowitz
David Rabinowitz

Reputation: 30448

Firebird runs in a process of its own and your java app needs to communicate with it. The advantage HSQLDB has that it is written in java, and can run in the same process, which simplifies your installation and runtime check ups (Is the db running, connection errors, etc.). It can persist the data to the disk as well. AN additional option is the H2 database db, which also can run in process.

I'd go with the HSQLDB or H2.

Upvotes: 6

lutz
lutz

Reputation:

For a desktop application an embedded database should be enough. hsqldb or h2 are very well suited for this. You just have to add the JAR file to you applications classpath. Firebird looks more complex.

Actually, H2 is more advanced than hsqldb.

Upvotes: 3

Brian Agnew
Brian Agnew

Reputation: 272307

Don't forget that Java 6 comes with JavaDB, and that may be a useful implementation for a first solution. It's a repackaged Apache Derby, and consequently quite powerful.

Upvotes: 1

Related Questions