data · database
Filter in Explore SQLite
29 production projects and 5 rule sets built with SQLite.
Production projects
- Self-Hosted Real-Time Push Server Classic Gotify Gotify keeps the server one deployable Go binary by embedding its Vite/React web UI, using Gin and gorilla/websocket for the REST and streaming API, and swapping SQLite, MySQL or PostgreSQL through GORM, while a compiled Go plugin system handles extensibility instead of a scripting layer.
- Desktop & Web AI Agent Workspace AI-agent MindsHub (formerly MindsDB) Splitting the client, API and agent into separately versioned git submodules lets each ship on its own cadence (a signed desktop app, a PyPI server package, an agent package), while one Makefile and one docker-compose.yml still bring the whole stack up together.
- Shell History Sync Classic Atuin Atuin keeps history local in SQLite and encrypts it before sync, so the Axum sync server stays a thin store; a gRPC daemon and capability crates (CLI, server, AI, dotfiles) let each part evolve behind feature flags.
- Identity Management Platform Classic Kanidm Kanidm ships every identity protocol from one Rust server with bundled SQLite and built-in replication, renders its UI with Axum, Askama and htmx, and maintains its own WebAuthn, JWT and LDAP crates to keep security-critical code under its control.
- Rails-Style Rust Web Framework Classic Loco Loco assembles proven crates (Axum, SeaORM, Tera, Lettre, OpenDAL) behind Rails-style conventions and generators, uses feature flags to keep infrastructure optional, and ships an AGENTS.md, an agent skill and evals so agents can build on it.
- LLM Knowledge Base & RAG Platform Classic WeKnora Retrieval, agents and the API sit in one Go service, and parsing is delegated to a Python gRPC service. Storage backends are pluggable, so the same codebase runs as a lite SQLite binary or a full Kubernetes deployment on existing Postgres, Elasticsearch or vector databases.
- Lightweight Self-Hosted Password Vault Classic Vaultwarden Vaultwarden replaces the heavy, multi-container official Bitwarden stack with a single fast Rust executable consuming minimal RAM.
- Self-Hosted Collaborative Productivity Suite Classic Nextcloud Server internals (OC) are kept separate from a versioned public API (OCP) so that independently namespaced apps under apps/ can extend Nextcloud without depending on private implementation details, while database support is validated per-engine in CI.
- Instant GraphQL Engine & Unified Data Access Classic Hasura Hasura runs two independently evolving query engines from one repository — a Haskell V2 server and a Rust V3 engine — and extends database support through an out-of-process Data Connector protocol, so a new database backend plugs in as a separate agent instead of new code inside either engine.
- Next.js-Native Headless CMS & App Framework Hybrid Payload CMS A pnpm and Turborepo monorepo lets one core package share a common database-adapter export shape across MongoDB, Postgres, SQLite, and D1, while GraphQL, storage providers, and deployment templates stay in separate packages so a project only pulls in the pieces its target host and database actually need.
- Next-Generation Node.js & TypeScript ORM Classic Prisma Declarative schema modeling combined with modular driver adapters allows Prisma to generate fully type-safe database clients that run consistently from Node servers to edge runtimes.
- Secure JavaScript & TypeScript Runtime Classic Deno A single Cargo workspace embeds V8 directly in Rust so the CLI, its Web API extensions, and npm compatibility ship as one statically-linked binary instead of relying on a separate Node.js toolchain.
- Lightweight Self-Hosted Git Service Classic Gitea One Go process fronted by XORM abstracts four relational databases and pluggable search/storage backends, so the same codebase scales from a single SQLite file on a Raspberry Pi to a MySQL- or PostgreSQL-backed team instance.
- Fair-Code Workflow Automation & AI Integrator Hybrid n8n n8n splits its execution engine, workflow schema, and integration nodes into separate TypeORM- and Express-backed packages so the automation runtime, node library, and Vue editor can be built, tested, and versioned independently inside one Turborepo-orchestrated pnpm workspace.
- All-in-One JavaScript Runtime & Toolchain Classic Bun Implementing the runtime, bundler, installer and test runner as one Cargo workspace around a single embedded JS engine keeps startup and cross-tool integration fast, while a dedicated *_jsc crate layer isolates the JavaScriptCore bridge from the rest of the Rust codebase.
- Lightweight Server & Container Monitoring Classic Beszel Building the hub on PocketBase gives Beszel a REST API, auth, realtime updates, and SQLite storage from one embedded framework, while a separate Go agent binary keeps the footprint on monitored systems minimal, matching its stated goal of being lighter than existing monitoring solutions.
- Local-First Privacy Workspace Hybrid AppFlowy Flutter delivers five platforms from one codebase while a Rust core owns storage, CRDT documents, search and AI behind a protobuf FFI boundary, keeping data local by default and sync optional.
- Authentication & SSO Proxy Companion Classic Authelia A single fasthttp-based Go binary keeps the authentication portal, OIDC provider, and MFA logic in one process with pluggable SQLite/MySQL/PostgreSQL storage, so it can run as a zero-dependency single instance or scale out with a shared database.
- Geo-Distributed Object Storage Engine Classic Garage Garage splits RPC, replication, storage and each API protocol into separate Rust crates around a pluggable embedded metadata engine (LMDB, SQLite or Fjall), so a geo-distributed cluster can tolerate node and network failures without depending on an external coordination service or database.
- Personal Health Records & Medical EHR Engine Classic Fasten Health A single distroless Docker image embeds the Angular build inside the Go binary and defaults to file-based SQLite so a family can self-host medical records without provisioning a separate database or web server.
- Q&A & Developer Knowledge Community Classic Apache Answer A statically linked Go binary that embeds its React UI and supports SQLite, MySQL or PostgreSQL keeps deployment to one container, while typed plugin interfaces extend auth, storage, search and AI without forking.
- Automated Health Dashboard & Status Monitor Classic Gatus The whole product ships as one Go binary with the Vue dashboard embedded via go:embed and YAML-defined check conditions, so a status page needs no separate frontend server and, by default, no external database.
- Self-Hosted AI Interface & Agent Hub AI-agent Open WebUI A SvelteKit-plus-FastAPI split lets one Docker image serve the UI and API together, while SQLAlchemy over SQLite or PostgreSQL and a swappable vector-store layer let self-hosters scale from a laptop to a multi-worker Redis-backed deployment without changing code.
- Smart Database Spreadsheet Hybrid NocoDB The backend uses Knex as a database-agnostic query layer over pg, mysql2, and sqlite3 so the same NestJS service can target whichever database an operator already runs, while the frontend and SDK are separate workspace packages that let the grid UI and API client evolve without redeploying the whole app.
Often used with SQLite
AGENTS.md rules and agent skills with SQLite
bun-hono-sqlite/AGENTS.mdBun + 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. intermediateexpo-sqlite-local-first/AGENTS.mdExpo + SQLite + Drizzle (Local-First Mobile App)Rules for an offline-first Expo SDK 57 app: expo-sqlite with Drizzle migrations bundled in the app, no backend by default, sync as an optional module, EAS Build and Update. startergo-echo-sqlite/AGENTS.mdGo + 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. intermediatehono-jsx-internal-tools/AGENTS.mdHono JSX + Bun + SQLite (Server-Rendered Internal Tools)Rules for internal tools rendered on the server with Hono JSX on Bun: forms over fetch, htmx where needed, an OAuth allow-list, Drizzle over SQLite or a read replica, and cron in the same process. startertauri-react-desktop/AGENTS.mdTauri 2 + React + Vite (Rust Desktop App)Desktop app rules for Tauri 2: React + Vite + TypeScript UI, typed Rust commands, least-privilege capabilities, SQLite in Rust, updater and signed CI builds. intermediate
Questions about SQLite
How many production projects use SQLite?
29 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 TypeScript, Docker, PostgreSQL.
Is there an AGENTS.md rule or Claude Code skill for SQLite?
Yes — Bun + Hono + SQLite (libSQL & Drizzle ORM), Expo + SQLite + Drizzle (Local-First Mobile App), Go + Echo + SQLite (Embedded, Self-Hosted Tools), Hono JSX + Bun + SQLite (Server-Rendered Internal Tools), Tauri 2 + React + Vite (Rust Desktop App) each include a full AGENTS.md, CLAUDE.md, Cursor .mdc rule set and an installable SKILL.md covering SQLite.