> > BUT... MS-SQL doesn't support triggers as well as Interbase...
>
> You don't think nesting and recursion are good? Or are you just so stuck
on
Nesting is fine. IB does it to. Ditto recursion, AFAIK.
> the before and after
> trigger paradigm that anything else is not as good?
well, can you do "proper" cascade deletes? ie, delete from the master table,
remove the children automatically?
Interbase aint perfect - no one product is - but it is good in the neche
it's designed for (embedded)
> Lets list a few things interbase can't do
>
> 1/ Replication
http://www.synectics.co.za/
3rd party, but it was commissoned by Inprise for IB6, just not released with
the opensource version.
> 2/ CASE, COALESCE and NULLIF (also ansi)
Fair call. Quite sure they are ANSI tho? I dont recall seeing them, but its
been a long time.
> 3/ A decent Script language and function library
Aye? You call TransactSQL a _decent_ scripting language - or have they done
away with it and put VBScript in there in 2000, like they have done with
_everything_ else? TransactSQL is _almost_ identical to Interbase's SP
language (well, it was in 6.5). They both suck.
MSSQL _does_ have a better function library tho - its rather nifty :)
> 4/ Full text indexing
true. there are also 3rd party and OSS stuff to do this on the web, plus
Tamarack's product, but I've heard nothing but "buts" with it (ie, "its OK,
but....")
> 3/ User Defined Functions. (and don't say UDL's)
the difference being? Are you talking about xp's in MSSQL - they are pretty
much the same as UDF's in Interbase.
> One things that makes me smile on this list is the dogmatism exhibited
> toward Borland Product
> is exactly what the same people daily complian about in regard to MS
Product
>
> So
>
> 1/ Interbase is not the worlds best SQL database
Definatly not. MSSQL's isn't. Oracle is closer, but it aint perfect either.
they all have their good and bad points, but I think what most people on
this list need is a light weight, low cost, low maintenance database for
projects which would have otherwise used something like Paradox. IB fits
that _perfectly_.
> 2/ The primary purpose of Kylix will not be to port ISAPI Apps from
Windows
> to Linux/Apache
Nope, and personally, <removes inprise hat, if he can find it> I'm not sure
_what_ the purpose of Kylix is, aside from a really cool project for the R&D
lads and lasses. Hopefully, you will all rush out buy it and we will make
Q2's budget in April :) . Or maybe not. Kinda hope so tho - I'd like to have
May and June off :)
N
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
