joaoh82 / rust_sqlite / 25965715081
69%

DEFAULT BRANCH: main
Ran
Jobs 1
Files 61
Run time 1min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst
coverage: 68.778% (-0.08%) from 68.857%
25965715081

push

github

web-flow 
feat(examples): SQLR-39 Python LLM agent with persistent memory in SQLRite (#140)

The first SQLR-38 example app. A Python CLI chat agent whose long-term memory
is one .sqlrite file. Each turn embeds the user input, runs hybrid recall
(vector KNN via HNSW + BM25 via Phase 8 fts_match), assembles a system prompt
from the recalled facts/summaries/messages, calls the LLM, and writes the
new turn back. Persists across process restarts because the entire memory
layer is a regular SQLRite database — the demo's whole point.

Package: examples/python-agent/ (Python 3.11+, pinned to sqlrite>=0.10,<0.11).
Binds only to the SDK's documented surface (sqlrite.connect, Connection,
Cursor); no internals.

Layers:
- db.py:           schema + migrations + SQL (3 tables, HNSW + FTS indexes)
- sqlutil.py:      safe SQL-literal inlining (the SDK doesn't bind params yet)
- embeddings.py:   hash / OpenAI / sentence-transformers
- facts.py:        regex-based (subject, predicate, object) extraction
- memory.py:       hybrid recall (vector + lexical + facts) with merge
- chat.py:         Anthropic / Echo (offline fallback so zero-key first run works)
- agent.py:        turn loop, prompt assembly, manual summarize_window()
- cli.py:          interactive REPL + /facts /recall /summarize slash commands

31 offline tests; runs end-to-end without an API key.

Adds /examples landing page to sqlritedb.com (nav link + sitemap entry).

Co-authored-by: Claude Opus 4.7 (1M context) <noreply@anthropic.com>

11151 of 16213 relevant lines covered (68.78%)

1.23 hits per line

Coverage Regressions

Lines Coverage ∆ File
23
9.35
 -0.37% src/error.rs
Jobs
ID Job ID Ran Files Coverage
1 25965715081.1 61
68.78
 GitHub Action Run
Source Files on build 25965715081