SQLite—A local video archive that sqlite3 can query.

What it does

Archive every peepshow run — video metadata, all extracted frames, timings, and scene scores — into a single SQLite file on disk. Queryable with any SQLite tool, portable, zero-config.

When to reach for it

• Keep a searchable log of every video an LLM has seen
• Join run history with your own sqlite tables for domain-specific indexing
• Ship a prebuilt `.sqlite` with a video dataset so agents can grep metadata before watching frames

Install

# runtime + optional driver (native module, needs toolchain)
npm i -g peepshow
npm i -g better-sqlite3

Use it

peepshow ./keynote.mp4 --sink sqlite \
  --sink-arg path=~/peepshow.sqlite

Make it automatic

Register the sink once — every run fires it afterward. Scope by--whenso it only runs for matching videos.

peepshow sinks add sqlite
peepshow sinks add sqlite --when extension=mp4,mov
peepshow sinks add sqlite --when path=/Volumes/Work/

Configuration

• PEEPSHOW_SQLITE_PATHOverride the default database location.

Write your own

A sink is any executable that reads the--emit jsonpayload on stdin. Shell, Node, Python, Go — the spec's indocs/PLUGINS.md. Register persistent ones withpeepshow sinks add-cmd 'your-command'.