Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

What is the best database software for developing with?

 
Dave Turner
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
mySql is favoured by many, is apparently faster than some commercial options, & is free!
Cheers,
Eddie
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64631
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Dave Turner
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 532
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Has anyone tried Postgres?
 
Gregg Bolinger
GenRocket Founder
Ranch Hand
Posts: 15302
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Stanley Tan
Ranch Hand
Posts: 243
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't think there's a Postgre for Windows, is there?
 
Dave Appleton
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 732
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
whats wrong with access??
it is much superior than Mysql!
why would u want to change from that?
 
Dave Turner
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic