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 ]
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 ]
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
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.
whats wrong with access?? it is much superior than Mysql! why would u want to change from that?
Joined: Mar 13, 2001
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