Show HN: Facata – Connect to SQL Databases from Python

Re:Show HN: Facata – Connect to SQL Databases from Python by frafra on Saturday August 21, 2021 @05:38PM (#28260797)

Nice project! Is it planned to use the with statement for transactions or having something like psycopg2.sql.Literal to do proper escaping in complex queries?

[ Parent | on HN ]

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

Thanks! Facata is really a low-level API, so the only SQL that's sent is what's explicitly sent. That means it wouldn't have a 'with' for transactions because that would require SQL to be sent 'behind the scenes'.

Thanks for pointing me in the direction of psycopg2.sql, it looks interesting and I'll give it some thought.

[ Parent | on HN ]