v2

New features

• Added support for MySQL and SQlite 🎉 !
• Completely SQL injection safe (everything is escaped or parameterized including schema, table and column names)
• Documentation improved
• Logo added ! (I am not much of a graphic designer but I did my best 🙈)

Deprecations

• pangres.pg_upsert became pangres.upsert (to reflect the fact that pangres can now handle other databases than postgres). pangres.pg_upsert will be removed in the next version!
• the argument "if_exists" of the old function pangres.pg_upsert was removed in the new pangres.upsert in favor of the argument "if_row_exists" whose functionnality is clearer. The equivalent of if_exists="upsert_overwrite" is now if_row_exists="update" and if_exists="upsert_keep" is now if_row_exists="ignore"

Breaking changes

• Contrary to the old function pangres.pg_upsert the new pangres.upsert function does not clean "bad" column names automatically for postgres. An error will be raised if any column contains "%" or "(" or ")" but you can use pangres.fix_psycopg2_bad_cols to fix such problems.

Changes for developers

• Testing improved! You can provide a connection string in the command line directly 👍 !