sqlalchemy-hana
sqlalchemy-hana copied to clipboard
SAP
SQLAlchemy 1.4 support
Dear Team,
According to the SQLAlchemy official site, the dialect sqlalchemy-hana is only supported until version 1.3. Since the version 1.3 is now in Maintenance and hence (I guess) it will change to EOL as soon as 2.0 is officially released, I was wondering whether you have any plan to support SQLAlchemy 1.4 in the near future?
The question originated from the fact that I am right now pondering the usage of SQLAlchemy as a foundation ORM library that connects to our SAP HANA database installation base for automating certain core technical processes in my company via Ansible. Since, as you may know, SQLAlchemy 1.4 brings new features that are recommended to be used in order to be Version 2.0 ready, I think it would be the right time for me to start that development based on version 1.4 instead of 1.3. Hence my question here.
Any light you can shed on that, it will be appreciated.
Thanks! Jose M. Prieto
It is also interesting if it is planned to support SQLAlchemy 1.4 caching mechanism.
I've measured performance of sqlalchemy-hana + sqlalchemy 1.4 vs raw hdcli for some upsert operations and sqlalchemy-hana was 3x slower for our test case.
Hi,
Sorry for the delayed response. Indeed, I'm working on SQLAlchemy 1.4 support. At the moment I don't won't to set any expectations towards a release date but also within SAP we are looking towards usage of SQLAlchemy 1.4. If you are interested in a preview and would like to test a work-in-progress version please check my sqlalchemy-1.4 branch.
Best regards, Christoph
Hi @jarus
This is great news! Thanks for sharing. I'll keep on eye on your work on the shared branch.
Sorry for the delayed response. Indeed, I'm working on SQLAlchemy 1.4 support. At the moment I don't won't to set any expectations towards a release date but also within SAP we are looking towards usage of SQLAlchemy 1.4. If you are interested in a preview and would like to test a work-in-progress version please check my sqlalchemy-1.4 branch.
Thanks Jose M. Prieto
Hi @jarus,
do you have an estimation when this might be completed / ready as a first release candidate? I know that you don't want to set a date - it is more for me to understand if we will see this within a month/quarter/half year/year.
Thanks in advance!
Best Regards, Uli
