aspose file tools*
The moose likes JDBC and the fly likes light weight in memory database with the option of saving to csv/xml files Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "light weight in memory database with the option of saving to csv/xml files" Watch "light weight in memory database with the option of saving to csv/xml files" New topic
Author

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

swaroop rath
Greenhorn

Joined: Jul 24, 2009
Posts: 11
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

Joined: Aug 01, 2008
Posts: 66
Have you looked at HSQLDB?
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

that's what I was going to say.
swaroop rath
Greenhorn

Joined: Jul 24, 2009
Posts: 11
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

Joined: May 17, 2010
Posts: 17
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

Joined: Jul 24, 2009
Posts: 11
Thanks a lot Darren. I think Derby will suit me best.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41885
    
  63
SQLite has a JDBC driver, but is written in C, not Java.


Ping & DNS - my free Android networking tools app
swaroop rath
Greenhorn

Joined: Jul 24, 2009
Posts: 11
Yeah I saw that. Thanks Ulf.

Swaroop
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: light weight in memory database with the option of saving to csv/xml files