search

SAP / sqlalchemy-hana

SQLAlchemy Dialect for SAP HANA
Apache License 2.0
128 stars 56 forks source link

SQLAlchemy 1.4 support #94

Closed PrieJos closed 1 year ago

PrieJos commented 2 years ago

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

malaman commented 2 years ago

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.

jarus commented 2 years ago

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

PrieJos commented 2 years ago

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

SirUli commented 2 years ago

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 commented 1 year ago

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

paoloalba commented 1 year ago

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.

SirUli commented 1 year ago

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

kasium commented 1 year ago

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