November 2025
SQLite Vector Store
A semantic search system for knowledge graphs using SQLite with the sqlite-vec extension and OpenAI embeddings, so knowledge-graph JSON files in object storage can be found by meaning, not just keyword matching.
Semantic search for knowledge graphs, no separate vector DB.
Semantic search for knowledge graphs, no separate vector DB.
A semantic search system for knowledge graphs using SQLite with the sqlite-vec extension and OpenAI embeddings, so knowledge-graph JSON files in object storage can be found by meaning, not just keyword matching.
- Local SQLite database — no separate vector-DB service to run
- Cost-effective OpenAI text-embedding-3-small embeddings
- TypeScript implementation on Node.js
More projects
view all →Vector Embeddings
An experiment in building a semantic search pipeline from scratch: text goes through OpenAI's embeddings API, gets stored in SQLite via sqlite-vec, and is queried by cosine similarity for the closest matching documents.
Chara Gen DDD
A small DDD proof of concept for AI character-image generation — generates a character in different art styles from one base reference image, deliberately scoped to the domain layer only (no CLI/UI layer) to test the modeling approach first.
MCP POC
A proof of concept for AI-driven workflow orchestration — an LLM generates a YAML (or JSON) workflow spec, executed against a fixed set of predefined TypeScript functions, so building a new workflow becomes a generation problem rather than new code every time.