psqlpy
psqlpy copied to clipboard
Asynchronous Python PostgreSQL driver written in Rust
Added geo types support from PostgreSQL and geo_types module in Rust. ## Description ## Motivation and Context ## How has this been tested? ## Screenshots (if appropriate): ## Types of...
Need to make chainable Connection Pool builder like in rust library.
I'm trying to connect using ConnectonPool and getting an error psqlpy.exceptions.RustPSQLDriverPyBaseError: Database engine pool exception: Error occurred while creating a new object: db error: ERROR: odyssey: c1fc39c4c6d6c: SSL is required...
ATM to use connection we need to write the following code: ```python connection_pool = psqlpy.ConnectionPool() conn = await connection_pool.connection() conn.execute("SELECT * from users") ``` But it would be more pythonic...
## Description ## Motivation and Context ## How has this been tested? ## Screenshots (if appropriate): ## Types of changes - [ ] Bug fix (non-breaking change which fixes an...
Hello, thank you for great job. I added your driver to [pgbeanch](https://github.com/JMarkin/pgbench/blob/psqlpy/_python/pgbench_python.py#L212-L232) from MagicStack team. And result super different then your. Full report https://public.jmarkin.ru/pgbeanch.html Example result psqlpy slower than all...
psqlpy-0.7.6 The following code raises: `psqlpy.exceptions.RustToPyValueMappingError: Can't convert value from driver to python type: Cannot convert PostgreSQL type _int4 into Python type, err: array contains too many dimensions` (the query...
Need to add support for Polygon geo type&
When passing a "quoting" column name to `binary_copy_to_table`, psqlpy raises syntax error. Callers have to wrap those columns in a double quote by themselves. It would be great to support...