This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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.