aspose file tools*
The moose likes Java in General and the fly likes Data store Options in Java for Desktop Applications Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Data store Options in Java for Desktop Applications" Watch "Data store Options in Java for Desktop Applications" New topic
Author

Data store Options in Java for Desktop Applications

Malatesh Karabisti
Ranch Hand

Joined: Jul 28, 2010
Posts: 153

I am writing some desktop application using Java Swing, I need some advice on storing the data. The data will of the kind same as rows and column.

what are the available options to store the data in Java desktop application ?

Nico Van Brandt
Ranch Hand

Joined: Mar 31, 2011
Posts: 66

You could use Apache Derby.

Derby webpage


Oracle Java SE6 Certified Programmer
Oracle Java EE5 Certified Web Component Developer
Pranav Raulkar
Ranch Hand

Joined: Apr 20, 2011
Posts: 73

Hi Malatesh, good question. Many people tend to take it lightly.
The choice of data store completely depends upon the type of desktop application you are creating.

1. If you want a light weight and portable option, I'll recommend SQLite. For instance browsers like Mozilla Firefox use SQLite to store the bookmarks we create. But it has certain limitations. Visit http://www.sqlite.org/ for more details.

2. Another powerful option, I recently learned about is Cassandra. I believe you must be using Facebook and I hope you agree that it is fairly quick. It uses Cassandra as its backend. I think this is a very good option, since you get to learn something new too. http://cassandra.apache.org/

3. Other options include Oracle, MSSQL, MYSQL and PostgreSQL and are more powerful, conventional databases that allow loads of capabilities.

Here is a good post that will help you to decide. Hope you find it useful. http://www.gplivna.eu/papers/choose_database.htm
Finally it all comes down to your application's needs
Malatesh Karabisti
Ranch Hand

Joined: Jul 28, 2010
Posts: 153

Thank you Pranav Raulkar and Nico Van Belle, that looks like exactly what I was looking for. Let me go through all the hints you have given. By the way I am having the data exactly like bank transaction details.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Data store Options in Java for Desktop Applications
 
Similar Threads
Question about designing a web-service security mechanism used with desktop client
Java Desktop Applications
integration options for desktop applications
Using JAVA with java-script
serializing and deserializing xml/kml