v0.10.0

What's Changed

• Fixed problem when the external connection pool is used in Transaction mode. Now PgBouncer, Supavisor, etc can be used.
  Read more in the docs on how to use PSQLPy in External connection pools.
• External types for primitive data types are not necessary now.

Deprecated external types:

• BigInt -> int
• Integer -> int
• SmallInt -> int
• Float32 -> float
• Float64 -> float
• VarChar -> str
• Text -> str
• JSON -> dict/list
• JSONB -> dict/list
• All array types are deprecated, too.

0.9.3

What's Changed

• Added support for named parameters by @chandr-andr in #129

Named parameters

Now it's possible to use mapping (anything that supports Mapping protocol) for parameters.

async def main():
    ...

    await connection.execute(
        querystring="SELECT * FROM users WHERE id = $(user_id)p",
        parameters=dict(user_id=101),
    )

Full Changelog: 0.9.2...0.9.3

v0.9.2

Github workflow fix

PSQLPy for different Python is downloadable.

Full Changelog: 0.9.1...0.9.2

v0.9.1

What's Changed

• Update lets_start.md by @CodeBooster97 in #123
• Refactor execute-like methods by @chandr-andr in #125
• Prepared psqlpy for OTLP by @chandr-andr in #126

New Contributors

• @CodeBooster97 made their first contribution in #123

Full Changelog: 0.9.0...0.9.1

v0.9.0

What's Changed

• Added Listener class with PostgreSQL LISTEN functionality by @chandr-andr in #121

Full Changelog: 0.8.7...0.9.0

v0.8.7

Breaking changes with naming

We've changed naming for some external types, there are all changes, please follow them in your code:

• PyVarChar -> VarChar
• PyText -> Text
• PyJSON -> JSON
• PyJSONB -> JSONB
• PyMacAddr6 -> MacAddr6
• PyMacAddr8 -> MacAddr8
• PyPoint -> Point
• PyBox -> Box
• PyPath -> Path
• PyLine -> Line
• PyLineSegment -> LineSegment
• PyCircle -> Circle

What's Changed

• docs: typos by @pdecat in #113
• Renamed classes, removed Py prefix by @chandr-andr in #114

New Contributors

• @pdecat made their first contribution in #113

Full Changelog: 0.8.6...0.8.7

v0.8.6

What's Changed

• Changed lints by @chandr-andr in #110
• Add-support-datetime-zone-info by @RKN01011 in #111

New Contributors

• @RKN01011 made their first contribution in #111

Full Changelog: 0.8.5...0.8.6

v0.8.5

What's Changed

• Added PgVector integration by @chandr-andr in #102

Full Changelog: 0.8.4...0.8.5

v0.8.4

Full Changelog: 0.8.3...0.8.4

0.8.3

Return actual bytes instead of list of ints for BYTEA type

Signed-off-by: chandr-andr (Kiselev Aleksandr) <chandr@chandr.net>