# joaoh82/rust_sqlite

SQLRite - Simple embedded database modeled off SQLite in Rust

Repository: https://github.com/joaoh82/rust_sqlite
Canonical: https://ross.abutalabs.com/products/rust_sqlite
Homepage: https://www.sqlritedb.com/
Language: Rust
License: MIT
License Family: permissive
Topics: sqlite-architecture, rust-lang, database-design, databases, computer-science
Last push: 2026-08-09T16:06:12+00:00

## Health v2 (maintenance only)
Score: 90/100 (v2, computed 2026-09-03T02:39:23.370411+00:00)
- activity 96, release rhythm 76, longevity 100
- inputs: {"age_days": 2056, "days_push": 24, "days_rel": 83, "gap_med": 0, "n_releases_24m": 346}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1091, forks 56 (observed 2026-08-28T04:03:33.037410+00:00)

## What it is
SQLRite is an embedded SQL database engine written from scratch in Rust, modeled on SQLite with a paged single-file format, B-tree storage, write-ahead log, and ACID transactions. It extends the SQLite model with HNSW vector search, BM25 full-text search, an MCP server, and SDKs for Rust, Python, Node, Go, C, and WASM.

## Use cases
- embed a lightweight SQL database in a Rust application
- learn how database internals like B-trees and WALs work
- run vector similarity search alongside SQL queries
- full-text search with BM25 in an embedded database
- expose a local database to an LLM via MCP
- try a SQL engine in the browser with WebAssembly
- single-file embedded database with transactions and JOINs

## When to choose
- you want an embedded, single-file SQL database with vector and full-text search built in
- you are studying or teaching database engine internals in Rust
- you need an MCP server that gives AI agents local SQL access
- you want multi-language bindings (Python, Node, Go, C, WASM) around one engine

## When to avoid
- you need a battle-tested production database with decades of hardening - use SQLite or PostgreSQL
- you require the full SQL standard, complex aggregates over JOINs, or advanced features SQLRite has not implemented
- you need a client-server networked database rather than an embedded one

## Facets
- artifact type: library
- maturity: active
- function: database, search-engine, vector-database, cli, mcp, parser
- domain: databases, developer-tools, education
- platform: rust, cross-platform, cli, wasm, python, go
- tags: embedded-database, sqlite-alternative, b-tree, write-ahead-log, acid-transactions, hnsw-vector-search, bm25-full-text-search, single-file-database, database-internals, repl, educational, search, command-line, nodejs, desktop

## Member repositories
- joaoh82/rust_sqlite (main) score 90

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:03:33.037410+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T06:49:08.925205+00:00, confidence not recorded.
  - readme: https://github.com/joaoh82/rust_sqlite (fetched 2026-08-28T04:03:33.037410+00:00, sha 8dad938bb40c)
  - homepage: https://www.sqlritedb.com/ (fetched 2026-08-29T12:51:22.055713+00:00, sha 4747ab2fb08c)
  - site_page: https://www.sqlritedb.com/docs (fetched 2026-08-29T12:51:22.066624+00:00, sha f13c712cb018)
  - site_page: https://sqlritedb.com/docs (fetched 2026-08-29T12:51:22.070594+00:00, sha f784490a4854)
  - site_page: https://www.sqlritedb.com/playground (fetched 2026-08-29T12:51:22.068869+00:00, sha 76c5e38ed5f1)
- Data as of 2026-08-30T08:39:29.467469+00:00.