Rust rusqlite

Open-source Rust projects categorized as rusqlite
Edit details
Sqlite Rust Database ORM MySQL
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured

Top 6 Rust rusqlite Projects

rusqlite

  1. sea-query

    🔱 A dynamic SQL query builder for MySQL, Postgres and SQLite

    Project mention: Rust-Query | news.ycombinator.com | 2024-11-30

    That's my go-to! Maybe it was not super clear from my comment but I'm not using sea-query-orm but just the query builder, once the query is build you still have to feed it to sqlx (e.g [0]) :)

    [0]: https://github.com/SeaQL/sea-query/blob/master/examples/sqlx...

  2. InfluxDB

    InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

    InfluxDB logo

  3. rpcn

    Matchmaking server for RPCS3

  4. tokio-rusqlite

    Asynchronous handle for rusqlite library.

    Project mention: Show HN: SQLite Transaction Benchmarking Tool | news.ycombinator.com | 2024-07-17

    Thanks.

    All good and valid questions.

    1. I work mostly in Rust so I'll answer there in terms of async. This library [0] uses queues to manage workload. I run a modified version [1] which creates 1 writer and n reader connections to a WAL backed SQLite and dispatch async transactions against them. The n readers will pull work from a shared common queue.

    2. Yes there is not much you can do about file IO but SQLite is still a full database engine with caching. You could use this benchmarking tool to help understand where your limits would be (you can do a run against a ramdisk then against your real storage).

    3. As per #1, I keep connections open and distribute transactions across them myself. Checkpointing will only be a problem under considerable sustained write load but you should be able to simulate your load and observe the behavior. The WAL2 branch of SQLite is intended to prevent sustained load problems.

    [0]: https://github.com/programatik29/tokio-rusqlite

  5. Rex

    TUI program for keeping track of incomes and expenses, created with Rust (by TheRustyPickle)

  6. rusqlite-model

    Model trait and derive implementation for rusqlite

  7. sqlite-readers-writers

    An SQLite benchmark for concurrent readers and writers

    Project mention: How bloom filters made SQLite 10x faster | news.ycombinator.com | 2024-12-22

    This is a baseline benchmark I published of various p9x latencies for multiple readers/writers with a single SQLite database with different configurations set: https://github.com/mqudsi/sqlite-readers-writers

    Even if you don’t use message passing to use one thread to perform all updates/writes, it still performs very solidly for many use cases.

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

Rust rusqlite discussion

Log in or Post with

Index

What are some of the best open-source rusqlite projects in Rust? This list will help you:

# Project Stars
1 sea-query 1,387
2 rpcn 215
3 tokio-rusqlite 101
4 Rex 43
5 rusqlite-model 12
6 sqlite-readers-writers 8

Sponsored
InfluxDB – Built for High-Performance Time Series Workloads
InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
www.influxdata.com
Loading...