v0.11.2

What's Changed

• Supported new pyo3 interfaces by @Link-God in #141
• Resolved all warnings by @chandr-andr in #144
• Added pypy3.11 to build matrix by @bymoye in #143

New Contributors

• @Link-God made their first contribution in #141
• @bymoye made their first contribution in #143

Full Changelog: 0.11.1...0.11.2

v0.11.1

What's changed

• Small fix for error description

v0.11.0

What's Changed

• New realization of cursor, check it in docs: https://psqlpy-python.github.io/components/cursor.html
• New class for prepared statement representation: https://psqlpy-python.github.io/components/prepared_statement.html
• New internal implementations of Connection and Transaction
• Partially support DBAPI 2.0
• Updated documentation

Full Changelog: 0.10.1...0.11.0

v0.10.1

What's changed

• Minor changes in processing kwargs parameters.

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