sqlx VS rust-postgres

Compare sqlx vs rust-postgres and see what are their differences.


🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, SQLite, and MSSQL. (by launchbadge)


Native PostgreSQL driver for the Rust programming language (by sfackler)
Our great sponsors
  • SonarLint - Clean code begins in your IDE with SonarLint
  • Revelo Payroll - Free Global Payroll designed for tech teams
  • InfluxDB - Collect and Analyze Billions of Data Points in Real Time
  • Onboard AI - Learn any GitHub repo in 59 seconds
sqlx rust-postgres
140 14
9,968 3,054
2.4% -
0.0 8.1
2 days ago 6 days ago
Rust Rust
Apache License 2.0 Apache License 2.0
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.


Posts with mentions or reviews of sqlx. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-07-04.
  • Introducing SQLPage : write websites entirely in SQL
    8 projects | /r/rust | 4 Jul 2023
    I'm considering making my own wrapper over lower-level database drivers. There are a lot of features in sqlx that I don't need, and the latest version seems to have removed useful data structures that SQLPage is using. It also removed support for SQL Server.
    8 projects | /r/rust | 4 Jul 2023
    sqlx to interface with multiple databases (I am considering moving to something else to support more databases, though)
  • SQLx 0.7 released! Offline mode usability improvements, performance fixes and major upgrades across the board!
    6 projects | /r/rust | 3 Jul 2023
    The biggest thing to note in this release is the restructuring of the project and the removal of the MSSQL driver as it was not at the same maturity and usability level as the other drivers. As previously announced (https://github.com/launchbadge/sqlx/discussions/1616), we have plans to introduce a fully featured replacement as a premium offering, alongside drivers for other proprietary databases, with the goal to support full-time development on SQLx.
    6 projects | /r/rust | 3 Jul 2023
  • Is ORM still an anti-pattern?
    15 projects | news.ycombinator.com | 27 Jun 2023
  • PHP to Golang
    9 projects | /r/golang | 3 Jun 2023
  • New Rustacean Looking For Guidance
    6 projects | /r/rust | 11 May 2023
  • Why ORMs are so hated?
    4 projects | /r/golang | 11 May 2023
    Thanks for sharing your experiences. I've been looking to get into snowflake for some time (even opened this https://github.com/launchbadge/sqlx/issues/986) . We thought to move to it years ago, but there's no way it was going to replace a significant amount of the mariadb we're running, and unless it did I wasn't looking forward to managing 2 DBs.
  • Prá galera curiosa sobre Rust, alguns "contras" a considerar.
    4 projects | /r/brdev | 10 May 2023
  • What ORM do you use?
    6 projects | /r/rust | 9 May 2023
    however, a much worse problem is its inability to do dynamic queries. If you have two queries that only differ in a column name, you're forced to copy paste the entire query. You can try and hack around it, but it's ugly either way. Here's a good overview, with no really good solutions.


Posts with mentions or reviews of rust-postgres. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-03-18.
  • PostgreSQL Logical Replication Explained
    4 projects | news.ycombinator.com | 18 Mar 2023
    For C there should be good options.

    For Rust it doesn't appear that well-supported.

    A very simple approach is to poll for changes using `pg_logical_slot_get_changes()` - that should work with any driver. That's what I used for my initial experimentation, before switching over to the streaming replication protocol for better performance.

    The streaming replication protocol is not that complicated, but currently you'll have to handle some of the low-level protocol yourself, or work with some very experimental implementations. There's a project to help get you started at [1], and some more discussion at [2].

    For the logical decoder, wal2json is quite nice to experiment with, but I've found pgoutput is not that complicated and gives you something closer to the raw data.

    [1]: https://github.com/seddonm1/logicaldecoding/

    [2]: https://github.com/sfackler/rust-postgres/issues/116

  • Push-Based Outbox Pattern with Postgres Logical Replication
    6 projects | news.ycombinator.com | 28 Oct 2022
  • Cómo usar gRPC con Rust Tonic y Postgres con ejemplos
    2 projects | dev.to | 11 Jun 2022
    En este post aprendermos a usar Rust, Tonic y la crate gRPC, y implementaremos un CRUD con Postgresql database.
  • Reviews of the Diesel ORM, are there better alternatives?
    11 projects | /r/rust | 15 May 2022
    I can understand that this can be frustrating and I know that the situation there is not ideal for diesel. There are certainly things to improve there by either providing a bundling support which builds the native library as part of the normal build process or by implementing a pure rust connection implementation. Both is possible with diesel, but requires some work. At least the pure rust connection implementation is something that can be provided by a third party crate now with upcoming diesel 2.0 release. If you are interested in that checkout this and this issue. As for the bundling support: This requires changes in the mysqlclient-sys and pq-sys crates. Again help there is welcome. In the end it makes me sad that some people have repeating decided that a solution to this problem is to write just another crate instead of helping to fix these issues. This just results in everyone have more work to do, as there are now two non-perfect solutions instead of having one slightly improved solution.
  • GitHub - tzConnectBerlin/rust-pg_bigdecimal: A Rust native datatype for Postgres' Numeric type, to be used with Rust's "Postgres" library.
    2 projects | /r/rust | 14 Jan 2022
    We created this little library to have a fully native type for Postgres Numerics with the rust-postgres (https://github.com/sfackler/rust-postgres) library.
  • pigeon-rs: Open source email automation written in Rust
    5 projects | /r/rust | 20 Nov 2021
    The problem with a crate like postgres is that you have to define the types of the query at compile-time. And if you use the simple query protocol in postgres, you just get a bunch of strings, i.e. no proper typing at all. However, for maximal flexibility arbitrary queries should work in pigeon, without knowing the database schema.
  • Announcing Usual -- a small nORM wrapper to make dealing with SQL easier (like tokio-postgres)
    2 projects | /r/rust | 25 Aug 2021
    Some nifty things about usual: - It's a generic wrapper over any SQL "row" object. The first implementation that's provided is for tokio-postgres, but traits are available to implement over whatever you'd like. - It provides static typing for partial queries. That is, it supports fetching a subset of fields from a row and makes a unique type for the return value. This gives you some neat-o type safety like this:
  • How to use gRPC with Rust Tonic and Postgres database with examples
    3 projects | dev.to | 13 May 2021
    In this post, we will learn how to use Rust Tonic gRPC crate. We will learn how to implement CRUD with Postgresql database.
  • Hey Rustaceans! Got an easy question? Ask here (12/2021)!
    15 projects | /r/rust | 22 Mar 2021
    (see: https://github.com/sfackler/rust-postgres/blob/e15c9b1415f69821799f1370246581c1600a6196/postgres-protocol/src/types/mod.rs#L137)
  • Scylla Developer Hackathon: Rust Driver
    2 projects | /r/rust | 18 Feb 2021
    Driver is a typical database driver which allows your code to communicated with the database. ex: https://github.com/sfackler/rust-postgres

What are some alternatives?

When comparing sqlx and rust-postgres you can also consider the following projects:

diesel - A safe, extensible ORM and Query Builder for Rust

sea-orm - 🐚 An async & dynamic ORM for Rust

tokio - A runtime for writing reliable asynchronous applications with Rust. Provides I/O, networking, scheduling, timers, ...

MeiliSearch - A lightning-fast search engine that fits effortlessly into your apps, websites, and workflow.

rbatis - Rust Compile Time ORM robustness,async, pure Rust Dynamic SQL

tikv - Distributed transactional key-value database, originally created to complement TiDB

r2d2 - A generic connection pool for Rust

actix-web - Actix Web is a powerful, pragmatic, and extremely fast web framework for Rust.

sled - the champagne of beta embedded databases

axum-rest-starter-example - Quick demo of a REST frontend with a Redis session store.

Rocket - A web framework for Rust.