[DB-SIG] Database Independent SQL
Sun, 8 Sep 2002 19:38:42 -0700
On Sunday, Sep 8, 2002, at 19:31 US/Pacific, Huy Do wrote:
>> My recommendation: Put as much as possible into stored
>> procedures/functions and views. Then you'll likely be able to use a
>> 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 ?
MySQL, for example, supports neither views nor stored procedures.
While cutting down on the amount of SQL embedded in your code (which
could be a good thing), it's not very conductive for portability.
("`-/")_.-'"``-._ Chris Cogdon <firstname.lastname@example.org>
. . `; -._ )-;-,_`)
(v_,)' _ )`-.\ ``-'
_.- _..-_/ / ((.'
((,.-' ((,/ fL