[Mehim]

I would like to create a Java desktop database app. I want it to keep info like name, surname, email etc. of a person. I want to use JTable for viewing/adding/editing the data, but i have no idea how to store the data.. In files? If so will those files be safe? Won't the application lag if i had like 500 people data stored in it? Is this kind of data storage even worth a try? Would it be fast or laggy as hell? Any other solutions? Embedded Database is kinda too difficult for me.. I mean i haven't found a really good tutorial so i could understand how it works (for dummies tutorial needed badly in this case)..

[x68zeppelin80x]

You could start here.

A quick Google search turned up this tutorial on JDBC API.

Here is an overview of the JDBC API.

This post has been edited by x68zeppelin80x: 08 August 2012 - 02:16 PM

[pbl]

If you don't want to learn SQL I wouldn't worry about the performances realted to file holding 500 entries.

You can load them in memory (storing them in an ArrayList). User won't notice any lag time when you will re-write the whole ArrayList to disk when an entry is added/deleted/updated

[g00se]

http://java.sun.com/...Desktop/javadb/

Never a good idea to reinvent a db imo

[Mehim]

pbl, on 08 August 2012 - 02:16 PM, said:

If you don't want to learn SQL I wouldn't worry about the performances realted to file holding 500 entries.

You can load them in memory (storing them in an ArrayList). User won't notice any lag time when you will re-write the whole ArrayList to disk when an entry is added/deleted/updated

Thanks for reply. It's not that i don't want to learn SQL. I don't know where to start? I guess learning SQL from a book would be a good start but will it explain how it co-operates with Java and how to set it all up?

[darek9576]

I found JDBC really nice when working with databases in Java. Hibernate is your other option - i have no experience with that.

[Ghlavac]

He probably should avoid hibernate, it'd be like using a nuke to blow up a house for him.

[g00se]

Yes. Use that for large applications

[pbl]

Actually, I consider, for a newbie, that:
- using an ArrayList<Contact>
- learning how to add/update/delete from/to that ArrayList
- learning how to use writeObject(), readObject() on that ArrayList

is quite a good learning curve. You will have plenty of time later on to learn about SQL and Hibernate.