reflex icon indicating copy to clipboard operation
reflex copied to clipboard
verified publisher icon reflex-dev

SQLAlchemy 2.0 compatibility

Open Viish opened this issue 2 years ago • 2 comments

Hi,

Describe the bug Pynecone requires SQLAlchemy ">=1.3.18,<1.4.43", but version 2.0 is out and if we don't want to use your DB API but SQLAlchemy directly we can't use the latest release...

Expected behavior Could you update the dependency to allow 2.0 ?

Thanks in advance!

Viish avatar Jun 05 '23 09:06 Viish

+1. This is a blocker for us, as we heavily use the SQLAlchemy 2.

Talking about that, pynecone should drop the tiangolo/sqlmodel. This is an unmaintained project, and it is possible to use SQLAlchemy 2 ORM now to get the same or better results.

bratao avatar Jun 13 '23 19:06 bratao

Yeah we are planning on dropping sql model and making out own the will support sql alchemy 2

Alek99 avatar Jun 13 '23 19:06 Alek99

+1. Would love to use reflex, but company is using SQLAlchemy 2 in all projects

lejansenampeers avatar Sep 20 '23 13:09 lejansenampeers

sqlmodel 0.0.12 has added support for SQLAlchemy to 2.0, so this should be possible now

benedikt-bartscher avatar Dec 06 '23 18:12 benedikt-bartscher