[DB-SIG] Creating portable Python database code

[Hrvoje Niksic]

Cary Collett <cary@ratatosk.org> writes:

> I'll second Christopher's post. The DBI-API interfaces are nice and
> consistent. The differences in Oracle's and MySQL's SQL dialects are
> much more significant and will be your sticking point in any
> migration between the two. Personally, I like MySQL's SQL
> better. There are some very handy features that Oracle just doesn't
> have. (This is all as of Oracle 7, I haven't used 8.)

Out of curiosity, can you name some?

I've mostly heard about the features MySQL does *not* have, like
transactions, subselects, foreign keys, triggers, stored procedures,
etc.