sqlx
sqlx copied to clipboard
🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.
The migration system of sqlx-cli has become usable now that it supports revertible migrations. However such migrations can sometimes be badly written and contain potential errors. As such I usually...
I am trying to fetch a column from an SQL table, the column type is boolean, but I get this error ``` Rust type `bool` (as SQL type `BOOLEAN`) is...
I am running into an issue I am not capable to resolve by myself. I have example code, where I want to call migrations inside the warp endpoint, using `SqliteConnection`:...
Fixes https://github.com/launchbadge/sqlx/issues/445. We've been using this in development to refresh RDS tokens and it works pretty well. Some outstanding work is left to do error typing properly.
This is used for converting type in FromRow.And I am not sure whether it is worth and just for discussing. ## Example ```rust #[derive(sqlx::FromRow)] struct Record { #[sqlx(try_from = "i64")]...
I recently started using sqlx for querying huge amount of data, about 12096001 rows x 6 columns. That is running on postgresql with timescaledb on top of it. Those are...
Fixes #1966. The same issue existed for other database types, so I've fixed them as well. I couldn't find any runtime tests for migrations yet, so I've extended the migrations...
Track empty/non-empty/unknown-emptiness of cursors as part of the state. That enables Rewind/Last operations to filter which branch path to take (instead of always assuming both paths are potentially valid). Also...
The sqlite CTE feature (#1816) introduced severe performance degradation, and this PR attempts to fix it. This patch drastically reduces search space by adding memorization based on register type and...
Idea: It would be interesting to select rows from the database and instantly and easily serialize to a data format. Blocked on #181