tutorials
sqlx


tutorials | sqlx | |
---|---|---|
1 | 151 | |
10 | 14,069 | |
- | 2.3% | |
1.0 | 9.4 | |
over 1 year ago | 7 days ago | |
Go | Rust | |
- | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
tutorials
-
Hey Rustaceans! Got a question? Ask here! (27/2022)!
I'm trying to use reqwest to download a file and show it's progress. I found exactly what I need here however this seems to just write ontop of the file rather than resume, That still eludes me. Is there an example somewhere I can look at? Most of the examples I've found here have broken links :/
sqlx
-
You Probably Don't Need Query Builders
Because type correctness does not imply branch correctness. SQL has side effects of interpretation, and any string/query builder that is not aware of grammatical implications should be avoided in my opinion.
Check the query builder of sqlx [1]
[1] https://github.com/launchbadge/sqlx/blob/main/sqlx-core/src/...
-
Serverless semantic search - AWS Lambda, AWS Bedrock, Neon
For DB schema and migrations, I use sqlx-cli.
-
First Impressions of AWS DSQL with Lambda and Rust
I tend to default to as few as possible, which is why when working with SQL and Rust, I almost always reach for SQLx. Setting up SQLx with AWS DSQL requires using the v4 Signature signing of my credentials as fetched from my AWS configuration. I do this work in my main function so that I can reuse the Postgres Pool in my handler without having to establish this connection outside of the Cold Start initializing cycle. That setup is reflected in the below code.
-
Sqlc: Compile SQL to type-safe code
This looks like a less ergonomic version of Rust's SQLx (https://github.com/launchbadge/sqlx) but a more robust version of TypeScript's sqlx-ts (https://jasonshin.github.io/sqlx-ts/). Sqlc seems to copy the latter's unfortunate lack of inline SQL statements. Still, seems promising.
-
Build your own SQLite with Rust, Part 1
SQLx seems to do some form of this. though what you're suggesting may remove the build time dependency on "connecting" to a SQLite database.
"SQLx supports compile-time checked queries. It does not, however, do this by providing a Rust API or DSL (domain-specific language) for building queries. Instead, it provides macros that take regular SQL as input and ensure that it is valid for your database. The way this works is that SQLx connects to your development DB at compile time to have the database itself verify (and return some info on) your SQL queries."
https://github.com/launchbadge/sqlx
- SQLx: Async, pure Rust SQL crate, compile-time checked queries without a DSL
-
A tale of TimescaleDB, SQLx and testing in Rust
For PostgreSQL, the most relevent part of the code is here. With this in mind I changed some things around to rely on schemas instead of databases and even simplified some parts of the implementation as this was always meant to be for internal use only..
-
Rust as a general application language
What exactly are you missing? I haven't really written "boring corporate backend stuff" in a few years but something like sqlx provides everything I've ever needed there.
-
Hey Rustaceans! Got a question? Ask here (49/2023)!
Badges are the little rectangles you typically see at the top of a crate's README: https://github.com/launchbadge/sqlx/blob/main/README.md
-
A new F# compiler feature: graph-based type-checking
SQLX has entered the chat [1].
[1] https://github.com/launchbadge/sqlx
What are some alternatives?
rust-bitfield - This crate provides macros to generate bitfield-like struct.
mysql-proxy-rs - A highly scalable MySQL Proxy framework written in Rust
rp-hal - A Rust Embedded-HAL for the rp series microcontrollers
rds_iamauth_proxy - Postgres proxy which allows tools that don't natively supports IAM auth to connect to AWS RDS instances.
exif-rs - Exif parsing library written in pure Rust
sea-orm - š An async & dynamic ORM for Rust
pmp-library - The Polygon Mesh Processing Library
diesel - A safe, extensible ORM and Query Builder for Rust
image - Encoding and decoding images in Rust
rbatis - Rust Compile Time ORM with Async Dynamic SQL
reqwest - An easy and powerful Rust HTTP Client
rust-postgres - Native PostgreSQL driver for the Rust programming language

