[DB-SIG] Creating portable Python database code
Hrvoje Niksic
hniksic@iskon.hr
22 Feb 2000 16:49:31 +0100
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.