On Sun, 20 Jun 2010 12:52:22 +0200 Thomas Kellerer <spam_eater@xxxxxxx> wrote: > David Goodenough wrote on 20.06.2010 11:08: > > I don't support anyone has written a "how to write database > > agnostic code" guide? That way its not a matter of porting, > > more a matter of starting off right. > > I don't believe in "database agnostic code". It depends on what you're after. There are applications that really use a DB as a SQL interface to the file system (sort of). Coding non standard SQL for such kind of application (and there are many out there) is just a different practice of BDSM. Still even when you deal with application that can really take advantage of the various special feature of some DB and their SQL dialect... 80% of the written SQL could be standard. Sometimes people write abstraction code to make it easier to write in the only SQL dialect they know for a very small coding advantage while they could write a better one that at least wouldn't make a pain to post the application. When thinking about portable code I generally find this documents useful: http://sql-info.de/postgresql/postgres-gotchas.html -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
