Does Linux have a unified way of accessing databases? Windows has ADO...

Alex Martelli aleax at aleax.it
Thu Jan 17 17:16:46 CET 2002


"Harry George" <hgg9140 at cola2.ca.boeing.com> wrote in message
news:xqxelkp2dll.fsf at cola2.ca.boeing.com...
    ...
> > ADO (the whole "Unified Database Access" architecture, actually)
supports
> > alternative organizations, such as hierarchical and "cubes" (a la OLAP).
> >
> > Python's DB-API and ODBC don't.  So, the answer remains "no".
>
> Under this interpretation we can safely say that no platform anywhere
> has a fully DBMS-independent access mechanism.  ADO, for instance,
> doesn't support an object database system we use, which started life
> as swizzled C++ structures on SGI's.

The "object database system you use" may of course lack ADO drivers
(so, I believe, does the Watcom SQL my dad runs on his 12-years-old
DOS PC), but nothing in the UDA architecture stops you from writing
such drivers -- present your data as hierarchical or however else it
is best presented.  You can't escape tabular/relational structuring
with ODBC (nor Python's DB-API, nor, I believe, Perl's equivalent).


Alex






More information about the Python-list mailing list