This file provides guidance to Claude Code (claude.ai/code) when working with code in this repository.
This is sqlite-delta, a collection of Change Data Capture (CDC) patterns for SQLite databases. This repository is educational - the patterns are designed to be studied, understood, and adapted rather than used directly in production.
The Python implementations serve as working examples with comprehensive tests to demonstrate the concepts. Users should read and understand the patterns, then re-implement them in their own codebase tailored to their specific tables and requirements.
# Install dependencies
uv sync
# Lint python files
uv run poe lint
# Format python files
uv run poe fmt
# Test all patterns
uv run poe test
# Run a specific python file
uv run path/to/python/file.pyRun lint, fmt, and test before finishing any task to verify correctness.
- uv - Python package manager and task runner (required)
trigger-lite/ - General-purpose CDC using SQLite triggers three-phase/ - Delta compression using triple-buffering
pattern.py- Complete Python implementation with comprehensive tests and examplesREADME.md- Pattern documentation and usage examples
- When committing on behalf of the user just sign off with:
Co-Authored-By: Claude <noreply@anthropic.com>