Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR. 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)
Because type correctness does not imply branch correctness. SQL has side effects of interpretation, and any string/query builder that is not aware of grammatical implications should be avoided in my opinion.
Check the query builder of sqlx [1]
[1] https://github.com/launchbadge/sqlx/blob/main/sqlx-core/src/...
-
Nutrient
Nutrient - The #1 PDF SDK Library. Bad PDFs = bad UX. Slow load times, broken annotations, clunky UX frustrates users. Nutrient’s PDF SDKs gives seamless document experiences, fast rendering, annotations, real-time collaboration, 100+ features. Used by 10K+ devs, serving ~half a billion users worldwide. Explore the SDK for free.
-
I think you are talking past each others. Preventing N+1 by doing lazy fetching and having synchronous / asynchronous API are orthogonal issues. Async API must not block the thread/event loop when the data loading is being done.
Diesel hasn't been providing an async API for reason told in this thread: https://github.com/diesel-rs/diesel/issues/399
The situation might change some day though, once async support in the core language and surrounding ecosystem gets stronger.
-
-
-
Project mention: Cr-SQLite – Multi-writer and CRDT support for SQLite | news.ycombinator.com | 2024-12-16
-
Project mention: ASCII Delimited Text – Not CSV or Tab Delimited Text | news.ycombinator.com | 2024-11-11
-
sql-studio
SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB, ClickHouse, Microsoft SQL Server]
Project mention: SQL-Studio: SQL Database Explorer [SQLite, LibSQL, PostgreSQL, MySQL/MariaDB, D | news.ycombinator.com | 2024-06-22 -
CodeRabbit
CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
-
sqlsync
SQLSync is a collaborative offline-first wrapper around SQLite. It is designed to synchronize web application state between users, devices, and the edge.
Have you taken a peek at sqlsync? It's a cool take where you write your entire application logic to operate as transactions and queries over a sqlite database but you do it in wasm so that the same transaction logic can run everywhere. The end result is nifty. That's at least my recollection of the thing.
https://sqlsync.dev/
-
-
Project mention: SQLPage: Automatically build a UI on top of SQL queries | news.ycombinator.com | 2024-10-22
-
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...
-
Project mention: I keep turning my Google Sheets into phone-friendly webapps, and I can't stop | news.ycombinator.com | 2024-12-30
The one I use is xlite
https://github.com/x2bool/xlite
It's read-only and mounts spreadsheets as virtual tables. Very fast.
Perhaps more relevant to this thread, libgsqlite loads Google Sheets as virtual tables:
https://github.com/0x6b/libgsqlite
(I haven't tested it though.)
-
https://community.fly.io/t/reliability-its-not-great/11253
https://github.com/superfly/corrosion
-
-
-
-
-
-
-
-
Project mention: SQLite-jiff: SQLite extension for timezones and complex durations | news.ycombinator.com | 2024-07-22
I think so - I wrote my own Rust FFI bindings for SQLite extensions, and I tried to make it as fast as possible, but a "hello world" extension was still 10-15% slower in Rust than C[0].
That being said, it depends what the extension does - a "hello world" extension mainly just calls the same SQLite C APIs over and over again, so the small Rust layer makes it a bit slower. However, my Rust extensions for regex[1] and CSV parsing[2] are usually faster than the C counterparts, mostly due to less memory allocations and batching. It's not a 1:1 comparison (both extensions have slightly different APIs and features), but I'd say a lot of "real world" features available in Rust can be faster than what's available in C.
That being said, I'm sure someone could write their own faster CSV or regex extension in C that is faster than the Rust ones. But it's a ton of work to do that from scratch, and I find wrapping a pre-existing Rust implementation to be much easier
[0] https://github.com/asg017/sqlite-loadable-rs?tab=readme-ov-f...
-
oasysdb
In-memory vector store with efficient read and write performance for semantic caching and retrieval system. Redis for Semantic Caching.
Project mention: What should I do when someone blatantly copy my open-source project on GitHub? | news.ycombinator.com | 2024-08-25This is OasysDB v0.4: https://github.com/oasysai/oasysdb/tree/v0.4.0
I honestly don't know what to do. I know that OasysDB is open-source and thus, free to modify and redistribute. But, I feel like this is more like a plagiarism and a bit unethical to do.
If anyone got similar experience, I'd like to hear some advice.
Thank you in advance.
-
Another related submission from today:
Ryde: A Rust Web Framework - https://github.com/swlkr/ryde (October 2024, 5 comments)
-
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).
Rust Sqlite discussion
Rust Sqlite related posts
-
Ask HN: Best Approach for MongoDB-Like Experience in Deno?
-
Show HN: Chamber – a light and concurrency-driven audio library built with Rust
-
I built a performant and concurrency-driven audio library in Rust
-
Cr-SQLite – Multi-writer and CRDT support for SQLite
-
Sensible SQLite Defaults
-
Show HN: Embed an SQLite database in your PostgreSQL table
-
Pglite-fusion: Embed an SQLite database in your PostgreSQL table
-
A note from our sponsor - CodeRabbit
coderabbit.ai | 15 Mar 2025
Index
What are some of the best open-source Sqlite projects in Rust? This list will help you:
| # | Project | Stars |
|---|---|---|
| 1 | sqlx | 14,258 |
| 2 | diesel | 13,183 |
| 3 | sea-orm | 7,887 |
| 4 | rusqlite | 3,457 |
| 5 | cr-sqlite | 3,167 |
| 6 | qsv | 2,656 |
| 7 | sql-studio | 2,577 |
| 8 | sqlsync | 2,487 |
| 9 | rbatis | 2,296 |
| 10 | SQLPage | 1,971 |
| 11 | sea-query | 1,310 |
| 12 | xlite | 1,257 |
| 13 | corrosion | 843 |
| 14 | apalis | 617 |
| 15 | prsqlite | 604 |
| 16 | KiteSQL | 596 |
| 17 | chiselstore | 575 |
| 18 | seaography | 428 |
| 19 | wastebin | 416 |
| 20 | njord | 416 |
| 21 | sqlite-loadable-rs | 378 |
| 22 | oasysdb | 357 |
| 23 | ryde | 321 |
Sponsored
Nutrient - The #1 PDF SDK Library
Bad PDFs = bad UX. Slow load times, broken annotations, clunky UX frustrates users. Nutrient’s PDF SDKs gives seamless document experiences, fast rendering, annotations, real-time collaboration, 100+ features. Used by 10K+ devs, serving ~half a billion users worldwide. Explore the SDK for free.
nutrient.io