Tokio_postgres, postgres and Diesel seem to be the most popular, but I need a simple one that will execute a bunch of SQL queries for a PostgreSQL database the fastest. Diesel as a query builder seems to be too complicated as I already have the necessary queries written down, I just need something to execute them.
With psycopg2 in Python it would be like:
con = connect()
cur = con.cursor()
try:
cur.execute(sql_query)
except Exception:
cur.rollback()
else:
con.commit()
I would appreciate a lightweight lib to handle it like that, but the performance is also very important.
Additionally, what lighweight library would be good for string sanitization to prevent SQL injections?