___
[Full Changelog](https://github.com/ThibTrip/pangres/compare/v2.2...v2.2.1)
**Closed issues:**
- Pangres does something to the root logger that now everything identifies as pangres [\20](https://github.com/ThibTrip/pangres/issues/20)
- Logging set up in utils.py can conflict with logging profiles in calling script [\18](https://github.com/ThibTrip/pangres/issues/18)
**Merged pull requests:**
- \[ENH\]: add \_\_version\_\_ attribute [\22](https://github.com/ThibTrip/pangres/pull/22) ([ThibTrip](https://github.com/ThibTrip))
- \[BUGFIX\]: Second attempt at fixing logging [\21](https://github.com/ThibTrip/pangres/pull/21) ([ThibTrip](https://github.com/ThibTrip))
- \[BUGFIX\] Configure the logger instead of configuring logging [\19](https://github.com/ThibTrip/pangres/pull/19) ([ThibTrip](https://github.com/ThibTrip))
[v2.2](https://github.com/ThibTrip/pangres/releases/tag/v2.2) (2020-08-22)
**Release Notes**
___
**_Breaking changes_**
* Removal of previously deprecated function <code>pangres.pg_upsert</code> (use <code>pangres.upsert</code> instead)
* In function <code>pangres.upsert</code> the arguments <code>create_schema</code> and <code>add_new_columns</code> have been set to False by default (they were previously both set to True by default) as this would be the common expectation (i.e. failing on missing schema or missing column). See 15. Thanks to lsloan and rajrohan.
___
[Full Changelog](https://github.com/ThibTrip/pangres/compare/v2.1...v2.2)
**Closed issues:**
- make `add_new_columns` default to `False` [\15](https://github.com/ThibTrip/pangres/issues/15)
- It is actually compatible with unique constraint [\12](https://github.com/ThibTrip/pangres/issues/12)
- Primary key requirement [\11](https://github.com/ThibTrip/pangres/issues/11)
**Merged pull requests:**
- \[CORE\] Remove pg upsert as planned \(deprecated\) [\17](https://github.com/ThibTrip/pangres/pull/17) ([ThibTrip](https://github.com/ThibTrip))
- \[CORE\] set create\_schema and add\_new\_columns to False by default [\16](https://github.com/ThibTrip/pangres/pull/16) ([ThibTrip](https://github.com/ThibTrip))
- \[DOC\] Indicate that we can use unique keys and not just PKs [\14](https://github.com/ThibTrip/pangres/pull/14) ([ThibTrip](https://github.com/ThibTrip))
- \[TEST\] Add tests that show pangres also works with unique keys [\13](https://github.com/ThibTrip/pangres/pull/13) ([ThibTrip](https://github.com/ThibTrip))
[v2.1](https://github.com/ThibTrip/pangres/releases/tag/v2.1) (2020-04-11)
**Release Notes**
___
**_Bugfixes_**
* Fixed bug where the "ON...CONFLICT" statement would be repeated leading to a syntax error in SQL insert statements
**_Changes for developers_**
* Testing instructions changed
* Added necessary tools to generate the documentation (see folder pangres/docs)
___
[Full Changelog](https://github.com/ThibTrip/pangres/compare/v2...v2.1)
**Fixed bugs:**
- BUG: fix coverage [\7](https://github.com/ThibTrip/pangres/issues/7)
**Merged pull requests:**
- TEST: Add testing via doctest [\10](https://github.com/ThibTrip/pangres/pull/10) ([ThibTrip](https://github.com/ThibTrip))
- BUGFIX: Improve coverage [\9](https://github.com/ThibTrip/pangres/pull/9) ([ThibTrip](https://github.com/ThibTrip))
- BUGFIX: fix issue where "ON CONFLICT" clause appears twice in the insert query [\8](https://github.com/ThibTrip/pangres/pull/8) ([ThibTrip](https://github.com/ThibTrip))
- BUGFIX: fix bugs in tests [\6](https://github.com/ThibTrip/pangres/pull/6) ([ThibTrip](https://github.com/ThibTrip))
- DOC: Fix broken anchor link [\5](https://github.com/ThibTrip/pangres/pull/5) ([ThibTrip](https://github.com/ThibTrip))
[v2](https://github.com/ThibTrip/pangres/releases/tag/v2) (2020-04-04)
**Release Notes**
___
**_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 <code>if_exists="upsert_overwrite"</code> is now <code>if_row_exists="update"</code> and <code>if_exists="upsert_keep"</code> is now <code>if_row_exists="ignore"</code>
**_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 👍 !
___
[Full Changelog](https://github.com/ThibTrip/pangres/compare/v1.3.1...v2)
**Merged pull requests:**
- DOC: Update README.md [\4](https://github.com/ThibTrip/pangres/pull/4) ([ThibTrip](https://github.com/ThibTrip))
- CORE: Add support for other databases \(MySQL, SQlite and potentially others\) [\3](https://github.com/ThibTrip/pangres/pull/3) ([ThibTrip](https://github.com/ThibTrip))
[v1.3.1](https://github.com/ThibTrip/pangres/releases/tag/v1.3.1) (2020-02-16)
**Release Notes**
___
* Drastically improved speed for small datasets (<= 100 rows and <= 20 columns)
___
[Full Changelog](https://github.com/ThibTrip/pangres/compare/v1.3...v1.3.1)
**Merged pull requests:**
- CORE: Bump to version 1.3.1 [\2](https://github.com/ThibTrip/pangres/pull/2) ([ThibTrip](https://github.com/ThibTrip))
- CORE:Improve performance [\1](https://github.com/ThibTrip/pangres/pull/1) ([ThibTrip](https://github.com/ThibTrip))
[v1.3](https://github.com/ThibTrip/pangres/releases/tag/v1.3) (2020-01-31)
**Release Notes**
___
___
[Full Changelog](https://github.com/ThibTrip/pangres/compare/6150b7b5374ba5aba25c42c6d253d18c0f7fc81f...v1.3)
\* *This Changelog was automatically generated by [github_changelog_generator](https://github.com/github-changelog-generator/github-changelog-generator)*