This project provides a "pure python" ODBC bridge. Or at least as "pure" as it can possibly be.
- Implement the DB API 2.0 specification.
- Become API-equivalent to the well-known pyodbc.
- Act as a drop-in replacement for pyodbc for situations where C++ compilation is undesirable, or where pyodbc is otherwise not available.
- Users should be able to change
import pyodbctoimport purepyodbc as pyodbcand have it Just Work™.
- Performance (at least in the short- to mid-term)
- Features other than those offered by pyodbc
The easy bit is installing this package; You just pip install purepyodbc.
Here is a rough diagram showing how all the pieces hang together.
graph LR;
purepyodbc[Python/purepyodbc]<-->drivermanager[ODBC Driver Manager];
drivermanager-->driver[ODBC Driver];
driver-->database[(Database)];
database-->driver;
driver-->drivermanager;
drivermanager-->purepyodbc
You will need an ODBC driver manager installed on your system. On Windows, you probably don't need to install anything. On Linux (and possibly macOS and other *nix-likes although we don't test it), unixODBC is probably best although others may work.
Once you've got that, you'll need one or more ODBC driver for whichever database(s) you want to talk to. Just as purepyodbc talks to the driver manager, the driver manager talks to the driver(s).
(To be expanded upon in due course)
| Operating System | Driver Manager | Driver | Database Server |
|---|---|---|---|
| Windows | Windows | ODBC Driver 17 for SQL Server | SQL Server |
| Windows | Windows | SQL Server | SQL Server |
| Windows | Windows | PostgreSQL Unicode | PostgreSQL |
| Linux | unixODBC | ODBC Driver 17 for SQL Server | SQL Server |
| Linux | unixODBC | FreeTDS | SQL Server |
| Linux | unixODBC | PostgreSQL Unicode | PostgreSQL |
This section is intentionally brief for now, as the project is very immature.
Anything you would normally do with pyodbc should be possible here.
If it's not, then raise an issue so I can track what people actually want.