SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Rust Sqlite Projects
-
-
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)
-
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.
-
-
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
sqlsync
SQLSync is a collaborative offline-first wrapper around SQLite. It is designed to synchronize web application state between users, devices, and the edge.
-
-
SQLpage
SQL-only webapp builder, empowering data analysts to build websites and applications quickly
-
-
-
-
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Project mention: Top 10 Rusty Repositories for you to start your Open Source Journey | dev.to | 2023-12-197. Diesel
For PostgreSQL, the most relevent part of the code is here. With this in mind I changed some things around to rely on schemas instead of databases and even simplified some parts of the implementation as this was always meant to be for internal use only..
SQL with SeaORM:
"Rusqlite is an ergonomic wrapper for using SQLite from Rust." - Crates.io
Project mention: Show HN: RemoteStorage – sync localStorage across devices and browsers | news.ycombinator.com | 2024-01-12I'm a happy user of https://github.com/vlcn-io/cr-sqlite/
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
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/
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)
Project mention: Local-first software: You own your data, in spite of the cloud (2019) | news.ycombinator.com | 2023-10-02Couchdb/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.
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.
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!
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 Sqlite related posts
-
Embeddings are a good starting point for the AI curious app developer
-
Show HN: TextQuery – Query and Visualize Your CSV Data in Minutes
-
SQLite + Rust: Building a CLI Password Vault 🦀
-
Offline eventually consistent synchronization using CRDTS
-
A self-hosted back end for Deno KV
-
Standalone, open source, self-hostable Deno KV binary
-
Automerge-Repo: A "batteries-included" toolkit for local-first applications
-
A note from our sponsor - SaaSHub
www.saashub.com | 22 May 2024
Index
What are some of the best open-source Sqlite projects in Rust? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | diesel | 12,020 |
| 2 | sqlx | 12,025 |
| 3 | sea-orm | 6,392 |
| 4 | rusqlite | 2,780 |
| 5 | cr-sqlite | 2,455 |
| 6 | qsv | 2,249 |
| 7 | rbatis | 2,150 |
| 8 | sqlsync | 1,740 |
| 9 | xlite | 1,230 |
| 10 | sea-query | 1,026 |
| 11 | SQLpage | 811 |
| 12 | corrosion | 596 |
| 13 | chiselstore | 563 |
| 14 | apalis | 385 |
| 15 | seaography | 344 |
| 16 | sqlite-loadable-rs | 318 |
| 17 | njord | 257 |
| 18 | rustorm | 248 |
| 19 | SQLite | 220 |
| 20 | ormlite | 212 |
| 21 | wastebin | 213 |
| 22 | turbosql | 189 |
| 23 | sea-schema | 173 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com