Rust Sqlite

Open-source Rust projects categorized as Sqlite
Edit details
Topics: Rust Database SQL MySQL Postgresql
Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
Sponsored

Top 23 Rust Sqlite Projects

  • diesel

    A safe, extensible ORM and Query Builder for Rust

    • Project mention: Top 10 Rusty Repositories for you to start your Open Source Journey | dev.to | 2023-12-19

    7. Diesel

  • sqlx

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

    • Project mention: Rust as a general application language | /r/rust | 2023-12-09

    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.

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

    WorkOS logo

  • sea-orm

    🐚 An async & dynamic ORM for Rust

    • Project mention: Rust GraphQL APIs for NodeJS Developers: Introduction | dev.to | 2024-02-08

    SQL with SeaORM:

  • rusqlite

    Ergonomic bindings to SQLite for Rust

    • Project mention: SQLite + Rust: Building a CLI Password Vault 🦀 | dev.to | 2024-03-15

    "Rusqlite is an ergonomic wrapper for using SQLite from Rust." - Crates.io

  • cr-sqlite

    Convergent, Replicated SQLite. Multi-writer and CRDT support for SQLite

    • Project mention: Show HN: RemoteStorage – sync localStorage across devices and browsers | news.ycombinator.com | 2024-01-12

    I'm a happy user of https://github.com/vlcn-io/cr-sqlite/

  • qsv

    CSVs sliced, diced & analyzed.

    • Project mention: Qsv: Efficient CSV CLI Toolkit | news.ycombinator.com | 2023-12-22

    Thanks for the detailed feedback @snidane!

    As maintainer of qsv, here's my reply:

    - Given qsv's rapid release cycle (173 releases over three years), the auto-update check is essential at the moment. Once we reach 1.0, I'll turn it off. For now, given your feedback, I've only made it check 10% of the time.

    - Pivot is in the backlog and I'll be sure to add unpivot when I implement it. (https://github.com/jqnatividad/qsv/issues/799)

    - I'll add a dedicated summing command with the group by (-by) and window by (-over) capability (https://github.com/jqnatividad/qsv/issues/1514). Do note that `stats` has basic sum as @ezequiel-garzon pointed out.

    - With the `enum` command, qsv can achieve what you proposed with `laminate`. E.g. qsv enum --new-column newcol --constant newconstant mydata.csv --output laminated-data.csv

    - With the cat rowskey command, qsv can already concatenate files with mismatched headers.

    - other file formats. qsv supports parquet, csv, tsv, excel, ods, datapackage, sqlite and more (see https://github.com/jqnatividad/qsv/tree/master#file-formats). Fixed-format though is not supported yet and quite interesting, and have added it to the backlog (https://github.com/jqnatividad/qsv/issues/1515)

    - as to "enable embedding outputs of commands", qsv is composable by design, so you can use standard stdin/stdout redirection/piping techniques to have it work with other CLI tools like jq, awk, etc.

    Finally, just released v0.120.0 that already incorporates the less aggressive self-update check. https://github.com/jqnatividad/qsv/releases/tag/0.120.0

  • rbatis

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

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo

  • sqlsync

    SQLSync is a collaborative offline-first wrapper around SQLite. It is designed to synchronize web application state between users, devices, and the edge.

    • Project mention: A future for SQL on the web (2021) | news.ycombinator.com | 2023-12-31

    If you're looking for a very real use case of SQLite in the browser, there's SQLSync[1]. It was recently discussed on HN[2].

    [1]: https://sqlsync.dev/posts/stop-building-databases/, https://sqlsync.dev/

  • xlite

    Query Excel spredsheets (.xlsx, .xls, .ods) using SQLite

    • Project mention: Show HN: Query Your Sheets with SheetSQL | news.ycombinator.com | 2024-03-13

    There is similar open-source project for Google Sheets: https://github.com/0x6b/libgsqlite (SQLite extension), which is a fork of https://github.com/x2bool/xlite (same idea but for Microsoft Excel spreadsheets)

  • sea-query

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

  • SQLpage

    SQL-only webapp builder, empowering data analysts to build websites and applications quickly

    • Project mention: SQLite Schema Diagram Generator | news.ycombinator.com | 2024-03-23

  • corrosion

    Gossip-based service discovery (and more) for large distributed systems. (by superfly)

    • Project mention: Local-first software: You own your data, in spite of the cloud (2019) | news.ycombinator.com | 2023-10-02

    Couchdb/pouchdb remains one of the best: it's super easy to setup and is production-ready, but it's gonna be json docs with no transactions, so it can be limiting.

    Y.js and automerge emerged as solutions combining CRDTs and content transfer, they look really promising. There is a Y.rs version if that's better for you.

    I've always dreamt of building something on top of Syncthing, ie something that would use file synchronization. It's more versatile and will definitely last longer than anything else, and it has some built-in capabilities for having a third party helping transport but not being allowed to read content.

    I recently came across https://github.com/superfly/corrosion , a service discovery and state management tool that is working completely p2p. CR-SQLite, in particular, allows multiple tables from multiple databases to be merged thanks to CRDTs. I'm sure there's a lot to build on top of it.

    I feel like you're not really interested in full p2p but want some centralization point to manage some auth stuff, so I'd investigate couchdb/pouchdb first.

  • chiselstore

    SQLite + Little Raft = 🚀

  • apalis

    Simple, extensible multithreaded background job and message processing library for Rust

    • Project mention: Periodic tasks | /r/rust | 2023-12-04

    This is a full blown framework, but if anyone else stumbles across this question, https://crates.io/crates/apalis has been really useful for me.

  • seaography

    🧭 GraphQL framework for SeaORM

  • sqlite-loadable-rs

    A framework for writing fast and performant SQLite extensions in Rust

  • rustorm

    an orm for rust

  • SQLite

    Interface to SQLite (by stainless-steel)

  • ormlite

    An ORM in Rust for developers that love SQL.

  • njord

    A lightweight ORM library for Rust ⛵ (by njord-rs)

    • Project mention: A lightweight ORM library for Rust | news.ycombinator.com | 2024-04-16

  • wastebin

    wastebin is a pastebin

    • Project mention: MicroBin v2 released | /r/selfhosted | 2023-07-11

    Looks nice. I was using wastebin but will probably switch to this. I like the interface better and it also supports images/attachments, and also written in Rust!

  • turbosql

    An easy local data persistence layer for Rust, backed by SQLite.

  • sea-schema

    🌿 SQL schema definition and discovery

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
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). The latest post mention was on 2024-04-16.

Rust Sqlite related posts

Index

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

Project Stars
1 diesel 11,904
2 sqlx 11,678
3 sea-orm 6,204
4 rusqlite 2,731
5 cr-sqlite 2,407
6 qsv 2,214
7 rbatis 2,121
8 sqlsync 1,707
9 xlite 1,230
10 sea-query 997
11 SQLpage 770
12 corrosion 584
13 chiselstore 563
14 apalis 346
15 seaography 333
16 sqlite-loadable-rs 312
17 rustorm 248
18 SQLite 214
19 ormlite 210
20 njord 209
21 wastebin 195
22 turbosql 186
23 sea-schema 166

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com