File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes What is the best database software for developing with? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "What is the best database software for developing with?" Watch "What is the best database software for developing with?" New topic

What is the best database software for developing with?

Dave Turner
Ranch Hand

Joined: Mar 13, 2001
Posts: 60
I am developing an application in java and currently using MS Access 2000 for the database portion, however i would like to find a better platform for the database. I am running Windows 98 and jdk1.3.
Can anyone suggest a database system i could use ? (preferably free!)
Thanks in advance
[ January 18, 2002: Message edited by: Dave Turner ]

Joined: Jan 18, 2002
Posts: 1
mySql is favoured by many, is apparently faster than some commercial options, & is free!
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63873

If you want to run the DB on the Windows box, your options are going to be limited. Last I checked, MySQL can be compiled for Windows but must be licensed in that case (their valid argument is that they can get UNIX development tools for free, but have to pay for the Windows tools, so they have to charge a license for Windows).
There's a minimal-capability DB called InstantDB that I tried a few years back. Seemed ok for the little time that I used it.
If you have a Linux box -- or even a Mac OS X box, that you can use as a DB server -- your options are going to be much wider (e.g. PostgreSQL and so on).
[ January 18, 2002: Message edited by: Bear Bibeault ]

[Asking smart questions] [About Bear] [Books by Bear]
Dave Turner
Ranch Hand

Joined: Mar 13, 2001
Posts: 60
hey guys,
thanks for your suggestions,
i dont have access to any linux or mac computers, so im stuck with windows ,
I'll try searching for InstantDB, but if anyone knows of a good (also free ) windows based DB server then please post it below
Jim Baiter
Ranch Hand

Joined: Jan 05, 2001
Posts: 532
Has anyone tried Postgres?
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15302

MySQL is still free for windows as long as you aren't using it commercially. If this is something that you are using for yourself, then MySQL is the way to go.

GenRocket - Experts at Building Test Data
Stanley Tan
Ranch Hand

Joined: May 17, 2001
Posts: 243
I don't think there's a Postgre for Windows, is there?
Dave Appleton

Joined: Jan 20, 2002
Posts: 2
mySQL is absolutely the way to go if you can get around the few (less at each release) limitations.
mySQL only becomes chargeable when it becomes part of a coommercial application - as in bundling with it. Putting it on the web server is still not chargeable.
mySQL is probably the most deployed database in the world by now judging by the number of web sites that it is on.
Roy Ben Ami
Ranch Hand

Joined: Jan 13, 2002
Posts: 732
whats wrong with access??
it is much superior than Mysql!
why would u want to change from that?
Dave Turner
Ranch Hand

Joined: Mar 13, 2001
Posts: 60
Hi guys,
thanks for the suggetions, after searching for a good access alternative on sourceforge, i have struggled to find any that i could actually figure out how to install on windows , however i have downloaded and installed mySQL and myODBC, so far i changed the root password and i think i have disabled anonymous access, but i havent managed to connect to mySQL using JDBC .
I could really use some help with configuring mySQL:
1. how do i set up a user account that can SELECT,INSERT,UPATE,DELETE,AND,CREATE into a secified database?
2. How can i be sure that my server is secure?
3 How do i create a distributable version to accompany a piece of software that uses it as a backend? is this even possible?
I agree. Here's the link:
subject: What is the best database software for developing with?
It's not a secret anymore!