You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Is your feature request related to a problem? Please describe.
I wish I could use DuckDB in SQLx. SQLite is too slow for many of my applications, whereas DuckDB is exactly what I need.
Describe the solution you'd like
I'd like DuckDB support which parallels SQLite.
Describe alternatives you've considered
SQLite is an alternative. The official DuckDB bindings for Rust are totally good and usable, but being able to have compile-time SQL checks, and integration with the ORM layers on top of sqlx would be awesome!
Additional context DuckDB is an interesting database that is quite similar to SQLite (in-process execution, single-file databases, light weight, single-executable). Their client crate offers an API very similar to that of rusqlite. As an OLAP database, it is very fast, and very good for data analytics, an area which Rust is making large strides in (esp. with the development of Polars).
The text was updated successfully, but these errors were encountered:
#1999 is closed, so I opened a new issue to track this active request. Hopefully more people will get in here to vote for this one, as I think it has huge potential!
I would also be interested in this! For users who want to use embedded databases, from what I've read, DuckDB is the go-to embedded OLAP database. It doesn't fill the same role as SQLite. And sqlx doesn't support any competing embedded OLAP database products.
Is your feature request related to a problem? Please describe.
I wish I could use DuckDB in SQLx. SQLite is too slow for many of my applications, whereas DuckDB is exactly what I need.
Describe the solution you'd like
I'd like DuckDB support which parallels SQLite.
Describe alternatives you've considered
SQLite is an alternative. The official DuckDB bindings for Rust are totally good and usable, but being able to have compile-time SQL checks, and integration with the ORM layers on top of sqlx would be awesome!
Additional context
DuckDB is an interesting database that is quite similar to SQLite (in-process execution, single-file databases, light weight, single-executable). Their client crate offers an API very similar to that of rusqlite. As an OLAP database, it is very fast, and very good for data analytics, an area which Rust is making large strides in (esp. with the development of Polars).
The text was updated successfully, but these errors were encountered: