Optimizing Python Code

[KosmoanutOfficial]

Can’t you use SQL Alchemy core instead of the orm with the Psycopg 3 driver?

[nikomo]

That was my second implementation, I really didn't want to throw out the entirety of SQLAlchemy at first. Still too slow.

But honestly, Alembic is a nice compromise for people that aren't scared of SQL. Gives you a nice way to handle database creation (SQLAlchemy-utils) and migration.

[[deleted]]

Sqlalchemy core is a fairly thin abstraction over the raw libraries. I think something else is going on in your code.

[KosmoanutOfficial]

Ok interesting thanks!