27 releases

0.2.0-alpha.13 Jun 16, 2020
0.2.0-alpha.12 May 20, 2020
0.2.0-alpha.11 Mar 26, 2020
0.2.0-alpha.9 Feb 28, 2020
0.1.4 Dec 30, 2019

#483 in Asynchronous

Download history 76/week @ 2023-10-29 28/week @ 2023-11-05 39/week @ 2023-11-12 50/week @ 2023-11-19 104/week @ 2023-11-26 175/week @ 2023-12-03 116/week @ 2023-12-10 99/week @ 2023-12-17 112/week @ 2023-12-24 35/week @ 2023-12-31 13/week @ 2024-01-07 63/week @ 2024-01-14 52/week @ 2024-01-21 83/week @ 2024-01-28 68/week @ 2024-02-04 202/week @ 2024-02-11

407 downloads per month


12K SLoC


crates.io docs.rs Build status Discord

Quaint is an abstraction over certain SQL databases. It provides:

  • An AST for building dynamic SQL queries.
  • Visitors for different databases to generate SQL strings.
  • Connectors to abstract over results and querying.
  • Pooling with mobc
  • Async/await and Futures 0.3


Feature flags

  • full: All connectors and a pooled Quaint manager
  • full-postgresql: Pooled support for PostgreSQL
  • full-mysql: Pooled support for MySQL
  • full-sqlite: Pooled support for SQLite
  • full-mssql: Pooled support for Microsoft SQL Server
  • single: All connectors, but no pooling
  • single-postgresql: Single connection support for PostgreSQL
  • single-mysql: Single connection support for MySQL
  • single-sqlite: Single connection support for SQLite
  • single-mssql: Single connection support for Microsoft SQL Server


  • Query generation when the database and conditions are not known beforehand.
  • Parameterized queries and SQL injection protection.
  • A modular design, a separate AST and separate visitors and connectors.


  • Database-level type-safety in query building or being an ORM.

For type-safe database abstraction, Diesel is an excellent choice.


  • See .envrc for connection params. Override variables if different. MySQL, PostgreSQL and SQL Server needs to be running for tests to succeed.


> cargo test

Query debug

The queries can be logged by setting the LOG_QUERIES environment variable to any value. They'll be logged at the INFO level and are visible when having a logger in scope. If using Tracing, compiling Quaint with the tracing-log feature flag will parameterize the logged queries into a more suitable format for Tracing.


~389K SLoC