Make TAD database connection async

[anneschuth]

Description:

It would significantly benefit the fastapi (which is async) to use a database connections that also is async. then the application is waiting for a response from the database is can still handle other requests. We are currently on: https://www.psycopg.org/docs/ We want to probably move to: https://github.com/MagicStack/asyncpg

Technical Steps:

• Research what the best engine/driver is for our application
• Adjust engine/driver for making calls to async (in the tad.core.config)

[github-actions[bot]]

This issue did not have any activity in the last 90 days and will be removed after 30 days