Skip to content

Releases: zavora-ai/SQLRite

SQLRite v1.0.0

07 Mar 06:41
@jkmaina jkmaina
v1.0.0
d2a27db

Choose a tag to compare

View all tags
SQLRite v1.0.0 Latest
Latest

SQLRite v1.0.0 Release Notes

Date: March 7, 2026

Summary

SQLRite v1.0.0 is the first production release of the project. It delivers a single Rust-native CLI and embeddable runtime for SQL-first retrieval, migration paths from SQL and API-first vector systems, secure multi-tenant server defaults, and reproducible benchmark/reliability evidence for AI-agent RAG workloads.

Highlights

  1. SQL-native retrieval:
  • vector operators: <->, <=>, <#>
  • retrieval functions: vector(...), embed(...), bm25_score(...), hybrid_score(...)
  • concise hybrid query syntax with SEARCH(...)
  • deterministic EXPLAIN RETRIEVAL
  1. Product surfaces:
  • unified sqlrite CLI
  • embedded database mode
  • HTTP /v1/query and /v1/sql
  • gRPC query service
  • MCP tool server mode
  • Rust, Python, and TypeScript SDKs
  1. Production operations:
  • backup, snapshot, restore, and PITR workflows
  • HA replication/failover control-plane scaffolding and reference manifests
  • observability, readiness, health, metrics, and trace endpoints
  • reproducible benchmark suite and GA evidence bundle
  1. Security and governance:
  • frozen v1 API compatibility manifest and CI checks
  • RBAC policy enforcement and secure defaults
  • audit export and key-rotation tooling
  • release policy, GA checklist, and machine-readable sign-off
  1. Migration support:
  • SQLite and libSQL imports
  • pgvector-style JSONL imports
  • API-first imports for Qdrant, Weaviate, and Milvus export patterns

Benchmarks And Reliability

Published GA release-train results:

  • quick profile weighted/brute_force: qps=166.73, p95_ms=6.2084
  • 10k profile weighted/brute_force: qps=87.52, p95_ms=12.3622
  • retrieval quality at k=5:
    • brute_force: recall=1.0000, mrr=1.0000, ndcg=0.9732
    • lsh_ann: recall=1.0000, mrr=1.0000, ndcg=0.9732
    • hnsw_baseline: recall=1.0000, mrr=1.0000, ndcg=0.9732
  • monthly availability evidence: 100.00%
  • observed RPO: 0.0050s

Canonical publication artifacts:

  • /Users/jameskaranja/Developer/projects/SQLRight/project_plan/reports/s33_benchmark_reliability_report.md
  • /Users/jameskaranja/Developer/projects/SQLRight/project_plan/reports/s33_benchmark_repro_manifest.json
  • /Users/jameskaranja/Developer/projects/SQLRight/project_plan/reports/s33_final_signoff.json

Upgrade Notes

  1. Release metadata now reports 1.0.0 across CLI, Rust crate, Python SDK, and TypeScript SDK surfaces.
  2. Packaging/install examples are normalized to 1.0.0.
  3. v1 API compatibility is treated as frozen; future breaking changes require a new major version.

Release Artifacts

  • /Users/jameskaranja/Developer/projects/SQLRight/dist/sqlrite-v1.0.0-aarch64-apple-darwin.tar.gz
  • /Users/jameskaranja/Developer/projects/SQLRight/dist/sqlrite-v1.0.0-aarch64-apple-darwin.sha256
  • /Users/jameskaranja/Developer/projects/SQLRight/project_plan/reports/sqlrite-v1.0.0-ga-evidence.tar.gz
Assets 5
Loading