This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC 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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "What is the best database software for developing with?" Watch "What is the best database software for developing with?" New topic
Author

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
Dave
[ January 18, 2002: Message edited by: Dave Turner ]
Eddie
Greenhorn

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

Joined: Jan 10, 2002
Posts: 61066
    
  66

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).
hth,
bear
[ January 18, 2002: Message edited by: Bear Bibeault ]

[Asking smart questions] [Bear's FrontMan] [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
thanks,
Dave
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: 15299
    
    6

Dave,
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
Greenhorn

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?
Thanks,
Dave
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: What is the best database software for developing with?