Async support?

[kylebarron]

It looks like right now this crate is synchronous-only. Do you have any interest in expanding to async drivers? E.g. sqlx for postgres?

[aljazerzen]

Yes, this is possible to implement without a lot of trouble.

Database drivers that I'm currently using either:

• already support async (postgres via tokio-postgres, mysql via mysql-async),
• execute the query in the current thread anyway (SQLite and DuckDB).

So I don't think there even is a need for something heavy such as sqlx.

---

The biggest pain point will be a whole new API, ideally in a separate crate. I think that most of the code can be reused, since it preforms only sync work. The only thing that will need to be rewritten is implementation of the API, namely Connector, Statement, ResultRead and Append.

[aljazerzen]

This issue is not a priority for me atm, so if anyone else wants it implemented, upvote the issue.