Re: Devx Database Comparison [Updated]

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@Yahoo.com #