How to store data in an application which will be distributed
Joined: May 20, 2004
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.