• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
swaroop rath
Greenhorn
Posts: 11
  • 0
  • Mark post as helpful
  • send pies
  • 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
 
Mark Williams
Ranch Hand
Posts: 66
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you looked at HSQLDB?
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
that's what I was going to say.
 
swaroop rath
Greenhorn
Posts: 11
  • 0
  • Mark post as helpful
  • send pies
  • 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
 
darren hartford
Greenhorn
Posts: 23
  • 0
  • Mark post as helpful
  • send pies
  • 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: 11
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks a lot Darren. I think Derby will suit me best.
 
Ulf Dittmer
Rancher
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
SQLite has a JDBC driver, but is written in C, not Java.
 
swaroop rath
Greenhorn
Posts: 11
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yeah I saw that. Thanks Ulf.

Swaroop
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic