psqlpy

psqlpy copied to clipboard

OTEL instrumentation

2

Possible to add Open Telemetry instrumentation into psqlpy? This will give us good traceability. Reference https://github.com/open-telemetry/opentelemetry-python-contrib/tree/main/instrumentation/opentelemetry-instrumentation-asyncpg

kesavkolla

Support LISTEN/NOTIFY callback handlers

6

I'd like to be able to add a callback handler similar to asyncpg's [`connection.add_listener(...)`](https://magicstack.github.io/asyncpg/current/api/index.html#asyncpg.connection.Connection.add_listener) I'm agnostic on the API, if there is a more idiomatic PSQLPy abstraction or interface that's...

oliverlambson

Missing Support for SQLAlchemy Dialect in PSQLPy

1

#### Problem Currently, PSQLPy lacks a dedicated SQLAlchemy dialect, making it impossible to use PSQLPy as a backend with SQLAlchemy for seamless database interactions. This is a significant limitation for...

dmastapkovich

Integration for pgvecto.rs

2

There's a different project for storing vectors: https://github.com/tensorchord/pgvecto.rs It'd nice to have integration as well.

egorsmkv

How to use SET statements?

1

Postgres allow to add SET statements to set some parameters. Eg: SET datestyle TO postgres, dmy; SET TIME ZONE 'America/Los_Angeles'; How can use these SET statements as part of executing...

kesavkolla

~

chandr-andr

Performance issues

5

Hi, @chandr-andr , I'll look into the clippy issue later. One other thing you might want to look at is I ran a test I wrote locally and got the...

bymoye

Another thing is.... In the current pytest, it seems that the connection is not disconnected in the end. So the resources are always occupied. (The connection is not released correctly)...

bymoye