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?