Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to store data in an application which will be distributed

 
Shashank Agarwal
Ranch Hand
Posts: 105
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm building a small lab-notebook desktop application in Java, which will be distributed to some of my friends. I was wondering how the data should be stored. The data is basically a table with multiple columns and rows, which could be sorted by different columns, searched over, edited, deleted etc. SQL would be awesome here, so I thought of using MySQL, but then that would require all users to have MySQL installed on their computers, but I'm trying to avoid asking them to install anything extra. I was looking at Java DB, but didn't know if that would also have to be installed on user computers or not.

I even considered using csv or xml to store the data, but that would just be a pain to use because of all the editing, deleting, searching involved. Would appreciate any help.
 
Jelle Klap
Bartender
Posts: 1952
7
Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You could use a lightweight in-memory database that supports SQL like Java DB / Apache Derby or HSQLDB.
 
Campbell Ritchie
Sheriff
Pie
Posts: 50258
79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That sounds a good idea, Jelle Klap, but this looks like a thread which would sit better on our JDBC forum. Moving.
 
Shashank Agarwal
Ranch Hand
Posts: 105
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the replies. Java DB sounds good. Would it have to be installed on user computer?
 
Bauke Scholtz
Ranch Hand
Posts: 2458
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No, you can just package it in your JAR. The client just need a JVM as usual.
 
Shashank Agarwal
Ranch Hand
Posts: 105
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Great. That's what I wanted. Using Apache Derby.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic