0.11.6

Bumped version to 0.11.6

v0.11.4

What's Changed

• Added support for just array in JSONB column by @chandr-andr in #154

Full Changelog: 0.11.3...0.11.4

v0.11.3

What's Changed

• Fixed a documentation error by @bymoye in #145
• Moved all modified deps to psqlpy organization by @chandr-andr in #149
• change result and more optimizations by @bymoye in #148
• Add Panther framework usage example by @AliRn76 in #152
• Added new as_tuple parameter to QueryResult by @chandr-andr in #147
• Fixed openssl version by @chandr-andr in #153

New Contributors

• @AliRn76 made their first contribution in #152

Full Changelog: 0.11.2...0.11.3

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