sqlalchemy-pgspider

What it is and what it does

sqlalchemy-pgspider is a SQLAlchemy dialect that bridges SQLAlchemy to PGSpider, a distributed PostgreSQL system. It inherits from SQLAlchemy's PostgreSQL dialect and overrides version-checking logic so that SQLAlchemy recognizes and connects to PGSpider instead of rejecting it as an unsupported database. The dialect retains full PostgreSQL functionality while working exclusively with the psycopg2 DBAPI driver.

You use it by specifying a pgspider:// or pgspider+psycopg2:// connection URL in SQLAlchemy's create_engine(), then interact with PGSpider through the standard SQLAlchemy Core and ORM interfaces. It is a thin adapter layer—all actual PostgreSQL features available in SQLAlchemy 1.4.28 remain available.

Use it for:

• Connect to a PGSpider distributed database cluster using SQLAlchemy ORM for application development
• Execute raw SQL queries against PGSpider through SQLAlchemy's text() interface
• Migrate an existing PostgreSQL + SQLAlchemy application to use PGSpider as the backend
• Build multi-node database applications that need transparent sharding via PGSpider

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Provides a SQLAlchemy dialect that enables connections to PGSpider using SQLAlchemy's PostgreSQL interface and psycopg2 driver.

No. The package is abandoned (last release June 2023, no commits since) with zero community engagement. While the MIT license is permissive and install friction is low, the lack of maintenance means no fixes for compatibility issues with newer SQLAlchemy, psycopg2, or Python versions. Install only if you are locked into an old environment and PGSpider is a hard requirement; otherwise, seek an actively maintained alternative or contact the PGSpider project directly.

Install

sqlalchemy-pgspider on PyPI

pip install sqlalchemy-pgspider

uv add sqlalchemy-pgspider

poetry add sqlalchemy-pgspider

Installing sqlalchemy-pgspider

Before you install

Low install friction with a pure-Python wheel. However, the package is abandoned—last release was 2023-06-06 with no commits since, and it has zero repository stars. Maintenance has ceased.

License in practice

MIT license permits commercial and private use with minimal restrictions, requiring only license and copyright notice retention.

Quickstart

pip install sqlalchemy-pgspider

from sqlalchemy import create_engine, text

engine = create_engine("pgspider+psycopg2://user:password@localhost:4813/dbname")
with engine.connect() as conn:
    result = conn.execute(text("SELECT * FROM table"))
    for row in result:
        print(row)

Requires SQLAlchemy 1.4.27 or higher, psycopg2 (or psycopg2-binary) 2.9 or higher, and Python 3.7 or higher. PGSpider instance must be running and accessible.

Verify before relying

• Whether the package works with SQLAlchemy versions beyond 1.4.28 (documentation notes only 1.4.28 was tested)
• Current compatibility with modern psycopg2 versions and Python 3.10+ in practice
• Whether PGSpider itself is actively maintained and suitable for production use

Package facts

Evidence: sqlalchemy_pgspider-0.1.0-py3-none-any.whl

Tags

More Front-Ends packages