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. Learn more →
Top 23 Rust Sqlite Projects
-
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)
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.
-
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-12
I'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
-
-
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.
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)
-
-
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-11Saving 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...
-
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.
-
-
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.
-
-
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! ;-)
-
-
-
-
-
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!
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Rust Sqlite related posts
- 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
- P2panda: P2P protocol for secure, energy-efficient local-first web applications
- Ayb: A multi-tenant database that helps you own your data
-
A note from our sponsor - InfluxDB
www.influxdata.com | 19 Mar 2024
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 |