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 > -- [EMAIL PROTECTED] mailing list
