Yes, you're right but I figure if I get one that's compliant - or as much as possible the pain won't be so bad <G>. I'd probably switch before I got in too deep anyway.
> You may find that switching from one database to another (any database) > isn't that easy if you utilize the more 'advanced' features such as > triggers, stored procedures, etc.. Even complicated sub-select queries may > work on one database engine and not another. > > You can minimize the pain by choosing a compliant engine, but you still end > up having to rewrite a bit... > > > -----Original Message----- > > From: brett holcomb [mailto:[EMAIL PROTECTED] > > Sent: Thursday, July 03, 2003 4:52 PM > > To: [EMAIL PROTECTED] > > Subject: Re: [gentoo-user] Databases - which one > > > > > > Thank you and all the others. I didn't want to get locked > > into MySQL pecularities and then if I switch be stuck with > > a rewrite. It also doesn't support things like views, > > etc. I didn't check the license though. > > > > On 03 Jul 2003 22:41:21 +0200 > > > > Mario Udina <[EMAIL PROTECTED]> wrote: > > >On Thu, 2003-07-03 at 16:33, brett holcomb wrote: > > >> From research I've done it appears MySQL does things > > >>that > > >> are non-standard for SQL or the ANSI specs. > > > > > >Yes it does, in fact it si the least SQL standard > > >database I have > > >seen. I prefer postgresql (linux) sapDB (windows) because > > >of the > > >features and because of the licence which in my opinion > > >is better > > >than mysql. > > > > > >ciao > > >-- > > >Mario Udina <[EMAIL PROTECTED]> > > > > > >-- > > >[EMAIL PROTECTED] mailing list > > > > -- > > [EMAIL PROTECTED] mailing list -- Brett I. Holcomb AKA Grunt <>< -- [EMAIL PROTECTED] mailing list
