Looking for some advice on which DB to use. I'm used to writing J2EE apps with MySQL using sqlyog as my sql gui but i want to embark on developing a desktop app which will need to have its own 'local' database.
I havent really a clue on how to use this, one of my aims is to make this project an easily installable application as, 'fingers crossed' it will be sold as an off the shelf product, therefor will also be installed using either WISE or Installshield.
Its a shame MySQL dont do a free, Oh yeah thats the other requirement, I'm hoping to find an opensource DB, well something that I wont have to fork out for licenses anyway. its a shame Mysql dont offer a standalone db format with a set of classes to access it as i like using MySQL products so far.
Well if anyone has any suggestions or recommendations, advice is greatly appreciated.
Regards, Dave Brown
SCJP 6 - [url]http://www.dbws.net/[/url] - Check out Grails Forum
Joined: Dec 29, 2004
It sounds like hsqldb would be a good fit for you, although I've never really used it myself.
Hi I did not exactly get what you need. If you are looking for A pure Java DB server in OSS then check out for Derby http://incubator.apache.org/derby/index.html it is Apache licensed and very capable . It has an embeded version which make it possible to use the db features with out any pain of installation.