SQLite
14 production projects and 2 rule sets built with SQLite.
AGENTS.md Rules & Agent Skills
Bun + Hono + SQLite (libSQL & Drizzle ORM)
Ultra-fast edge API architecture using Bun.serve(), Hono v4, Drizzle ORM with embedded SQLite / Turso libSQL, and Zod OpenAPI validation.
Go + Echo + SQLite (Embedded, Self-Hosted Tools)
Architecture guidelines for single-binary Go services using the Echo framework, embedded SQLite, and minimal-JS server-rendered UI.
Production Projects
Grafana
Universal observability platform; Go backend queries disparate time-series databases and streams real-time telemetry to customizable React panels.
Vaultwarden
Unofficial Bitwarden compatible server written in Rust; replaces the heavy multi-container C#/.NET stack with a lightweight single-binary service consuming under 50MB of RAM.
Prisma
Benchmark developer experience for relational databases; leverages declarative schema modeling to auto-generate fully type-safe TypeScript clients backed by an optimized query engine.
Gitea
Frictionless GitHub alternative; written in Go to run on minimal hardware (even a Raspberry Pi) while providing Git repository management, issue tracking, and Docker-based CI/CD pipelines.
AppFlowy
Open-source Notion and Airtable alternative emphasizing complete data ownership and local-first offline execution. Built with Flutter for smooth cross-platform rendering and a high-performance Rust core engine managing CRDT document state and local SQLite persistence.
Fasten Health
Self-hosted personal health record aggregator connecting thousands of medical institutions via standard SMART-on-FHIR protocols. Built in Go for secure single-binary local-first deployment with embedded encrypted SQLite storage and zero third-party telemetry.
ElectricSQL
Local-first architecture moving the network off the critical user interaction path. Elixir actor processes manage Postgres logical replication streams, broadcasting differential "Shapes" to embedded SQLite on client devices with CRDT-based active-active conflict resolution.
Gatus
Lightweight developer status page; compiled into a single binary where Go performs zero-allocation concurrent health checks and serves an embedded Vue interface.
Open WebUI
Extensible OpenAI/Ollama interface; SvelteKit frontend delivers instant responsive streaming while Python FastAPI handles multi-modal RAG and tool calls.
RustDesk
Ultra-low latency TeamViewer alternative; Rust backend and signaling servers guarantee memory safety and maximum bandwidth efficiency.
Flowise
Visual canvas for building and debugging multi-agent LLM workflows; TypeORM handles dynamic agent graph configurations across SQLite or Postgres.
Strapi
Industry-standard headless CMS; customizable content schema engine with auto-generated REST and GraphQL endpoints.
PocketBase
Ultra-compact single binary: zero microservice maintenance overhead, handles 10,000+ RPS on a $5/mo VPS.
AFFiNE
Local-first collaborative workspace: CRDT conflict-free resolution in Rust with peer-to-peer sync engine.
Often Used With
Frequently Asked Questions
How many production projects use SQLite?
14 verified production projects in the STACK IT FAST directory use SQLite, each with a full architecture breakdown.
What is SQLite most often used with?
Across projects in the directory, SQLite is most commonly paired with PostgreSQL, TypeScript, Go.
Is there an AGENTS.md rule or Claude Code skill for SQLite?
Yes — Bun + Hono + SQLite (libSQL & Drizzle ORM), Go + Echo + SQLite (Embedded, Self-Hosted Tools) each include a full AGENTS.md, CLAUDE.md, Cursor .mdc rule set and an installable SKILL.md covering SQLite.