Trusted and scalable embedded database

Question

I'm looking for a DB embedded solution to deal with a average/medium amount of data (maybe between 100MB to 2GB), and allow concurrent connections, not so much, I believe at least
more than 10 concurrent connections for objects (database, tables) up to fifty or one hundred.

Which options could be achieve these requirements in your opinion and experience?

score 2 · Answer 1 · answered Jan 30 '13 at 18:04

2

Firebird can be used embedded. It meets all your other requirements.

answered Jan 30 '13 at 18:04

Chris Walton

2,513
3
25
39

score 1 · Accepted Answer · answered Jan 31 '13 at 12:34

For Java you have a choice of three different DBMS:

HSQLDB (aka HyperSQL): http://hsqldb.org
H2 Database: http://h2database.com/html/main.html
Apache Derby (aka. "JavaDB"): http://db.apache.org/derby/

My personal preference is HSQLDB, but H2 is just as good. Both meet the requirements you mentioned.

Trusted and scalable embedded database

2 Answers2