Skip to content

Releases: alt-python/pydbc

v1.1.0

30 Mar 19:56

Choose a tag to compare

[1.1.0] - 2026-03-30

Added

  • alt-python-pydbc-teradata driver wrapping teradatasql (Teradata's official DBAPI2 package, qmark paramstyle); URL: pydbc:teradata://user:pw@host:1025/dbname

v1.0.0

28 Mar 04:36

Choose a tag to compare

[1.0.0] - 2026-03-28

Added

  • pydbc_core package: ABCs for Driver, Connection, Statement, PreparedStatement, ResultSet, DataSource, ConnectionPool
  • DriverManager with URL-based dispatch; drivers self-register on import
  • GenericDbApiDriver — wraps any PEP 249 DB-API 2.0 compliant module
  • ParamstyleNormalizer — translates ? / :name SQL to any DB-API 2.0 paramstyle at execution time
  • SimpleConnectionPool — thread-safe bounded connection pool backed by queue.Queue
  • PooledDataSource — DataSource backed by a pool; with ds.get_connection() as conn: returns connection to pool on exit
  • NamedParameterDataSource — accepts :paramName SQL + dict; mirrors Spring's NamedParameterJdbcTemplate
  • SingleConnectionDataSource — simple DataSource wrapping a single connection URL
  • Context manager support on all resource types (__enter__ / __exit__)
  • alt-python-pydbc-sqlite driver wrapping stdlib sqlite3 (qmark paramstyle); URL: pydbc:sqlite:./path
  • alt-python-pydbc-pg driver wrapping psycopg2 (pyformat paramstyle); URL: pydbc:pg://host:port/dbname
  • alt-python-pydbc-mysql driver wrapping PyMySQL (pyformat paramstyle); URL: pydbc:mysql://host:port/dbname
  • alt-python-pydbc-mssql driver wrapping pymssql (pyformat paramstyle); URL: pydbc:mssql://host:port/dbname
  • alt-python-pydbc-oracle driver wrapping oracledb (python-oracledb, thin mode, numeric paramstyle); URL: pydbc:oracle://user:pw@host:1521/service_name
  • docs/assessment.md — Python DB access landscape analysis and pydbc design rationale
  • docs/getting-started.md — end-to-end tutorial
  • docs/api-reference.md — full API reference for all pydbc_core exports
  • docs/driver-guide.md — guide for writing custom drivers
  • Per-package README files