Re: hsqldb vs. derby



Zsolt Koppany wrote:
Hi,

our application runs right now with mysql but we would also like to support a java DB either hsqldb or derby. I have never worked with them but know mysql. We have approx. 100 tables and couple of hundred queries and some of them are pretty complicated.

Which java DB should we take?

Zsolt



You will get votes on both sides of here. I personal like HSQLDB. I dropped MySQL about a year and a half ago to use HSQLDB with no regrets. For either database I would be concerned with the complicated queries. You could download and create a few tables and pound them with these queries. The help Forum for HSQL is very responsive. Fred gets back with in the same day.

Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.awardspace.com
__________________________________________________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)
.



Relevant Pages

  • hsqldb vs. derby
    ... our application runs right now with mysql but we would also like to support ... a java DB either hsqldb or derby. ... Which java DB should we take? ...
    (comp.lang.java.databases)
  • Re: Java and MySql program example ?
    ... > I am trying to learn Java and need an example program with MySql ... > MySql database. ... Database connection established ...
    (comp.lang.java.programmer)
  • Re: mysql vs sqlite vs hsql
    ... My question isabout benchmarks and multiple inserts & ... > I current have a mysql database of approx. ... lemme dispell the very common misconception that java is slow. ...
    (comp.lang.python)
  • Re: [SLE] schemaSpy
    ... >>> java ... >> page and modified it for MySQL and my local setup, ... >> any queries on behalf of schemaSpy (ascertained by logging in to ...
    (SuSE)
  • Good news for Itanium (if not VMS)
    ... Great news on Java and MySQL availability, especially on Itanium! ... Platforms is now available with Java SE 6 for both Windows and Linux ... Run MySQL on HP-UX 11i v3 - MySQL announces availability of its flagship ...
    (comp.os.vms)