This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 41095
    
  44
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
 
Similar Threads
Developing applications on Windows tablets using Java
caching master tables static data
How to limit the size of a object in terms of MB ?
DST changes 2007
Saving to a text file!