Skip to main content

SQLAlchemy-Paradox

A SQLAlchemy dialect for the Microsoft Paradox DB ODBC Driver

Objectives

This dialect is mainly intended to offer an easy way to access the Paradox DB flat-file databases of older or EOL'd application-specific softwares. It is designed for use with the ODBC driver included with most versions of Microsoft Windows, Microsoft Paradox Driver (*.db) ODBCJT32.DLL.

Pre-requisites

  • A System or User DSN configured to use the Microsoft Paradox driver

  • 32-bit Python. The Microsoft Paradox driver may come in a 64-bit version, but using it might run into the same "bittedness" issue experienced with other JET-based ODBC drivers.

Co-requisites

This dialect requires SQLAlchemy and pyodbc. They are both specified as requirements so pip will install them if they are not already in place. To install separately, just:

pip install -U SQLAlchemy pyodbc

Installation

PyPI-published version:

pip install -U sqlalchemy-paradox

Absolute bleeding-edge (probably buggy):

pip install -U git+https://github.com/the-wondersmith/sqlalchemy-paradox

Getting Started

Create an ODBC DSN (Data Source Name) that points to the directory containing your Paradox table files.

Then, in your Python app, you can connect to the database via:

import sqlalchemy_paradox
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker


db = create_engine("paradox+pyodbc://@your_dsn", echo=False)
super_session = sessionmaker(bind=db)
super_session.configure(autoflush=True, autocommit=True, expire_on_commit=True)
session = super_session()

The SQLAlchemy Project

SQLAlchemy-Paradox is based on SQLAlchemy-access, which is part of the SQLAlchemy Project and tries to adhere to the same standards and conventions as the core project.

At the time of this writing, it's unlikely that SQLAlchemy-Paradox actually does comply with the aforementioned standards and conventions. That will be rectified (if and when) in a future release.

Development / Bug reporting / Pull requests

SQLAlchemy maintains a Community Guide detailing guidelines on coding and participating in that project.

While I'm aware that this project could desperately use the participation of anyone else who actually knows what they're doing, Paradox DB may be so esoteric and obscure (at the time of this writing) that I wouldn't reasonably expect anyone to actually want to. If I am mistaken in that belief, please God submit a pull request.

This library technically works, but it's far from feature-complete.

License

This library is derived almost in its entirety from the SQLAlchemy-Access library written by Gord Thompson. As such, and given that SQLAlchemy-access is distributed under the MIT license, this library is subject to the same licensure and grant of rights as its parent works SQLALchemy and SQLAlchemy-Access.

Metadata

Release files for sqlalchemy-paradox 0.2.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for sqlalchemy-paradox 0.2.0
File Size Uploaded Provenance Actions
sqlalchemy-paradox-0.2.0.tar.gz 35.5 kB Without provenance Details for sqlalchemy-paradox-0.2.0.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for sqlalchemy-paradox 0.2.0
File Interpreter ABI Platform Actions
sqlalchemy_paradox-0.2.0-py3-none-any.whl Python 3 none any Details for sqlalchemy_paradox-0.2.0-py3-none-any.whl

Total release size: 70.9 kB

Release files / sqlalchemy-paradox-0.2.0.tar.gz

Download URL sqlalchemy-paradox-0.2.0.tar.gz
Size 35.5 kB
Tags Source
SHA-256 checksum
How to use checksums
4839e93dd451bc1a86adf0ca2a1cf4b8ecaefc026aeb35d7478c7de69c962e05
BLAKE2b-256 checksum
How to use checksums
d26fb9af14f2dc2a12c44c4a2906f0e684785d0764e9984c5d1c20ea5b312762
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via poetry/1.1.4 CPython/3.9.1 Darwin/18.7.0

Release files / sqlalchemy_paradox-0.2.0-py3-none-any.whl

Download URL sqlalchemy_paradox-0.2.0-py3-none-any.whl
Size 35.4 kB
Tags Python 3
SHA-256 checksum
How to use checksums
d95ef91fc95abb5bc55afba8b4f8c16b1418eb5538339e3593b741250925a466
BLAKE2b-256 checksum
How to use checksums
f23516f14cee1c47e646c63b27781dcb77290e07512a615522d675c881ff12c6
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via poetry/1.1.4 CPython/3.9.1 Darwin/18.7.0

Security for sqlalchemy-paradox 0.2.0

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page