Changelog

Unreleased

🗑️ Removed

  • Dropped python 3.8 support * If you still depend on python 3.8 use the 5.x version line

🧰 Internal

  • Removed pyexasol dbapi2 api shim (Now it is using the dbapi2 shim provided by the pyexasol project)

  • Remove testing against Exasol 7.0

  • Relocked dependencies

5.0.0 — 2024-02-02

🔧 Changed

  • Made pyodbc an optional dependency

  • Made websockets the default way to use sqlalchemy with exasol

  • Added deprecation warnings for pyodbc and trubodbc dialects

🧰 Internal

  • Relocked dependencies

4.6.3 — 2023-12-21

🔧 Changed

  • Changed pyodbc upper bound constraint (Allow larger upper bounds)

🧰 Internal

  • Relocked dependencies

  • Bumped versions of GitHub actions

  • Adjusted workflow triggers, to enable workflow runs for external branches

4.6.2 — 2023-11-22

🔧 Changed

  • Loosened the SQLAlchemy dependency constraint to >=1.4,<2

4.6.1 — 2023-11-06

🐞 Fixed

4.6.0 — 2023-07-18

🚀 Feature

  • Websocket based dialect have been stabilized and is officially supported now

    📘 Note: Inserting multiple empty row’s, facilitating default settings currently isn’t supported.

🐞 Fixed

4.5.1 — 2023-05-25

🐞 Fixed

  • Fixed missing websocket driver package in release deliverables

4.5.0 — 2023-05-24

  • Added Beta version of websocket based dialect

    🚨 Attention:

    This feature is currently in Beta, therefore it should not be used in production. We also recommend to have a look into the known issues, before you start using it.

    If you encounter any problem, please create an issue. With your feedback, we will be able stabilize this feature more quickly.

4.4.0 — 2023-05-16

🚨 Attention:

The turbodbc dependency was pinned to 4.5.4 due to issues with newer versions.

Failing tests in the SQLA compliance test suite, in regard to the turbodbc dialect won’t be addressed until explicitly required/requested by users.

Note: It is also very likely that turbodbc support will be dropped in future versions.

🐞 Fixed

✨ Added

  • Added websocket based dbapi2 compliant database driver

🔧 Changed

  • Updated pytest

  • Updated Dependencies

  • Loosened version constraints on ‘packaging’ dependency

  • Loosened dev dependency constraints

🧰 Internal

  • Changed changelog workflow

    • Removed scriv

    • Added unreleased section to track unreleased changes

  • Simplified workflows by factoring out python & poetry setup into an action

  • Added a internal category to the changelog fragment template

  • Added manual trigger for the gh-pages workflow

  • Removed workaround for outdated DB versions (for further details see https://github.com/exasol/sqlalchemy-exasol/issues/5)

  • Added exasol-integration-test-docker-environment as dev dependency

4.0.0 — 2022-12-01

✨ Added

  • Added support for SQLA 1.4

    Warning

    This upgrade is not backwards compatible with SQLA < 1.4

    Warning

    This version may impact the performance (see also SQLAlchemy docs). If you are not willing or able to pay those potential performance hits, you should wait until the tracking-issue #190 is resolved.

🗑️ Removed

  • Removed custom merge statement

    (If we will be notified, that someone depends on this feature, we are open to add it again.)

🔐 Security

  • Evaluated CVE-2022-42969

    • CVE will be silenced

    • The affected code is not used by our project itself, nor by the dependencies pulling in the vulnerable library.

      Checked dependencies:

🔧 Changed

  • Updated all dependencies

🐞 Fixed

  • Fixed link to project documentation

3.2.2 — 2022-08-12

✨ Added

  • Added turbodbc support

    • Re-enabled with new minimum base version 4.5.4

  • Added additional information to README

    • License information (badge)

    • Code formatter(s) in use (black, isort)

    • Linting score of the project

🔧 Changed

  • Changed changelog format * Changelog now can be found in the file CHANGELOG.rst

  • Reworked and restructured project documentation

🗑️ Removed

  • Removed markdown based changelog

3.1.1 — 2022-07-21

✨ Added

  • Added new exasol odbc driver 7.1.11

  • Added additional badges for to improve project status overview

🔧 Changed

  • Updated databases for testing to 7.1.9 and 7.0.18

  • Updated pyodbc dependency from 4.0.32 to 4.0.34

🐞 Fixed

  • Fixed CI/CD build and publish target

  • Fixed CI/CD to run tests against all configured databases

3.0.0 — 2022-07-14

🗑️ Removed

2.4.0 — 2022-05-19

🗑️ Removed

  • Removed odbc specific functionality from base dialect and moved it to the pyodbc dialect

  • Removed remaining python2 compatibility artifacts and switches

  • Dropped support for python versions < 3.7

🐞 Fixed

  • Fixed bug when accessing underlying odbc connection while using NullPool based engine Note: This addresses the superset issue-20105

2.3.0 — 2022-04-13

🗑️ Removed

  • Removed outdated documentation and resources

  • Dropped python 2.7 support

🔧 Changed

  • Update supported versions of EXASOL DB to 7.1.6 and 7.0.16

  • Update supported python versions to 3.6, 3.7, 3.8, 3.9

  • Bumped SQLAlchemy dependency to 1.3.24

  • Bumped pyodbc dependency to 4.0.32

  • Updated documentation to reflect the latest version changes etc.

  • Updated maintainer and contact information

🐞 Fixed

  • Fixed bug regarding maximum identifier length

  • Fixed bug with custom translate maps

  • Fixed bug regarding non existent error code mappings for EXASOL specific odbc error codes

2.2.0 — 2020-09-02

🔧 Changed

  • Updated dependencies

🐞 Fixed

  • Fixed performance problems for large tables/databases. For more details see PR

2.1.0 — 2020-05-28

🔧 Changed

  • Updated documentation (README.rst and INTEGRATION_TEST.md)

  • Updated dependencies

  • Replaced metadata queries with ODBC metadata to avoid deadlocks

2.0.10 — 2020-05-08

🔧 Changed

  • Updated SQLAlchemy dependency to 1.3.16

  • Updated six dependency to 1.14.0

  • Updated pyodbc dependency to 4.0.30

2.0.9 — 2019-10-18

✨ Added

  • Add support for computed columns to merge (contribution by @vamega)

🔧 Changed

  • Updated SQLAlchemy dependency to 1.3.10

2.0.8 — 2019-10-07

✨ Added

  • Added new EXASOL keywords (contribution from @vamega)

  • Added MERGE statement to auto commit heuristic (contribution from @vamega)

2.0.7 — 2019-10-01

🔧 Changed

  • Updated SQLAlchemy dependency to 1.3.8

2.0.6 — 2019-08-12

🗑️ Removed

  • Removed deprecated setting of ‘convert_unicode’ on engine

✨ Added

  • Added support for empty set expressions required by new SQLA tests

🔧 Changed

  • Updated PyODBC dependency to 4.0.27

  • Updated SQLAlchemy dependency to 1.3.6

🐞 Fixed

  • Fixed bug in reflection of CHAR colums (missing length). Contribution from @vamega

  • Fixed bug in rendering of SQL statements with common table expressions (CTE). Contribution from @vamega

2.0.5 — 2019-05-03

🔧 Changed

  • Updated SQLAlchemy dependency to 1.2.18

🐞 Fixed

  • Fixed bug in server version string parsing (turbodbc)

2.0.4 — 2018-10-16

🔧 Changed

  • Updated pyodbc dependency to 4.0.24

🐞 Fixed

  • Fix string parameters in delete when using Python 3

2.0.3 — 2018-08-02

🔧 Changed

  • Update SQLAlchemy dependency to 1.2.10

🐞 Fixed

  • Pass the autocommit parameter when specified also to turodbc.

2.0.1 — 2018-06-28

🗑️ Removed

  • Dropped EXASOL 5 support

✨ Added

  • Added support for the turbodbc parameters varchar_max_character_limit, prefer_unicode, large_decimals_as_64_bit_types, and limit_varchar_results_to_max.

🔧 Changed

  • Update SQLAlchemy dependency to 1.2.8

2.0.0 — 2018-01-09

🔧 Changed

  • BREAKING CHANGE: default driver name removed from dialect. The driver must now be explicitly specified. Either in the DSN or in the connection string using the optional ‘driver’ parameter (e.g. appending &driver=EXAODBC to connection URL)

  • Updated SQLAlchemy dependency to 1.2.0

  • Updated pyodbc dependency to 4.0.21

1.3.2 — 2017-10-15

🗑️ Removed

  • Dropped support for Python3 version < Python 3.6

🔧 Changed

  • Updated SQLAlchemy dependency to 1.1.14

1.3.1 — 2017-08-16

✨ Added

  • Added raw_sql to util.py for debugging

🔧 Changed

  • Updated SQLAlchemy dependency to 1.1.13

1.3.0 — 2017-08-02

✨ Added

  • Added EXASOL 6 driver (6.0.2)

🔧 Changed

  • Updated SQLAlchemy dependency to 1.1.12

🐞 Fixed

  • Fixed issue #53 - TRUNCATE statements now autocommited (if autocommit = True)

1.2.5 — 2017-08-02

🗑️ Removed

  • Removed support for EXASOL 4 driver

✨ Added

  • Added support for EXASOL 6

🔧 Changed

  • Updated pyodbc dependency to 4.0.17

  • Adjusted list of reserved keywords in respect to EXASOL 6

1.2.4 — 2017-06-26

🐞 Fixed

  • Fixed bug introduced by typo in base.py:454

1.2.3 — 2017-06-20

✨ Added

  • Added missing kw arg in limit_clause (contribution from sroecker)

🔧 Changed

  • Updated SQLAlchemy dependency to 1.1.11

  • Changed EXAExecutionContext.executemany to default ‘False’

🐞 Fixed

  • Fixed bug with incorrect handling of case insensitive names (lower case in SQLA, upper case in EXASOL)

  • Fixed bug in lookup of default schema name to include schema provided in connection url

1.2.2 — 2017-05-29

🐞 Fixed

  • Fixed failing upload of build results to pypi

1.2.1 — 2017-05-25

🐞 Fixed

  • Fixed ODBC Driver name that is to be used

  • Use unicode on osx for turbodbc fixes #63

1.2.0 — 2017-04-04

✨ Added

  • Added Support for Python 3.6

🔧 Changed

  • Turbodbc support uses buffer size based on memory budget instead of a fixed number of rows.

  • Turbodbc support requires turbodbc>=0.4.1

1.1.1 — 2016-10-14

🔧 Changed

  • Upgrade sqlalchemy test dependency to 1.1.1

1.1.0 — 2016-07-15

🗑️ Removed

  • Dropped EXASOL 4 support

✨ Added

1.0.3 — 2016-04-14

🔧 Changed

  • Reconnect after socket closed

1.0.2 — 2016-03-12

✨ Added

  • Added supports_native_decimal Flag

🔧 Changed

  • Improved DSN handling

🐞 Fixed

  • Fixed Unicode Problems for OSX/Darwin

1.0.1 — 2015-03-21

✨ Added

  • Added OFFSET Support for Exasol 5.X

  • Added Tests for Python 3.5

1.0.0 — 2015-05-15

🗑️ Removed

  • Dropped support for sqlalchemy versions < 1.0.x

🔧 Changed

  • Update sqlalchemy dependency to 1.0.x

0.9.3 — 2015-05-13

🔧 Changed

  • Changed execute behaviour for deletes as fixed in 0.9.2 for updates (#36)

0.9.2 — 2015-05-06

🐞 Fixed

  • Changed execute behaviour for updates fixes #36

0.9.1 — 2015-01-29

✨ Added

  • Added support for DISTRIBUTE BY table constraints

0.9.0 — 2015-01-26

✨ Added

  • Added support for EXASolution 5.x

  • Added documentation on how to setup the integration test against the EXASOL hosted test db

🔧 Changed

  • Mark connection in pool as closed to prevent reuse

  • Use bulk reflection per schema and improved caching for inspection

🐞 Fixed

  • Fixed conversion to uppercase in connection parameters

0.8.5 — 2014-07-31

✨ Added

  • Added Python 3.4 test

🔧 Changed

  • Set default schema to ‘SYS’ to create reasonable reflections

0.8.4 — 2014-07-30

🔧 Changed

  • Downgrade six dependency selector to >=1.5

0.8.3 — 2014-07-18

🐞 Fixed

  • Fixed versioneer build parameter in setup.py to enable pip install

0.8.2 — 2014-07-17

✨ Added

  • Added README

0.8.1 — 2014-06-26

✨ Added

  • Added p3k support - contribution by iadrich

🔧 Changed

  • Updated repository url

0.8.0 — 2014-06-26

✨ Added

  • Added support for SQL MERGE

🔧 Changed

  • Updated SQLA dependency selector to 0.9.x (build requires >= 0.9.6)

🐞 Fixed

  • Fixed incorrect quoting of identifiers with leading _

  • Fixed incorrect implementation for retrieving last generated PK (for auto inc columns)

0.7.5 — 2014-05-08

🔧 Changed

  • Switched to versioneer

0.7.4 — 2014-04-01

🔧 Changed

  • changed README from md to rst to display reasonable content on pypi

0.7.0 — 2014-03-28

✨ Added

  • Added first version of the SQLAlchemy EXASOL dialect (released under BSD license)