Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Wanted: fast and free (file) database

 
Peter Reitberger
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I'm looking for a fast & free persistency mechanism for Java on Windows/Unix such as a local (file) database.

There should be:
- no license for development / usage
- no process communication overhead involved, i.e. the sw should run in the same JVM
- caching

The database is for storage and retrieval of small entries (~100 bytes). The maximum number of entries is ~ 50.000.
Retrieval of entries is done by a unique key. The database will be used only locally.


Can anyone recommend something?

PS: the API does not have to be necessarily JDBC as long as it is fast...


Thanks,
Peter
 
steve souza
Ranch Hand
Posts: 862
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've used hsqldb and like it. I have a live demo that allows you to enter queries available at http://www.fdsapi.com. The same demo is available as a war if you download the FDS (FormattedDataSet) software available from the same site. The version of hsqldb that I use is somewhat old though.

Here is the link for hsqldb:
http://hsqldb.sourceforge.net/
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic