Well is better use Access or MySQL with WIN (JAVA) APPS (desktop),cons and pros ?

**lse123** · 10-29-2009, 01:24 PM

Access is for desktop or web Apps BUT MySQL is ONLY for web Apps ?
May Java desktop Apps use MySQL...If yes, how much space take the database structure in the App, if for example data in database reach 1MB exactly...? I am beginner in binding DATABASES TO WIN (JAVA) APPS but I have practiced in web apps binding JSP/MYSQL....

Well is better use Access or MySQL with WIN (JAVA) APPS (desktop), where find cons and pros ?

**r035198x** · 10-29-2009, 01:33 PM

You can use MySQL in desktop applications as well.
Where did you hear that MySQL is only for web applications?

**lse123** · 10-29-2009, 02:01 PM

since is a server, how can be used, if we do not have internet connection?

**r035198x** · 10-29-2009, 02:03 PM

Where did you hear that servers can only be used with an internet connection?

**lse123** · 10-29-2009, 06:38 PM

each client then must have installed the mysql server? or... how works?

**r035198x** · 10-29-2009, 06:43 PM

You said that you worked with MySQL on web apps. Did each client have MySQL installed on their computers?
Are you trying to write a desktop application that will accessed over an intranet(or the internet)? If that is the case then you would have one MySQL server instance installed on your server computer. Your application would be accessing that database and the application itself could reside on the machine with the database or on a dedicated application server machine. You would then serve via Java Web Start.

**lse123** · 10-29-2009, 07:37 PM

in case of web apps each connected to database server , correct ?
if we have no connection and want to build an app personal for one person , no intranet , lets say a hotel booking system data keep, old fasion well in this case how handle ?

**lse123** · 10-29-2009, 07:47 PM

for standalone apps jdk/mysql need to be installed(no network)? well is any way make an exe file self integrated/standalone without the need either installed ?

**mrmatt1111** · 10-29-2009, 08:01 PM

How about sqlite or lucene or javadb?

**r035198x** · 10-29-2009, 08:02 PM

Yes you can run the stuff on just one machine if you want. That must surely be obvious.
If your application accesses a database then surely you need to install MySQL. If you want to make an installation file then google for such tools that make installers from .jar files.