faulksp@... wrote:

> This is the reason I don't use Firebird anymore. I keep coming back for another
> look every now and again, but it seems actually being able to use the database
> engine in a meaningful way doesn't seem to have any priority.

Having started using Firebird ( at that time Interbase ) long before MySQL ever
appeared on the scene admittedly using C++ ... There was no alternative to
compare to, but I never found any problems with the API. Firebird just works
reliably day in day out and now I've moved over to PHP for main development
interface I don't have any of the problems that many MySQL powered website
suffer from. The amount of traffic I see with MySQL hack attempts gets
irritating, but now gets a page back recommending they try I database I am using :)

My recollection of the SQL spec is that there are MANY more sections many of
which MySQL does not address or has only recently added but which Firebird has
supported for a long time. These days CTE is essential and not something MySQL
can cope with?

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk