a desktop application storing data?

Question

Say I have created a desktop application in Java to keep notes. I used MySQL for storage. On my computer it connects to database I have created(using my root username and password). But what if I want to distribute my program? Are the other users should have MySQL installed on their system? If they have to isnt tat a problem that I have my MySQL username and password embedded in code?

In general, I am asking how can I make a desktop program in Java which can store data from its users??

score 4 · Accepted Answer · edited May 23 '17 at 11:52

4

Sounds like you want SQLite, There is another SO question here about it.

edited May 23 '17 at 11:52

Community

1
1

answered May 14 '11 at 10:00

IanNorton

7,145
2
25
28

score 3 · Answer 2 · answered May 14 '11 at 10:06

3

SQLite as IanNorton mentioned is a good alternative. Other good alternatives are Apache Derby or the H2 database, both providing an embedded (install-free) java database.

answered May 14 '11 at 10:06

Johan Sjöberg

47,929
21
130
148

I have made some reserach, and I think databases for this situation are called "embedded databases"? Does MySQL have its own embedded version? I seen mySQL embedded server but could not understand what is it? Is it for my needs?? – obtur May 14 '11 at 10:22
Yes they're called *embedded databases*. MySQL Embedded makes no more sence to me than it did for you. The two mentioned already I've myself tested with good experience, in particular the latter. – Johan Sjöberg May 14 '11 at 10:52

score 2 · Answer 3 · answered May 14 '11 at 11:05

Does MySQL have its own embedded version?

Normal "embedded MySQL" is a native code library (libmysqld) that is not really suitable for use with Java. However, there is something called mysql-je that purports to be a Java compatible wrapper. The problem is that it is based on a rather old version of MySQL, and hasn't been updated since 2006.

There are also postings on the MySQL forums about using embedded MySQL with Java, but there's no sign that it is supported.

So I think you'd be better of going with a one of the alternatives; e.g. SQLite, Derby or H2.

score 1 · Answer 4 · answered May 14 '11 at 10:21

No need of multiple installations of MYSQL database if all the machines where you want to access are in a LAN. In that case you can have single database installation and access it from multiple systems using the IP address of the database machine. We can access a remote database through Internet as well, using the IP Address of the machine in which database exists..

a desktop application storing data?

4 Answers4