Skip to content

Releases: daneshpatel/sqlalchemy-jdbcapi

Release v2.2.1

19 Nov 13:22

Choose a tag to compare

Full Changelog: v2.2.0...v2.2.1

issues fixed:
#18
#11
#10
#9
#8
#6
#2

  • New Database Dialects:

    • GBase 8s dialect with Informix compatibility
    • IBM iSeries (AS/400) dialect with JT400 driver
    • Microsoft Access dialect via UCanAccess
    • Apache Avatica dialect (Phoenix, Calcite support)
  • Asyncio Support:

    • Full async/await support for Core and ORM
    • AsyncConnection and AsyncCursor classes
    • Async dialect variants for PostgreSQL, MySQL, Oracle, MSSQL, DB2, SQLite
    • Uses asyncio.to_thread() for non-blocking JDBC operations
  • HikariCP Connection Pooling:

    • High-performance JDBC connection pool integration
    • HikariConfig for pool configuration
    • HikariConnectionPool with stats, suspend/resume
    • Automatic connection validation and health checks
  • Database X-Ray Monitoring:

    • DatabaseMonitor for query performance tracking
    • QueryMetrics and QueryStats for aggregation
    • TracedCursor and TracedConnection for automatic profiling
    • Slow query detection with configurable callbacks
    • Query normalization for grouping similar queries
  • Docker Test Suite:

    • Docker Compose setup with PostgreSQL, MySQL, MariaDB, MSSQL
    • Functional tests for ORM and Core operations
    • GitHub Actions workflow for CI/CD integration

Release v2.2.0

19 Nov 12:59

Choose a tag to compare

Bump version: 2.1.3 → 2.2.0

Release v2.1.3

17 Nov 20:47

Choose a tag to compare

Bump version: 2.1.2 → 2.1.3

Release v2.1.2

17 Nov 20:26

Choose a tag to compare

Bump version: 2.1.1 → 2.1.2

Release v2.1.1

17 Nov 20:17

Choose a tag to compare

Bump version: 2.1.0 → 2.1.1

Release 2.0

16 Nov 20:10

Choose a tag to compare

What's Included in 2.0.0
Core Infrastructure

✅ JDBC Bridge: Native DB-API 2.0 implementation using JPype
✅ ODBC Support: pyodbc integration for native connectivity
✅ Automatic Driver Management: Maven Central integration
✅ Type Conversion: Comprehensive JDBC ↔ Python type mapping
✅ JVM Management: Automatic JVM lifecycle handling

SQLAlchemy Dialects

✅ PostgreSQL (JDBC + ODBC)
✅ MySQL/MariaDB (JDBC + ODBC)
✅ SQL Server (JDBC + ODBC)
✅ Oracle (JDBC + ODBC)
✅ DB2 (JDBC)
✅ SQLite (JDBC)
✅ OceanBase (JDBC)

Advanced Features

✅ Connection pooling support
✅ Transaction management
✅ Database reflection (tables, columns, indexes, FKs)
✅ ORM support with automapping
✅ Alembic migrations support
✅ DataFrame export (pandas, polars, pyarrow)
✅ Full type hints (mypy compatible)

Testing & Quality

✅ 251 comprehensive tests
✅ 65.47% code coverage
✅ All linting checks pass (ruff)
✅ CI/CD with GitHub Actions
✅ Python 3.10-3.13 support
✅ Functional tests for real-world scenarios

What's Changed

  • Fixes #14: Convert datetime to Java Timestamp in SQL statements by @yi-you in #15
  • feat(oceanbasejdbc): support passing query parameters as connection parameters by @yi-you in #16
  • Release/v2 by @daneshpatel in #17

New Contributors

Full Changelog: 1.3.0...2.0.0

Release: Oceanbase's Oracle mode support.

24 Oct 18:52
c6e7637

Choose a tag to compare

Added Support for add oceanbase's Oracle mode and bug fixes.