• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Data store Options in Java for Desktop Applications

 
Malatesh Karabisti
Ranch Hand
Posts: 153
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 68
IntelliJ IDE Java Mac
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You could use Apache Derby.

Derby webpage
 
Pranav Raulkar
Ranch Hand
Posts: 73
Android Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 153
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic