sqlalchemy-hana icon indicating copy to clipboard operation
sqlalchemy-hana copied to clipboard

Published 20 hours ago • verified publisher icon SAP

SQLAlchemy 1.4 support

Open PrieJos opened this issue 2 years ago • 4 comments

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

PrieJos avatar May 17 '22 09:05 PrieJos

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.

malaman avatar May 20 '22 13:05 malaman

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

jarus avatar Jun 21 '22 21:06 jarus

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

PrieJos avatar Jun 28 '22 07:06 PrieJos

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

SirUli avatar Sep 21 '22 11:09 SirUli

Hi @jarus

do you have any update on the progress? It seems as if that is resting since June last year?

In the meantime SQLAlchemy 2.0 has been release - will you jump on that?

Thanks in advance!

Best Regards, Uli

SirUli avatar Feb 22 '23 15:02 SirUli

Hi @jarus , I think a lot of people would appreciate if you could provide some statement about the current status of the project. If no maintenance is programmed for it because of resources or change of policies, I am sure that everyone will be understanding.

paoloalba avatar Aug 02 '23 19:08 paoloalba

I heard from the HANA product management that a new release is targeted for Q3/Q4 2023. I guess some more patience is needed...

SirUli avatar Aug 02 '23 20:08 SirUli

Hello all,

I'm sorry for the late reply and the status of the project. @jarus and myself will work put some effort in the project this year and will continue to maintain it. The goal is to release version 1.0 this year as tracked in https://github.com/SAP/sqlalchemy-hana/issues/102. Please have some more patience until we finished all the needed steps.

Thanks a lot!

Closed as superseded by https://github.com/SAP/sqlalchemy-hana/issues/102

kasium avatar Oct 04 '23 13:10 kasium