Show HN: Facata – Connect to SQL Databases from Python

Re:Show HN: Facata – Connect to SQL Databases from Python by BiteCode_dev on Saturday August 21, 2021 @07:17PM (#28261443)

SQLA automatically creates prepared statements and cache them: https://docs.sqlalchemy.org/en/14/dialects/postgresql.html#p...

I get that Facata is a smaller dependency chain. I'm also curioujs about the performance side, what areas is Facata more performant in, and how was it measure?

[ Parent | on HN ]

Re:Show HN: Facata – Connect to SQL Databases from Python by tlocke on Saturday August 21, 2021 @07:58PM (#28261699)

That prepared statement caching is a feature of a particular DBAPI driver rather than SQLAlchemy itself. I take your point though, and I'd say that Facata is designed to be an alternative to DBAPI 2 rather than an alternative to SQLAlchemy.

On the performance, I'm basing this on the fact that SQLAlchemy does a lot more than Facata. You're right though, actual measurements would be interesting.

[ Parent | on HN ]