Rust Sqlite

Open-source Rust projects categorized as Sqlite

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.

  • 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.

  • 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

  • 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.

  • 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: SQLPage – Building a full web application with nothing but SQL queries [video] | news.ycombinator.com | 2024-03-11

    Saving further clicks:

    > SQLPage is a tool that allows you to build websites using nothing more than SQL queries. You write simple text files containing SQL queries, SQLPage runs them on your database, and renders the results as a website.

    The 22-line "TinyTweeter" example at 28:45 [0] in the video is a good overview - perhaps better than anything currently on the homepage/docs: https://github.com/lovasoa/SQLpage/blob/main/examples/tiny_t...

    Also, based on a couple of discussions [1][2] it seems like SQLPage has the potential to combine well with HTMX too. The two projects definitely share a similar philosophy.

    [0] https://youtu.be/mXdgmSdaXkg?t=1721

    [1] https://github.com/lovasoa/SQLpage/issues/84#issuecomment-19...

    [2] https://github.com/lovasoa/SQLpage/pull/175#issuecomment-187...

  • 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

    Project mention: SQLiteGPT - Directly query ChatGPT with SQL functions | /r/sqlite | 2023-04-13

    The implementation is just a prototype right now and it should be implemented as a proper loadable extension in Rust with sqlite-loadable-rs. Make sure to star the GitHub repo if you want to see this happen! ;-)

  • rustorm

    an orm for rust

  • SQLite

    Interface to SQLite (by stainless-steel)

  • ormlite

    An ORM in Rust for developers that love SQL.

  • turbosql

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

  • 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!

  • sea-schema

    🌿 SQL schema definition and discovery

  • sqlite-regex

    A fast regular expression SQLite extension, written in Rust

  • SaaSHub

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

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-03-15.

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,718
2 sqlx 11,424
3 sea-orm 6,045
4 rusqlite 2,676
5 cr-sqlite 2,321
6 qsv 2,163
7 rbatis 2,102
8 sqlsync 1,661
9 xlite 1,230
10 sea-query 974
11 SQLpage 722
12 corrosion 571
13 chiselstore 563
14 apalis 325
15 seaography 323
16 sqlite-loadable-rs 302
17 rustorm 248
18 SQLite 208
19 ormlite 203
20 turbosql 184
21 wastebin 177
22 sea-schema 162
23 sqlite-regex 149
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com