psqlpy

What's Changed

• Fixed problem with nested arrays in JSONs fields by @chandr-andr in https://github.com/psqlpy-python/psqlpy/pull/83

Full Changelog: https://github.com/psqlpy-python/psqlpy/compare/0.7.8...0.7.9

Dependencies update

All tokio-postgres dependencies were updated to the last version.

Full Changelog: https://github.com/psqlpy-python/psqlpy/compare/0.7.7...0.7.8

What's Changed

• Add geo types to supported types in docs by @Mernus in https://github.com/psqlpy-python/psqlpy/pull/77
• Added support for multi-dimensional arrays by @chandr-andr in https://github.com/psqlpy-python/psqlpy/pull/81

Full Changelog: https://github.com/psqlpy-python/psqlpy/compare/0.7.6...0.7.7

What's Changed

• Added benchmarks in docs by @chandr-andr in https://github.com/psqlpy-python/psqlpy/pull/76
• Add support Geometric Types (except Polygons) by @Mernus in https://github.com/psqlpy-python/psqlpy/pull/30

New Contributors

• @Mernus made their first contribution in https://github.com/psqlpy-python/psqlpy/pull/30

Full Changelog: https://github.com/psqlpy-python/psqlpy/compare/0.7.5...0.7.6

What's Changed

• Added context manager support to ConnectionPool by @chandr-andr in https://github.com/psqlpy-python/psqlpy/pull/74
  Check more on docs - https://psqlpy-python.github.io/components/connection_pool.html#use-connection-pool-as-context-manager

Full Changelog: https://github.com/psqlpy-python/psqlpy/compare/0.7.4...0.7.5

What's Changed

• Fixed problem with require sslmode by @chandr-andr in https://github.com/qaspen-python/psqlpy/pull/70

Full Changelog: https://github.com/qaspen-python/psqlpy/compare/0.7.3...0.7.4

What's Changed

• Added method binary_copy_to_table by @chandr-andr in https://github.com/qaspen-python/psqlpy/pull/69

Full Changelog: https://github.com/qaspen-python/psqlpy/compare/0.7.2...0.7.3

What's Changed

• Fixed minimal array size by @chandr-andr in https://github.com/qaspen-python/psqlpy/pull/66

Full Changelog: https://github.com/qaspen-python/psqlpy/compare/0.7.1...0.7.2

What's Changed

• Added SSL support by @chandr-andr in https://github.com/qaspen-python/psqlpy/pull/60
• Changed actions by @chandr-andr in https://github.com/qaspen-python/psqlpy/pull/63

Full Changelog: https://github.com/qaspen-python/psqlpy/compare/0.7.0...0.7.1

Made connection management better.

Now you can:

• Manually send a connection back to the connection pool.
• Use connection in async context management with the acquire method in ConnectionPool.
• Resize connection pool in runtime with resize method.
• Retrieve connection pool status with status method.

There was a problem with possible deadlock, but now it's solved.

We highly recommend you update your services with the new 0.7.0 version of the package.*

What's Changed

• moved docs to repo by @chandr-andr in https://github.com/qaspen-python/psqlpy/pull/57
• Better connection management by @chandr-andr in https://github.com/qaspen-python/psqlpy/pull/58

Full Changelog: https://github.com/qaspen-python/psqlpy/compare/0.6.8...0.7.0

New predefined row factories

Check on docs: https://qaspen-python.github.io/psqlpy-docs/usage/row_factories/predefined_row_factories.html

What's Changed

• Added predefined row factories by @chandr-andr in https://github.com/qaspen-python/psqlpy/pull/55

Full Changelog: https://github.com/qaspen-python/psqlpy/compare/0.6.7...0.6.8

Row Factory

Now it's possible to define your own function to convert results from database.

What's Changed

• Added row_factory method for query results by @chandr-andr in https://github.com/qaspen-python/psqlpy/pull/54

Full Changelog: https://github.com/qaspen-python/psqlpy/compare/0.6.6...0.6.7

Full Changelog: https://github.com/qaspen-python/psqlpy/compare/0.6.5...0.6.6

New Types supported

Now it's possible to use XML, NUMERIC and MONEY type in PostgreSQL

What's Changed

• Supported more types by @chandr-andr in https://github.com/qaspen-python/psqlpy/pull/53

Full Changelog: https://github.com/qaspen-python/psqlpy/compare/0.6.4...0.6.5

What's Changed

• Supported ENUM PostgreSQL Type by @chandr-andr in https://github.com/qaspen-python/psqlpy/pull/50

Full Changelog: https://github.com/qaspen-python/psqlpy/compare/0.6.3...0.6.4

What's Changed

• Added musl build. by @s3rius in https://github.com/qaspen-python/psqlpy/pull/51 and @s3rius in https://github.com/qaspen-python/psqlpy/pull/52

New Contributors

• @s3rius made their first contribution in https://github.com/qaspen-python/psqlpy/pull/51

Full Changelog: https://github.com/qaspen-python/psqlpy/compare/0.6.2...0.6.3

Changes for extra types.

• PyUUID extra type is removed, it's possible to use UUID python type directly in parameters.
• We support FLOAT4 and FLOAT8 in PostgreSQL, in previous releases we supported only Float4.
  If you want to add FLOAT8 to the PostgreSQL table, use Float64 type from extra types.

What's Changed

• Removed unnecessary extra types (PyUUID removed) by @chandr-andr in https://github.com/qaspen-python/psqlpy/pull/48
• Added support for FLOAT4/FLOAT8 in PostgreSQL by @chandr-andr in https://github.com/qaspen-python/psqlpy/pull/49

Full Changelog: https://github.com/qaspen-python/psqlpy/compare/0.6.1...0.6.2

What's Changed

• Started implementing chain to create pool by @chandr-andr in https://github.com/qaspen-python/psqlpy/pull/44
• Added cursor method for connection by @chandr-andr in https://github.com/qaspen-python/psqlpy/pull/46

Full Changelog: https://github.com/qaspen-python/psqlpy/compare/0.6.0...0.6.1

This release creates new readable and extendable exceptions.
Now it is easier to write try-except blocks and control library execution.
More on our docs: Exceptions

What's Changed

• Rewritten all exceptions by @chandr-andr in https://github.com/qaspen-python/psqlpy/pull/39, https://github.com/qaspen-python/psqlpy/pull/41

Full Changelog: https://github.com/qaspen-python/psqlpy/compare/0.5.6...0.6.0

What's Changed

• Added fetch method, changed parameters annotations by @chandr-andr in https://github.com/qaspen-python/psqlpy/pull/38

Full Changelog: https://github.com/qaspen-python/psqlpy/compare/0.5.5...0.5.6