Releases: daneshpatel/sqlalchemy-jdbcapi
Releases · daneshpatel/sqlalchemy-jdbcapi
Release v2.2.1
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
Bump version: 2.1.3 → 2.2.0
Release v2.1.3
Bump version: 2.1.2 → 2.1.3
Release v2.1.2
Bump version: 2.1.1 → 2.1.2
Release v2.1.1
Bump version: 2.1.0 → 2.1.1
Release 2.0
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
- @yi-you made their first contribution in #15
- @daneshpatel made their first contribution in #17
Full Changelog: 1.3.0...2.0.0
Release: Oceanbase's Oracle mode support.
Added Support for add oceanbase's Oracle mode and bug fixes.