[kwlug-disc] Newbie... Playing with Linux etc...
adamglauser at gmail.com
Tue Apr 13 08:27:41 EDT 2010
> I would
> have hoped sql is sql, but obviously I'm not speaking from experience,
> so my opinion is worth zilch.)
Sadly, this is not at all true. It is certainly possible to restrict
oneself to ANSI standard SQL, but it takes some forethought. There are
some really convenient extensions in each DBMS which are non-standard.
There is then the matter of the level of ANSI compliance of the various DBs.
If I were trying to write a DB-agnostic application I would most
certainly use some sort of extraction library rather than trying to keep
a handle on all of the cross-DB issues myself.
More information about the kwlug-disc