From: Tom Anderson on
On Sun, 22 Nov 2009, Qu0ll wrote:

> "Arved Sandstrom" <dcest61(a)hotmail.com> wrote in message
> news:9CXNm.54457$PH1.35011(a)edtnps82...
>> Lew wrote:
>>> Roedy Green wrote:
>>>>> Even if they are swallowed in the blender, I would like to publicly
>>>>> thank them their part in providing me Java, MySQL and Open Office.
>>>
>>> Arne Vajh?j wrote:
>>>> SUN did not provide you MySQL. SUN just acquired the company
>>>> not long ago. And have lost most of the original people since then.
>>>
>>> Small loss.
>>>
>>> I rate MySQL far, far below Postgres, Derby and the free versions of
>>> Oracle DB and IBM DB2.
>>>
>> That's roughly my take on it as well. Choosing from PostgreSQL, SQL Server
>> or Oracle XE for my local work on Windows/Linux/Mac OS X lets me do
>> everything I need to do to support my company's clients. In fact I use SQL
>> Server on the odd .NET project only to keep acquainted; otherwise I'd pare
>> my choices down to Postgres and Oracle XE. Nothing against Derby - I just
>> haven't had occasion to use it now for some years.
>
> The beauty of using Derby of course is that it just installs as part of your
> application. No separate or specialised installers required.

This is also true of H2 and HSQL, no? You just add their JARs to your
application, and it gains the ability to make and use their databases
wherever it goes. Of course, with Derby you don't even need to add a JAR,
but that's such a trivial thing to do that it hardly seems like a
significant advantage.

tom

--
The revolving disc of plagues is particularly fun. -- greengolux
From: Qu0ll on
"Tom Anderson" <twic(a)urchin.earth.li> wrote in message
news:alpine.DEB.1.10.0911221253400.7260(a)urchin.earth.li...
> On Sun, 22 Nov 2009, Qu0ll wrote:
>
>> "Arved Sandstrom" <dcest61(a)hotmail.com> wrote in message
>> news:9CXNm.54457$PH1.35011(a)edtnps82...
>>> Lew wrote:
>>>> Roedy Green wrote:
>>>>>> Even if they are swallowed in the blender, I would like to publicly
>>>>>> thank them their part in providing me Java, MySQL and Open Office.
>>>>
>>>> Arne Vajh?j wrote:
>>>>> SUN did not provide you MySQL. SUN just acquired the company
>>>>> not long ago. And have lost most of the original people since then.
>>>>
>>>> Small loss.
>>>>
>>>> I rate MySQL far, far below Postgres, Derby and the free versions of
>>>> Oracle DB and IBM DB2.
>>>>
>>> That's roughly my take on it as well. Choosing from PostgreSQL, SQL
>>> Server or Oracle XE for my local work on Windows/Linux/Mac OS X lets me
>>> do everything I need to do to support my company's clients. In fact I
>>> use SQL Server on the odd .NET project only to keep acquainted;
>>> otherwise I'd pare my choices down to Postgres and Oracle XE. Nothing
>>> against Derby - I just haven't had occasion to use it now for some
>>> years.
>>
>> The beauty of using Derby of course is that it just installs as part of
>> your application. No separate or specialised installers required.
>
> This is also true of H2 and HSQL, no? You just add their JARs to your
> application, and it gains the ability to make and use their databases
> wherever it goes. Of course, with Derby you don't even need to add a JAR,
> but that's such a trivial thing to do that it hardly seems like a
> significant advantage.

True, but I was comparing Derby to Postgres and Oracle XE as Arved had
indicated his choice was narrowed down to those two.

--
And loving it,

-Qu0ll (Rare, not extinct)
_________________________________________________
Qu0llSixFour(a)gmail.com
[Replace the "SixFour" with numbers to email me]

From: Arved Sandstrom on
Qu0ll wrote:
> "Tom Anderson" <twic(a)urchin.earth.li> wrote in message
> news:alpine.DEB.1.10.0911221253400.7260(a)urchin.earth.li...
>> On Sun, 22 Nov 2009, Qu0ll wrote:
>>
>>> "Arved Sandstrom" <dcest61(a)hotmail.com> wrote in message
>>> news:9CXNm.54457$PH1.35011(a)edtnps82...
>>>> Lew wrote:
>>>>> Roedy Green wrote:
>>>>>>> Even if they are swallowed in the blender, I would like to publicly
>>>>>>> thank them their part in providing me Java, MySQL and Open Office.
>>>>>
>>>>> Arne Vajh?j wrote:
>>>>>> SUN did not provide you MySQL. SUN just acquired the company
>>>>>> not long ago. And have lost most of the original people since then.
>>>>>
>>>>> Small loss.
>>>>>
>>>>> I rate MySQL far, far below Postgres, Derby and the free versions
>>>>> of Oracle DB and IBM DB2.
>>>>>
>>>> That's roughly my take on it as well. Choosing from PostgreSQL, SQL
>>>> Server or Oracle XE for my local work on Windows/Linux/Mac OS X lets
>>>> me do everything I need to do to support my company's clients. In
>>>> fact I use SQL Server on the odd .NET project only to keep
>>>> acquainted; otherwise I'd pare my choices down to Postgres and
>>>> Oracle XE. Nothing against Derby - I just haven't had occasion to
>>>> use it now for some years.
>>>
>>> The beauty of using Derby of course is that it just installs as part
>>> of your application. No separate or specialised installers required.
>>
>> This is also true of H2 and HSQL, no? You just add their JARs to your
>> application, and it gains the ability to make and use their databases
>> wherever it goes. Of course, with Derby you don't even need to add a
>> JAR, but that's such a trivial thing to do that it hardly seems like a
>> significant advantage.
>
> True, but I was comparing Derby to Postgres and Oracle XE as Arved had
> indicated his choice was narrowed down to those two.
>
And truth be told, now that I think about it, we do use HSQL during testing.

AHS
From: Roedy Green on
On Sat, 21 Nov 2009 12:10:06 -0500, Arne Vajh�j <arne(a)vajhoej.dk>
wrote, quoted or indirectly quoted someone who said :

>
>SUN did not provide you MySQL. SUN just acquired the company
>not long ago. And have lost most of the original people since then.

You can thank Oracle for continuing to provide Java free in the same
sense you can thank Sun for continuing to provide MySQL free.
--
Roedy Green Canadian Mind Products
http://mindprod.com
Finding a bug is a sign you were asleep a the switch when coding. Stop debugging, and go back over your code line by line.
From: Roedy Green on
On Sat, 21 Nov 2009 18:59:04 +0000 (UTC), Martin Gregorie
<martin(a)address-in-sig.invalid> wrote, quoted or indirectly quoted
someone who said :

>How do you rate H2 against Derby and HSQL?

For a comparison of PosGreSQL and MySQL see
http://mindprod.com/jgloss/postgresql.html

The information is a few years old.

I understand that Derby is fast, but ram resident only. It is for
small databases only.
--
Roedy Green Canadian Mind Products
http://mindprod.com
Finding a bug is a sign you were asleep a the switch when coding. Stop debugging, and go back over your code line by line.