Backend refactoring - psycopg3 and async views
The backend needs a lot of work. The current greenlet implementation needs refactoring. Psycopg2 has been replaced by psycopg3 and now has native support from Django. I am not sure if the pgbouncer and other things will be necessary after that.
Also, Django does support asynchronous views. It would probably be smart to implement the entire backend with async def's. Do we want that? Pros and cons?