sqlrite 1.0.2

RAG-oriented SQLite wrapper for AI agent workloads
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57

# Ingestion and Reindexing

SQLRite supports direct CLI ingest, embedded ingest APIs, checkpointed ingestion workers, and reindexing for embedding-model changes.

## Direct CLI ingest

```bash
sqlrite ingest \
  --db sqlrite_docs.db \
  --id chunk-1 \
  --doc-id doc-1 \
  --content "Local agent memory should be fast and predictable." \
  --embedding 0.95,0.05,0.0 \
  --metadata '{"tenant":"demo","topic":"memory"}'
```

Use this for small tests, samples, and direct fixtures.

## Checkpointed ingestion worker

Example: `/Users/jameskaranja/Developer/projects/SQLRight/examples/ingestion_worker.rs`

Run it:

```bash
cargo run --example ingestion_worker
```

What it demonstrates:

- chunking strategies
- restart-safe checkpoints
- embedding provider integration
- follow-up retrieval after ingest

## Reindexing

Use reindexing when your embedding model changes or you want a different vector storage profile.

```bash
sqlrite-reindex \
  --db sqlrite_demo.db \
  --provider deterministic \
  --model det-v1 \
  --dims 64
```

External providers exist too, but they require real credentials or a reachable embedding service.

## When to use which ingest path

| Need | Best path |
|---|---|
| one chunk or a quick fixture | `sqlrite ingest` |
| embedded Rust app | `db.ingest_chunks(...)` |
| restart-safe batch ingest | `IngestionWorker` |
| refresh embeddings | `sqlrite-reindex` |