Denis Laxalde

Add type hints

3

We declare types for anosql API through stub files (.pyi). The Queries type includes a __getattr__() method definition in order to allow attributes set in add_query() using setattr. The library...

Previously, the `__doc__` attribute of query function was built from all comments of the query block (delimited by `-- name:` line). If the SQL query contained a description as header...

make wait_socket_{readable,writable}() accept a file descriptor

12

Both asyncio's `add_reader/writer()` and trio's `wait_{readable,writable}()` accept a file descriptor argument along with any object with a `fileno()` method (not just a `socket.socket`). Can we make anyio support a similar...

use anosql or an adhoc sql file loader

2

There is a lot of SQL queries as python strings in the code base. [anosql](https://anosql.readthedocs.io/) is a nice tool to embed SQL in python code as queries can be written...

processes sort with parallel worker is broken

4

See discussion at #291. From postgres 13, maybe we could rely on `leader_pid` column of `pg_stat_activity` view as first sort step on SQL side?

use "rich" for terminal rendering

5

I'm thinking of replacing blessed with [rich](https://github.com/willmcgugan/rich) as a terminal rendering library. Rich is now mature and provides high level features that would be nice for us as we could...

scrolling and wrapping

6

As noticed in #239, and described in more details in #257, scrolling is broken when queries are wrapped. At the moment, I don't see any good solution to this issue:...

When pg_activity looses its connection to postgres and succeeds to reconnect later on, all UI settings (e.g. change of refresh time, selected view, etc.) are lost; we should preserve those.

use anyio in "core" psycopg

25

This adds support for anyio in psycopg "core" (i.e. not the psycopg_pool) through an `AnyIOConnection` class, associated waiting functions and a custom `AnyIOLibpqWriter` implementation. This uses conditional imports and pulls...