Re: Devx Database Comparison [Updated]

Hello,

This matrix should be more accurate. Let me know if there are any
problems you see.

http://www.devx.com/dbzone/Article/29480

Sincerely,

Joshua D. Drake

Shouldn't RI be listed as external for MySQL?

On Tue, Nov 15, 2005 at 12:03:15PM -0800, Joshua D. Drake wrote:
> Hello,
>
> This matrix should be more accurate. Let me know if there are any
> problems you see.
>
> http://www.devx.com/dbzone/Article/29480
>
> Sincerely,
>
> Joshua D. Drake
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

MVCC in mysql 5.0???
MVCC in One$DB 4.0???

On 11/15/05, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
> Hello,
>
> This matrix should be more accurate. Let me know if there are any
> problems you see.
>
> http://www.devx.com/dbzone/Article/29480
>
> Sincerely,
>
> Joshua D. Drake
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

Pascual De Ruvo wrote:
> MVCC in mysql 5.0???
>
Innodb supports MVCC AFAIC.

> MVCC in One$DB 4.0???
>
Uday is who put forth the One$Db stuff so it is the president of that
company saying they have MVCC.

> On 11/15/05, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
>
>> Hello,
>>
>> This matrix should be more accurate. Let me know if there are any
>> problems you see.
>>
>> http://www.devx.com/dbzone/Article/29480
>>
>> Sincerely,
>>
>> Joshua D. Drake
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 5: don't forget to increase your free space map settings
>>
>>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

Jim C. Nasby wrote:
> Shouldn't RI be listed as external for MySQL?
>

If you mean Referential Integrity, Innodb supports Foreign Keys as far
as I know.

Sincerely,

Joshua D. Drake

> On Tue, Nov 15, 2005 at 12:03:15PM -0800, Joshua D. Drake wrote:
>
>> Hello,
>>
>> This matrix should be more accurate. Let me know if there are any
>> problems you see.
>>
>> http://www.devx.com/dbzone/Article/29480
>>
>> Sincerely,
>>
>> Joshua D. Drake
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 5: don't forget to increase your free space map settings
>>
>>
>
>

jnasby(at)pervasive(dot)com ("Jim C. Nasby") writes:
> Shouldn't RI be listed as external for MySQL?

If "replication support" is listed as included, that may be a
reasonable tradeoff ;-).
--
select 'cbbrowne' || '@' || 'acm.org';
http://cbbrowne.com/info/multiplexor.html
"Only witch doctors and quacks use secret techniques validated by how
much people will pay for them." -- <brlewis(at)my-dejanews(dot)com>

Well, I guess the question is: is InnoDB considered external? I would
argue it is, since afaik you have to get it yourself unless you buy the
pro version.

BTW, this also applies to MVCC too. Probably some other stuff.

On Tue, Nov 15, 2005 at 01:11:57PM -0800, Joshua D. Drake wrote:
> Jim C. Nasby wrote:
> >Shouldn't RI be listed as external for MySQL?
> >
>
> If you mean Referential Integrity, Innodb supports Foreign Keys as far
> as I know.
>
> Sincerely,
>
> Joshua D. Drake
>
> >On Tue, Nov 15, 2005 at 12:03:15PM -0800, Joshua D. Drake wrote:
> >
> >>Hello,
> >>
> >>This matrix should be more accurate. Let me know if there are any
> >>problems you see.
> >>
> >>http://www.devx.com/dbzone/Article/29480
> >>
> >>Sincerely,
> >>
> >>Joshua D. Drake
> >>
> >>
> >>---------------------------(end of broadcast)---------------------------
> >>TIP 5: don't forget to increase your free space map settings
> >>
> >>
> >
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>

--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

On Tuesday 15 November 2005 16:11, Joshua D. Drake wrote:
> Pascual De Ruvo wrote:
> > MVCC in mysql 5.0???
>
> Innodb supports MVCC AFAIC.
>

I think what people are chaffing at is the whole "it works in innodb but not
in myisam" that seems to apply to so many of my$ql's features. Of course
given their design, there are so many if's and but's (and candies and nuts)
that putting all of that into a comparison chart is going to be painful.

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Jim C. Nasby wrote:
> Well, I guess the question is: is InnoDB considered external? I would
> argue it is, since afaik you have to get it yourself unless you buy the
> pro version.

No, InnoDB is included in all default (Open Source) downloads since
version 4.0, I believe.
You don't have to pay for GPL InnoDB.

AFAIK, only the hot backup tool from InnoDB is not available with GPL.
Hot backup should have an * in the comparision.

Best Regards,
Michael Paesold

Jim C. Nasby wrote:
> Well, I guess the question is: is InnoDB considered external? I would
> argue it is, since afaik you have to get it yourself unless you buy the
> pro version.
>
As far as I know, Innodb ships with MySQL. Recall that Innodb is GPL.

> BTW, this also applies to MVCC too. Probably some other stuff.
>
> On Tue, Nov 15, 2005 at 01:11:57PM -0800, Joshua D. Drake wrote:
>
>> Jim C. Nasby wrote:
>>
>>> Shouldn't RI be listed as external for MySQL?
>>>
>>>
>> If you mean Referential Integrity, Innodb supports Foreign Keys as far
>> as I know.
>>
>> Sincerely,
>>
>> Joshua D. Drake
>>
>>
>>> On Tue, Nov 15, 2005 at 12:03:15PM -0800, Joshua D. Drake wrote:
>>>
>>>
>>>> Hello,
>>>>
>>>> This matrix should be more accurate. Let me know if there are any
>>>> problems you see.
>>>>
>>>> http://www.devx.com/dbzone/Article/29480
>>>>
>>>> Sincerely,
>>>>
>>>> Joshua D. Drake
>>>>
>>>>
>>>> ---------------------------(end of broadcast)---------------------------
>>>> TIP 5: don't forget to increase your free space map settings
>>>>
>>>>
>>>>
>>>
>>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 9: In versions below 8.0, the planner will ignore your desire to
>> choose an index scan if your joining column's datatypes do not
>> match
>>
>>
>
>

Michael Paesold wrote:
> Jim C. Nasby wrote:
>> Well, I guess the question is: is InnoDB considered external? I would
>> argue it is, since afaik you have to get it yourself unless you buy the
>> pro version.
>
> No, InnoDB is included in all default (Open Source) downloads since
> version 4.0, I believe.
> You don't have to pay for GPL InnoDB.
>
> AFAIK, only the hot backup tool from InnoDB is not available with GPL.
> Hot backup should have an * in the comparision.
I did not include the * for hot backup because it is commercial.

>
> Best Regards,
> Michael Paesold
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match

Joshua D. Drake wrote:
> Michael Paesold wrote:
>> AFAIK, only the hot backup tool from InnoDB is not available with GPL.
>> Hot backup should have an * in the comparision.
>
> I did not include the * for hot backup because it is commercial.

Ah, ok. I forgot this was all about non-commercial DBMS software.
Thanks for for the reminder.

Best Regards,
Michael Paesold

MySQL's had MVCC since 4.0.

Pascual De Ruvo wrote:
> MVCC in mysql 5.0???
> MVCC in One$DB 4.0???
>
> On 11/15/05, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
>
>>Hello,
>>
>>This matrix should be more accurate. Let me know if there are any
>>problems you see.
>>
>>http://www.devx.com/dbzone/Article/29480
>>
>>Sincerely,
>>
>>Joshua D. Drake
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 5: don't forget to increase your free space map settings
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Not sure exactly what the "Triggers: statement / row level" item means,
but mysql's trigger are definitely row only. Some funny stuff I found
while seeing if I had remembered that correctly below. From the official
mysql dev docs on triggers:

http://dev.mysql.com/tech-resources/articles/mysql-triggers.html

===

But remember that functions are subject to severe limitations: you cannot access tables
from within a function. So these statements are illegal inside a function:

ALTER 'CACHE INDEX' CALL COMMIT CREATE DELETE
DROP 'FLUSH PRIVILEGES' GRANT INSERT KILL
LOCK OPTIMIZE REPAIR REPLACE REVOKE
ROLLBACK SAVEPOINT 'SELECT FROM table'
'SET system variable' 'SET TRANSACTION'
SHOW 'START TRANSACTION' TRUNCATE UPDATE

Precisely the same limitation applies for triggers.

Triggers are very new. There are bugs. Therefore I give the same warning that I gave for
stored procedures. Do not try triggers with a database that has important data in it.
Instead, create a new database for testing purposes, and make sure this test database is
the default, whenever you are creating or using tables with triggers.

...

Lastly, the [older mysql] manual used to say that if you have triggers, then queries
will be slower. Forget that too, triggers have no effect on queries.

===

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200511152239
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iD8DBQFDeqqGvJuQZxSWSsgRAikHAJ9KMrKxFd65nUCAZUTkZsVuHF+iawCgr3uv
eYhHO5qnt7K5W89SB/a6+SY=
=vTrk
-----END PGP SIGNATURE-----

On 11/15/2005 5:13 PM, Joshua D. Drake wrote:

> Jim C. Nasby wrote:
>> Well, I guess the question is: is InnoDB considered external? I would
>> argue it is, since afaik you have to get it yourself unless you buy the
>> pro version.
>>
> As far as I know, Innodb ships with MySQL. Recall that Innodb is GPL.

It ships with it, but it is still an add-on, implementation wise. And
AFAIK this is the reason why they don't have deferrable foreign keys.

Jan

>
>
>> BTW, this also applies to MVCC too. Probably some other stuff.
>>
>> On Tue, Nov 15, 2005 at 01:11:57PM -0800, Joshua D. Drake wrote:
>>
>>> Jim C. Nasby wrote:
>>>
>>>> Shouldn't RI be listed as external for MySQL?
>>>>
>>>>
>>> If you mean Referential Integrity, Innodb supports Foreign Keys as far
>>> as I know.
>>>
>>> Sincerely,
>>>
>>> Joshua D. Drake
>>>
>>>
>>>> On Tue, Nov 15, 2005 at 12:03:15PM -0800, Joshua D. Drake wrote:
>>>>
>>>>
>>>>> Hello,
>>>>>
>>>>> This matrix should be more accurate. Let me know if there are any
>>>>> problems you see.
>>>>>
>>>>> http://www.devx.com/dbzone/Article/29480
>>>>>
>>>>> Sincerely,
>>>>>
>>>>> Joshua D. Drake
>>>>>
>>>>>
>>>>> ---------------------------(end of broadcast)---------------------------
>>>>> TIP 5: don't forget to increase your free space map settings
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>> ---------------------------(end of broadcast)---------------------------
>>> TIP 9: In versions below 8.0, the planner will ignore your desire to
>>> choose an index scan if your joining column's datatypes do not
>>> match
>>>
>>>
>>
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

>>
>> As far as I know, Innodb ships with MySQL. Recall that Innodb is GPL.
>
>
> It ships with it, but it is still an add-on, implementation wise.

I think that is getting a little long in the tooth in terms of the
general public. To the general public and to MySQL people, InnoDb is a
part of their database and it is Open Source.

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/