NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
PyPI · #5200 most downloaded on PyPI
CockroachDB dialect for SQLAlchemy
Last release 5 months ago
23 Apr 2026
Release timing varies
gaps range from 9 days to 1.4 years
Most releases are documented
notes for 15 of 18 stable releases
Nothing withdrawn
no release was ever pulled
6 years old
18 releases · first in 2020
One column per quarter.
Fix reflection of TIMESTAMPTZ columns (#276), thanks to @nvachhar
April 23, 2026
func.timestampdiff(unit, start, end) to a
PostgreSQL-style EXTRACT(EPOCH FROM ...) expression on the cockroachdb
dialect. The arithmetic result is wrapped in TRUNC() so the value matches
MySQL's integer-truncation-toward-zero semantics (a 90-second diff at
MINUTE returns 1, not 1.5), and is cast to NUMERIC so callers may safely
combine it with integer or numeric divisors -- avoiding the float / decimal
arithmetic errors CockroachDB rejects but PostgreSQL accepts. Supported
units: MICROSECOND, MILLISECOND, SECOND, MINUTE, HOUR, DAY, WEEK.
Calendar-aware units (MONTH, QUARTER, YEAR) are explicitly rejected with a
specific error message because they require calendar walking that cannot be
derived from epoch arithmetic alone. Enables cross-dialect ORMs (e.g.
Apache Airflow) that fall back to timestampdiff for non-PostgreSQL
backends.Add support for READ COMMITTED transaction isolation (see README.read_committed.md)
June 10, 2025
Implement reflection for array types
January 10, 2024
Enable AUTOCOMMIT isolation_level for SQLA 2.0
April 14, 2023
Applied dialect code and test changes for compatibility with SQLAlchemy 2.0. This version of the dialect requires SQLAlchemy 2.0, so to work with earl
Released February 21, 2023
pip install sqlalchemy-cockroachdb<2.0.0Nothing published for this version
Nothing published for this version
Added include_hidden option to get_columns() to enable reflection of columns like "rowid".
Released September 9, 2022
include_hidden option to get_columns() to enable reflection of columns like "rowid". (#173).with_hint() (patch courtesy of Jonathan Dieter)Added preliminary support for asyncpg. See instructions in the README.
Released December 10, 2021
Updated version telemetry to only report major/minor version of SQLAlchemy.
Released October 21, 2021
Updated test suite to work with Alembic 1.7.
Released October 12, 2021
Add telemetry to SQLAlchemy CockroachDB
Released July 29, 2021
Example: engine = create_engine('cockroachdb://...', connect_args={"disable_cockroachdb_telemetry": True})Nothing published for this version
Remove duplicates_constraint property for unique indexes
Released April 26, 2021
duplicates_constraint property for unique indexesStopped returning primary keys in get_indexes.
Released September 29, 2020
Added more support computed columns.
Released July 13, 2020
Version number increased to 1.3.0 to indicate compatibility with SQLAlchemy 1.3.x.
Released June 10, 2020
Renamed package to sqlalchemy-cockroachdb.
Released April 10, 2020
Your coding agent can read these notes before it upgrades. Set up the MCP server →