asyncpg support

[ArunJRK]

Does dbos support asyncpg driver with sqlalchemy?

[kraftp]

Currently, DBOS uses the psycopg3 sync driver (postgresql+psycopg) internally. However, you can create your own SQLAlchemy engine and use it to perform database operations in DBOS steps (as both workflows and steps can be async def).

Would love to learn more about what you're building--what do you use that driver for?

[ArunJRK]

I like the idea of using a database as a source of truth for events and processing when things are lightweight. That's why DBOS is interesting.

I am currently building an app with long-running transactions and potential parallel requests and so, looking for a nonblocking way of transacting.

[kraftp]

Got it! Yeah, DBOS fully supports async steps and workflows, so you can access the database using an async driver from within a step (instead of using a DBOS-provided connection).