codedb

codedb

Local code search engine integrated into ox. Indexes git repositories into SQLite + Bleve and supports queries.

Packages

• codedb — Facade (Open, Search, RawSQL, IndexRepo)
• index — Git clone/fetch via go-git, commit walking, blob dedup, Bleve indexing
• search — Query parser, execution planner (SQL/Bleve/Intersect), SQL translator
• store — SQLite + Bleve storage layer (schema, migrations, convenience methods)
• symbols — Symbol/ref types and parser interface (stub — no CGO tree-sitter)
• comments — Comment extraction via character-level scanner (pure Go, no CGO)
• language — File extension → language detection

Query syntax

spawn                          # bare text search
lang:rust file:*.rs fn         # filters
type:symbol Runtime            # symbol search
type:comment retry             # comment search
type:comment ckind:doc lang:go # doc comments in Go
type:commit author:alice       # commit search
type:diff streaming            # diff search
calls:groupby                  # call graph
/err\d+/                       # regex
foo OR bar                     # disjunction

CLI

ox code index <url>          # clone + index a repo
ox code search <query>       # search indexed code
ox code sql <sql>            # raw SQL against the DB

Data lives in ~/.local/share/sageox/codedb/ (XDG).

Benchmarks

Run with bash internal/codedb/bench.sh. Only the default branch (main/master) is indexed.

* tokio re-index time is dominated by git fetch network I/O (48.8s); actual re-index work is 0ms.

Search queries tested: spawn, type:symbol Runtime, lang:go func, type:diff streaming, file:main.go func (median of 3 iterations).