[DB-SIG] Database Independent SQL

Huy Do huy@tramada.com.au
Mon, 9 Sep 2002 12:31:35 +1000


> -----Original Message-----
> From: db-sig-admin@python.org [mailto:db-sig-admin@python.org]On Behalf
> Of Gerhard H=E4ring
> Sent: Monday, 9 September 2002 12:02 PM
> To: Python DB-SIG Mailing List
> Subject: Re: [DB-SIG] Database Independent SQL
>
>
> * Huy Do <huy@tramada.com.au> [2002-09-09 11:44 +1000]:
> > Hi,
> >
> > I'm about to develop a major Python application and was
> wondering what the
> > most database independent way of going about accessing a database in =
my
> > application. i.e so I can switch between databases almost instantly (=
a
> > little bit of work is also okay :-)).
>
> My recommendation: Put as much as possible into stored
> procedures/functions and views. Then you'll likely be able to use a ver=
y
> minimal subset of SQL.
>

Wouldn't I still need to port these stored procedures across databases
anyway or is there a database independent way of writing these things ?

Thanks

Huy