The MCP Pattern: SQLite as the AI-Queryable Cache
Every data silo follows the same architecture: domain files as ground truth, SQLite + FTS5 as a read-only cache, MCP as the query interface. After building five of these, the pattern is clear.
Browse posts by tag
Every data silo follows the same architecture: domain files as ground truth, SQLite + FTS5 as a read-only cache, MCP as the query interface. After building five of these, the pattern is clear.
narro can now generate audio narration for Hugo blog posts, with synchronized sentence highlighting in the browser. The alignment problem turned out to be more interesting than expected.
A walkthrough of Chartfold, a Python tool that loads your medical records into SQLite and exposes them to Claude via MCP for structured analysis, visit prep, and ad-hoc queries.
dapple is a terminal graphics library with one Canvas API, seven pluggable renderers, and eleven CLI tools for displaying images, data, video, math, and more.
A walkthrough of Posthumous, a self-hosted dead man's switch that monitors periodic check-ins via TOTP, progresses through escalating alert stages, and triggers automated actions if you stop responding.
pagevault turns any file into a self-contained encrypted HTML page. No backend, no JavaScript libraries, no external dependencies. Just AES-256-GCM and the browser's built-in Web Crypto API. The interesting part is making it work at scale.
longecho evolves from specification to implementation with build, serve, and manifest features.
Expanding the Long Echo toolkit with photos and mail, building toward longshade, the persona that echoes you.
Expanding the Long Echo ecosystem with photo and mail archival. Your memories and correspondence deserve the same preservation as your conversations and bookmarks.
Graceful degradation made concrete: years of bookmarks exported to a self-contained HTML app that works offline, forever.
Three CLI tools for preserving your digital intellectual life: conversations, bookmarks, and books. SQLite-backed, exportable, built to outlast the tools themselves.
A Python library for symbolic computation with a readable DSL, pattern matching, and a security model that separates rules from computation.
A CLI tool for cross-posting content to dev.to, Hashnode, Bluesky, Mastodon, and more, with LLM-powered auto-rewrite for short-form platforms.
A metadata index that gives LLM tools like Claude Code awareness of your entire repository collection.
Define statistical models symbolically and automatically derive score functions, Hessians, and Fisher information. No numerical approximation.
A corpus-based language model using suffix arrays for O(m log n) pattern matching. The corpus is the model.
AlgoGraph is an immutable graph library for Python with pipe-based transformers, declarative selectors, and lazy views.
A database-first bookmark manager with hierarchical tags, content caching, and NLP auto-tagging. Part of the Long Echo toolkit.
A framework for querying structured JSON documents using fuzzy logic, producing degree-of-membership scores instead of binary relevance.
A tool that converts source code repositories into structured, context-window-optimized Markdown for LLMs, with intelligent summarization and importance scoring.
A Python library for rule-based term rewriting with pattern matching, multiple input formats, and an interactive REPL.
How I turned scattered data managers into navigable systems using virtual filesystems and POSIX commands.
EBK is a comprehensive eBook metadata management tool with AI-powered enrichment, semantic search, and knowledge graphs. Part of the Long Echo toolkit.
A virtual POSIX-compliant filesystem using content-addressable DAG storage with SHA256 deduplication.
A plugin-based toolkit for managing AI conversations from multiple providers. Import, store, search, and export conversations in a unified tree format. Built for the Long Echo project.
A logic programming system that alternates between wake and sleep phases, using LLMs for knowledge generation during wake and compression-based learning during sleep.
ZeroIPC treats shared memory not as passive storage but as an active computational substrate, bringing futures, lazy evaluation, reactive streams, and CSP channels to IPC with zero-copy performance.
27 image commands, one constraint: read JSON, write JSON. The closure property as a generative design principle.
A streaming data processing system implementing boolean algebra over nested JSON structures, with lazy evaluation, S-expression queries, and memory-efficient windowed operations.
A command-line implementation of relational algebra for JSONL data with full support for nested structures, schema inference, and composable pipelines.
A composable ecosystem of tools for manipulating nested data structures. From a simple helper function to a full data algebra, guided by purity, pedagogy, and the principle of least power.
Applying Monte Carlo Tree Search to large language model reasoning, with a formal specification of the algorithm.
A Lisp-like functional language designed for network transmission. JSL makes JSON serialization a first-class design principle, so closures, continuations, and entire computation states can travel over the wire.
An immutable-by-default tree library for Python with composable transformations, pipe-based pipelines, and pattern-matching selectors.
A tiny autodiff library for understanding how backpropagation actually works.
Define patterns, define replacements, repeat until done. Watch a 90-line rewrite engine learn to differentiate.
Three Python approximations of a random oracle, each showing a different tradeoff between true randomness, determinism, and composability.