zope.sqlalchemy
Minimal Zope/SQLAlchemy transaction integration
Decision gist · record as of 2026-08-14
Yes, if you are building or maintaining a Zope or Pyramid application that requires SQLAlchemy and distributed transaction support. The package is stable and has no known vulnerabilities, but maintenance is aging (262 days since last release). Install only if you understand both SQLAlchemy and Zope transactions; it is not a general-purpose ORM integration and adds no abstraction layer. Verify ZPL-2.1 license compatibility with your project first.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.10 or later.
- Assumes familiarity with both SQLAlchemy and Zope's transaction manager; integration is minimal and does not abstract away either system's complexity.
- Low install friction with a pure-Python wheel.
License · maintenance · safety
ZPL-2.1 (unclear) — Licensed under ZPL-2.1 (Zope Public License), which is OSI-approved but less common than MIT or Apache 2.0. Verify compatibility with your project's license policy before adopting.
last release 2025-11-25 (262 days) · last repo commit 2025-11-25 · 35 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 344,530 downloads/mo, #7,372 on PyPI
Alternatives
Verify before relying
from zope.sqlalchemy import register
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker, scoped_session
import transaction
engine = create_engine("postgresql://user:pass@localhost/db")
DBSession = scoped_session(sessionmaker(bind=engine))
register(DBSession)
session = DBSession()
session.add(obj)
transaction.commit()- Whether the aging maintenance status (262 days since last release) affects stability for current SQLAlchemy versions
- Compatibility with SQLAlchemy 2.0+ ORM patterns beyond the examples shown in the description
What it is and what it does
zope.sqlalchemy is a lightweight bridge between SQLAlchemy's session management and Zope's transaction system. It registers SQLAlchemy sessions as participants in Zope's distributed transaction protocol, so that session commits and rollbacks are coordinated with the broader transaction context—useful in Zope-based applications, Pyramid web frameworks using pyramid_tm, and WSGI applications using repoze.tm2. The package does not attempt to define a Zope-specific way to configure engines; it only provides a data manager that hooks into SQLAlchemy's event system via a register() function.
The integration handles both simple commits and two-phase commits. Sessions default to an 'active' state on first use and move to 'changed' when ORM writes occur, avoiding unnecessary database commits. For raw SQL operations, you can manually mark the session as changed or configure it to start in 'changed' state. The package supports scoped sessions (required for threaded web servers) and allows fine-grained control over session lifecycle and transaction boundaries.
Use it for
- Integrate SQLAlchemy ORM into a Zope application where transactions must be coordinated across multiple resources
- Use Pyramid with pyramid_tm to manage SQLAlchemy session commits alongside other transactional operations
- Implement two-phase commit for SQLAlchemy sessions in distributed transaction scenarios
- Manage long-lived or scoped sessions in WSGI applications using repoze.tm2 for automatic transaction handling
- Coordinate raw SQL operations with Zope transactions by explicitly marking sessions as changed
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you are building or maintaining a Zope or Pyramid application that requires SQLAlchemy and distributed transaction support.
The package is stable and has no known vulnerabilities, but maintenance is aging (262 days since last release). Install only if you understand both SQLAlchemy and Zope transactions; it is not a general-purpose ORM integration and adds no abstraction layer. Verify ZPL-2.1 license compatibility with your project first.
Install
zope-sqlalchemy on PyPI
Before you install
Low install friction with a pure-Python wheel. Maintenance is aging—last release was 262 days ago—but the repository remains active and the package is marked Production/Stable. Suitable for established Zope or Pyramid projects where transaction integration is already a known requirement.
Requires Python 3.10 or later. Assumes familiarity with both SQLAlchemy and Zope's transaction manager; integration is minimal and does not abstract away either system's complexity.
License in practice
Licensed under ZPL-2.1 (Zope Public License), which is OSI-approved but less common than MIT or Apache 2.0. Verify compatibility with your project's license policy before adopting.
Quickstart
from zope.sqlalchemy import register
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker, scoped_session
import transaction
engine = create_engine("postgresql://user:pass@localhost/db")
DBSession = scoped_session(sessionmaker(bind=engine))
register(DBSession)
session = DBSession()
session.add(obj)
transaction.commit()Verify before relying
- Whether the aging maintenance status (262 days since last release) affects stability for current SQLAlchemy versions
- Compatibility with SQLAlchemy 2.0+ ORM patterns beyond the examples shown in the description
Package facts
| License | ZPL-2.1 unclear |
| Python support | Supports the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 4 packagespackagingSQLAlchemytransactionzope.interface |
| Maintenance | Aging 262 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 344,530 / month, #7,372 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 5 - Production/StableFramework :: PyramidFramework :: Zope :: 3Framework :: Zope :: 5Intended Audience :: DevelopersLicense :: OSI Approved :: Zope Public LicenseProgramming Language :: PythonProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Programming Language :: Python :: Implementation :: CPythonTopic :: DatabaseTopic :: Software Development :: Libraries :: Python Modules |
Evidence: zope_sqlalchemy-4.1-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “sqlalchemy zope transaction integration”
- zope.sqlalchemyIntegrates SQLAlchemy sessions with Zope's transaction manager,…
- repoze-sendmailCouples email sending with Zope transactions, ensuring messages are…
- transactionProvides a generic transaction management system for Python, handling…
Give your agent the search over MCP, or paste the wish link into any chat.
More Python Modules packages
Converts domain names between Unicode and ASCII-compatible encoding (Punycode) according to IDNA 2008 and Unicode Technical Standard 46, with security validation and broader script coverage than the standard library.
Install it if you work with internationalized domain names, need to validate domains, or use HTTP clients that depend on it transitively.
Setuptools is a Python build backend and package management tool that handles building, distributing, and installing Python packages, including support for C/C++ extension modules.
PyYAML parses and emits YAML 1.1 data format, enabling serialization and deserialization of configuration files and Python objects to and from human-readable YAML text.
Pydantic validates Python data structures against type hints, coercing and checking input at runtime to ensure it matches a declared schema.
Provides reusable metadata objects for use with PEP-593 `typing.Annotated` to express common constraints like bounds, collection sizes, and predicates on types.
Install it if you use or build libraries that need to express type constraints in a standardized, inspectable way—or if you want to annotate your own types with…
Provides runtime tools to inspect and introspect Python type annotations, enabling programmatic examination of type hints at execution time.
See also repoze-sendmail · sqlalchemy-mixins · transaction · pyramid-tm · sqlalchemy-mate · SQLAlchemy · SQLAlchemy-Continuum · casbin-async-sqlalchemy-adapter · sqlalchemy-spanner · fastcrud