Meltanolabs-target-postgres

What's Changed
* chore: Bump sqlalchemy from 2.0.23 to 2.0.25 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/273
* chore: Bump flake8 from 6.1.0 to 7.0.0 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/272
* chore: Bump tox from 4.11.4 to 4.12.0 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/274
* chore: Bump tox from 4.12.0 to 4.12.1 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/275
* chore: Bump types-jsonschema from 4.20.0.20240105 to 4.21.0.20240118 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/276
* chore: Bump types-paramiko from 3.4.0.20240106 to 3.4.0.20240120 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/277
* chore: Pin build dependencies for stability by edgarrmondragon in https://github.com/MeltanoLabs/target-postgres/pull/279
* chore: Replace isort, flake8, black and pyupgrade with Ruff by edgarrmondragon in https://github.com/MeltanoLabs/target-postgres/pull/278
* chore: Enforce importing `sqlalchemy as sa` by edgarrmondragon in https://github.com/MeltanoLabs/target-postgres/pull/280
* chore: Bump pytest from 7.4.4 to 8.0.0 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/282
* chore: Bump ruff from 0.1.14 to 0.1.15 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/283
* chore: Looser dep dependency constraints by edgarrmondragon in https://github.com/MeltanoLabs/target-postgres/pull/284
* chore: Bump ruff from 0.1.15 to 0.2.0 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/285
* chore: Bump types-paramiko from 3.4.0.20240120 to 3.4.0.20240205 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/288
* chore: pre-commit autoupdate by pre-commit-ci in https://github.com/MeltanoLabs/target-postgres/pull/289
* fix: developer setup permissions on key files by prevostc in https://github.com/MeltanoLabs/target-postgres/pull/286
* chore: Bump ruff from 0.2.0 to 0.2.1 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/291
* chore: Bump singer-sdk from 0.34.1 to 0.35.0 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/290
* feat: Optionally store content marked as `"base16"` encoded into `bytea` columns by prevostc in https://github.com/MeltanoLabs/target-postgres/pull/287

New Contributors
* prevostc made their first contribution in https://github.com/MeltanoLabs/target-postgres/pull/286

**Full Changelog**: https://github.com/MeltanoLabs/target-postgres/compare/v0.0.10...v0.0.11rc1

What's Changed
* chore: pre-commit autoupdate by pre-commit-ci in https://github.com/MeltanoLabs/target-postgres/pull/216
* fix: numeric primary key columns no longer coerce to serial4 by sebastianswms in https://github.com/MeltanoLabs/target-postgres/pull/219
* feat: fixes with mypy, add tox, remove 3.7 support by sebastianswms in https://github.com/MeltanoLabs/target-postgres/pull/212
* chore: pre-commit autoupdate by pre-commit-ci in https://github.com/MeltanoLabs/target-postgres/pull/218
* chore: Bump singer-sdk from 0.33.0 to 0.33.1 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/229
* feat: Switch activate version logic to use sqlalchemy by sebastianswms in https://github.com/MeltanoLabs/target-postgres/pull/225
* fix: add test for multiple identical schema messages by sebastianswms in https://github.com/MeltanoLabs/target-postgres/pull/220
* feat: Verify data in tests (row count and first row) by sebastianswms in https://github.com/MeltanoLabs/target-postgres/pull/215
* feat: Refactor for a more efficient prepare_table() by sebastianswms in https://github.com/MeltanoLabs/target-postgres/pull/228
* doc: Datatype documentation by sebastianswms in https://github.com/MeltanoLabs/target-postgres/pull/234
* feat: Add SDK pytests by sebastianswms in https://github.com/MeltanoLabs/target-postgres/pull/227
* chore: Bump mypy from 1.6.1 to 1.7.1 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/233
* chore: Bump types-jsonschema from 4.19.0.3 to 4.20.0.0 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/232
* chore: Bump poetry from 1.6.1 to 1.7.1 in /.github/workflows by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/231
* chore: Bump black from 23.10.0 to 23.11.0 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/226
* chore: Bump pytest from 7.4.2 to 7.4.3 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/217
* chore: Bump cryptography from 41.0.5 to 41.0.6 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/236
* chore: pre-commit autoupdate by pre-commit-ci in https://github.com/MeltanoLabs/target-postgres/pull/235
* chore: Bump types-paramiko from 3.3.0.0 to 3.3.0.2 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/243
* chore: Bump tox from 4.11.3 to 4.11.4 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/244
* chore: Bump isort from 5.12.0 to 5.13.0 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/245
* chore: Bump actions/setup-python from 4 to 5 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/246
* chore: pre-commit autoupdate by pre-commit-ci in https://github.com/MeltanoLabs/target-postgres/pull/247
* chore: Bump black from 23.11.0 to 23.12.0 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/248
* chore: Bump isort from 5.13.0 to 5.13.1 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/249
* chore: Bump isort from 5.13.1 to 5.13.2 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/253
* build: Add support for Python 3.12 by amotl in https://github.com/MeltanoLabs/target-postgres/pull/252
* chore: pre-commit autoupdate by pre-commit-ci in https://github.com/MeltanoLabs/target-postgres/pull/258
* chore: Remove explicit dependency on pendulum by edgarrmondragon in https://github.com/MeltanoLabs/target-postgres/pull/259
* fix: Implement `NOTYPE.python_type` to fix adapting column types by edgarrmondragon in https://github.com/MeltanoLabs/target-postgres/pull/238
* chore: Bump mypy from 1.7.1 to 1.8.0 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/263
* chore: pre-commit autoupdate by pre-commit-ci in https://github.com/MeltanoLabs/target-postgres/pull/265
* feat: prepare_column() refactor and new activate_version config option. by sebastianswms in https://github.com/MeltanoLabs/target-postgres/pull/240
* chore: Bump pytest from 7.4.3 to 7.4.4 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/267
* chore: Bump black from 23.12.0 to 23.12.1 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/264
* chore: pre-commit autoupdate by pre-commit-ci in https://github.com/MeltanoLabs/target-postgres/pull/271
* chore: Bump singer-sdk from 0.33.1 to 0.34.1 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/262
* chore: Bump types-paramiko from 3.3.0.2 to 3.4.0.20240106 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/270
* chore: Bump types-jsonschema from 4.20.0.0 to 4.20.0.20240105 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/269
* chore: Bump paramiko from 3.3.1 to 3.4.0 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/261

New Contributors
* amotl made their first contribution in https://github.com/MeltanoLabs/target-postgres/pull/252

**Full Changelog**: https://github.com/MeltanoLabs/target-postgres/compare/v0.0.9...v0.0.10

What's Changed

* fix: Remove old code checking primary keys by sebastianswms in https://github.com/MeltanoLabs/target-postgres/pull/206
* fix: Use built-in RecordsWithoutSchemaException by sebastianswms in https://github.com/MeltanoLabs/target-postgres/pull/207
* feat: Support SQLAlchemy 2.0 by andyoneal in https://github.com/MeltanoLabs/target-postgres/pull/185
* feat: Switch from VARCHAR to TEXT. by sebastianswms in https://github.com/MeltanoLabs/target-postgres/pull/211
* feat: README badges by sebastianswms in https://github.com/MeltanoLabs/target-postgres/pull/210

* chore: Bump actions/checkout from 3 to 4 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/190
* chore: pre-commit autoupdate by pre-commit-ci in https://github.com/MeltanoLabs/target-postgres/pull/191
* chore: Bump cryptography from 41.0.3 to 41.0.4 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/197
* chore: pre-commit autoupdate by pre-commit-ci in https://github.com/MeltanoLabs/target-postgres/pull/195
* chore: Bump singer-sdk from 0.31.1 to 0.32.0 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/199
* chore: pre-commit autoupdate by pre-commit-ci in https://github.com/MeltanoLabs/target-postgres/pull/200
* chore: Bump poetry from 1.5.1 to 1.6.1 in /.github/workflows by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/182
* chore: Bump psycopg2-binary from 2.9.7 to 2.9.8 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/201
* chore: Bump psycopg2-binary from 2.9.8 to 2.9.9 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/203
* chore: Bump urllib3 from 1.26.16 to 1.26.17 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/202
* chore: Bump urllib3 from 1.26.17 to 1.26.18 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/209
* chore: Bump singer-sdk from 0.32.0 to 0.33.0 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/208
* chore: pre-commit autoupdate by pre-commit-ci in https://github.com/MeltanoLabs/target-postgres/pull/205

**Full Changelog**: https://github.com/MeltanoLabs/target-postgres/compare/v0.0.8...v0.0.9

What's Changed

* feat: Support No Type by andyoneal in https://github.com/MeltanoLabs/target-postgres/pull/183
* feat: Share Connector Instance with Sinks by andyoneal in https://github.com/MeltanoLabs/target-postgres/pull/184

Thank you andyoneal

* fix: Add lock files for meltano 3.0 by visch in https://github.com/MeltanoLabs/target-postgres/pull/188
* chore: Bump pytest from 7.4.0 to 7.4.1 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/186
* chore: Bump singer-sdk from 0.31.0 to 0.31.1 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/178
* chore: Bump pytest from 7.4.1 to 7.4.2 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/187




**Full Changelog**: https://github.com/MeltanoLabs/target-postgres/compare/v0.0.7...v0.0.8

What's Changed

Major bug in 0.0.6 regarding upserts. This is addressed thanks to andyoneal , there was also a bug with activate version also address by andyoneal Thank you!!

* fix: Constrain SQLAlchemy to <2 by edgarrmondragon in https://github.com/MeltanoLabs/target-postgres/pull/170
* fix: Upsert by andyoneal in https://github.com/MeltanoLabs/target-postgres/pull/175
* fix: Double quote identifiers when handling activate version by andyoneal in https://github.com/MeltanoLabs/target-postgres/pull/166


* chore: Bump black from 23.1.0 to 23.3.0 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/115
* chore: pre-commit autoupdate by pre-commit-ci in https://github.com/MeltanoLabs/target-postgres/pull/162
* chore: Bump psycopg2-binary from 2.9.6 to 2.9.7 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/171
* chore: Bump singer-sdk from 0.28.0 to 0.31.0 by dependabot in https://github.com/MeltanoLabs/target-postgres/pull/172

New Contributors
* andyoneal made their first contribution in https://github.com/MeltanoLabs/target-postgres/pull/175

**Full Changelog**: https://github.com/MeltanoLabs/target-postgres/compare/v0.0.6...v0.0.7