What to use - ODBC vs OLEDB in python?

L

lPolar2014-11-28 08:59:34

Python

lPolar, 2014-11-28 08:59:34

Hello!
The situation is as follows - you have to work quite often with different databases (SAS/Oracle/Sqlite).
Through which interface is it better to establish interaction between databases - through OLEDB or through ODBC? Which of these technologies is newer/faster/more documented? Where can I read the documentation for both one and the other technology (preferably in Russian)?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Anatoly Scherbakov, 2014-11-28
@Altaisoft

Didn't work with either OLEDB or ODBC, but it's not very clear why? Indeed, for Python, there are a number of ORMs that access the DBMS through its own API without an additional layer. SQLAlchemy definitely works with both SQLite and Oracle. You write queries, they are translated into the dialect of a particular DBMS.
Even Django can use SQLite, PostgreSQL, and MySQL together in one project at once, if you really want to.
Regarding SAS - I can not say anything; but I suspect that there are some tools for it.