• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

light weight in memory database with the option of saving to csv/xml files

 
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi

I am looking for a light weight in memory Java database that will have the option of saving tables and loading it from disc too.

I am looking for a database that can run as a part of my application and not as a separate process. It should be able to compute selection, projection and joins efficiently.

Please advice me about this. The database will be used as a part of my java application.

Regards
Swaroop
 
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Have you looked at HSQLDB?
 
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
that's what I was going to say.
 
swaroop rath
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks a lot. I saw it and a few others on the web but needed some advice to trust this. I see that its good and supports both in memory tables and tables in simple csv files.

How about SQLite. I read about this and see that this is also widely used for the same purpose. Its used by a lot of Google products too like Google gears.

Regards
Swaroop
 
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hypersonic (as mentioned above)

H2 - http://www.h2database.com/html/main.html

Derby - http://db.apache.org/derby/

If you are likely to have concurrent requests, or often re-sorting fields, use Derby: http://dhartford.blogspot.com/2010/01/embedded-db-sort-stability-pagination.html

 
swaroop rath
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks a lot Darren. I think Derby will suit me best.
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
SQLite has a JDBC driver, but is written in C, not Java.
 
swaroop rath
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yeah I saw that. Thanks Ulf.

Swaroop
reply
    Bookmark Topic Watch Topic
  • New Topic