Skip to content

Self-Hosted Apps Built with SQLite

29 self-hostable apps built with SQLite you can run on your own server — compared on specs, deployment difficulty, and the SaaS each one replaces.

Security

2FAuth

A web-based self-hosted alternative to one-time-passcode apps like Google Authenticator, designed for both mobile and desktop: store TOTP and HOTP accounts, add them from a QR code and read the codes in a browser. Generates codes per RFC 4226 and RFC 6238, with optional encryption of sensitive data in the database. AGPL-3.0 PHP (Laravel); SQLite by default.
PHPLaravelSQLite
easyRead guide →
Monitoring

Beszel

A lightweight server monitoring hub with a small agent per machine, charting CPU, memory, disk, network and Docker container stats with history and threshold alerts. The hub is a single Go binary built on PocketBase, so there is no separate database to run.
GoPocketBaseSQLite
easyRead guide →
E-books & comics

Calibre-Web Automated

Builds on Calibre-Web, adding automation around the same web reader: drop a book into an ingest folder and it is converted, optionally metadata-fetched and added to a Calibre library for you, with duplicate detection, magic shelves, auto-send to e-readers, KOReader sync, Kobo sync, an OPDS feed and OAuth/OIDC sign-in. GPL-3.0 Python; runs as one container with SQLite.
PythonFlaskSQLite
easyRead guide →
Security

CrowdSec

An open-source intrusion-prevention engine that parses your server and application logs, detects brute force, scanning and other abusive behaviour with shared scenarios from its hub, and bans the offending IPs through separate 'bouncer' components for your firewall, reverse proxy or CDN. Every instance also pulls a community blocklist built from signals shared by other installs. The agent is MIT-licensed Go and runs as a single container with a SQLite database; it has no web UI of its own.
GoSQLite
moderateRead guide →
Project Management

Donetick

Task and chore manager for individuals, families and small groups, with flexible recurring schedules, assignee rotation, subtasks, labels, points and natural-language task entry. Stores data in SQLite by default, with PostgreSQL as an option.
GoReactSQLite
easyRead guide →
Backup

Duplicati

A backup client with a web UI that stores encrypted, incremental, compressed backups on cloud storage and remote servers: S3, Backblaze B2, OneDrive, Google Drive, WebDAV, SFTP, FTP and more. The open-source core is MIT-licensed C# on .NET (a few connectors under a proprietary/ directory need a paid subscription); it runs as a single container with its own SQLite databases in /data and backs up whatever host paths you mount into it.
C#.NETSQLite
easyRead guide →
Web analytics

GoatCounter

The smallest serious web analytics server: a single statically compiled Go binary (or the project's own Docker image) writing to a SQLite file, with PostgreSQL optional for big sites. It counts unique visits without cookies or identifiers, tracks referrers, campaigns, browsers, locations and screen sizes, and offers a JavaScript-free tracking pixel, a backend API, and log-file import. Its own README says it doesn't need a GDPR notice. Licensed EUPL-1.2; the same author runs a free hosted service.
GoSQLite
easyRead guide →
Social network (Fediverse)

GoToSocial

A lightweight ActivityPub social network server written in Go that federates with Mastodon and the rest of the Fediverse. It has no built-in posting client beyond a basic web view; you use a Mastodon-compatible app to post.
GoSQLitePostgreSQL
easyRead guide →
Inventory

Grocy

A household management app for groceries: it tracks stock and best-before dates, shopping lists, recipes and meal plans, plus chores, tasks and batteries.
PHPSlimSQLite
easyRead guide →
Inventory

Homebox

A home inventory and organization system for tracking items, locations, labels, warranties and receipts. It is a single Go binary with an embedded web UI and a SQLite database.
GoVueNuxtSQLite
easyRead guide →
Invoicing

InvoiceShelf

An open-source web application for creating invoices and estimates, tracking payments and managing expenses, with customers and items, taxes, recurring invoices and reports. A Laravel and Vue application; the project's Compose files run it with SQLite, MySQL or PostgreSQL.
PHPLaravelVueSQLite
easyRead guide →
Monitoring

Kener

A status page system: public pages fed by uptime monitors, with incidents, maintenance windows, alerting and role-based team access, so your users can see what is up and what is not. MIT-licensed, built with Node.js and Svelte; it needs Redis for its queues, cache and scheduler and stores its own data in SQLite by default (PostgreSQL or MySQL via DATABASE_URL).
TypeScriptSvelteRedisSQLite
easyRead guide →
URL shortener

Kutt

A URL shortener with custom domains, custom slugs, password-protected and expiring links, per-link statistics and an API. The default Docker setup uses SQLite, with Postgres, MariaDB and Redis as options.
Node.jsSQLite
easyRead guide →
SSO & Identity

LLDAP

A lightweight LDAP server for user and group management with a web UI, built to be the user directory behind Authelia, Keycloak, Nextcloud and other apps that authenticate over LDAP. It implements an opinionated subset of LDAP rather than a full directory server.
RustSQLite
easyRead guide →
Notes

Memos

A lightweight, self-hosted note stream for short-form Markdown notes, links and work logs, organized by timeline, tags and search rather than folders. It runs as a single container backed by SQLite by default.
GoReactSQLite
easyRead guide →
Video platform

Owncast

A self-hosted live-streaming and chat server for a single streamer: point OBS or any RTMP broadcaster at it and viewers watch on your own web page, with built-in chat, moderation, viewer stats and optional publishing to the Fediverse. It is MIT-licensed Go with an embedded SQLite database and ships as one container, so there is no separate database or cache to run.
GoTypeScriptSQLite
easyRead guide →
Documents

Papra

A minimalist document management and archiving platform: upload, tag and full-text search documents, share them within organizations, and import them automatically from email or a watched folder, with text extraction from images and scans. Runs as a single container with an embedded SQLite database.
TypeScriptNode.jsSolidJSSQLite
easyRead guide →
Backend & BaaS

PocketBase

Open-source backend in a single Go binary — embedded SQLite database, built-in auth, realtime subscriptions, file storage, and an admin dashboard with zero external dependencies.
GoSQLite
easyRead guide →
Workflow automation

Prefect

A Python workflow orchestration platform: decorate ordinary functions as flows and tasks, and the server tracks every run, schedules deployments, retries failures and shows state, logs and schedules in a web dashboard. Apache-2.0; `prefect server start` runs the API and UI in one container with SQLite by default, and PostgreSQL for production.
PythonSQLite
easyRead guide →
Read-it-later

Readeck

A read-it-later and bookmark archiver: paste a link and it stores the readable text and images on your server, with labels, highlights, saved-search collections, full-text search, EPUB export, an OPDS catalog, browser extensions and mobile apps. AGPL-3.0-only, written in Go; it runs as a single container with SQLite in one data volume (PostgreSQL optional).
GoSQLite
easyRead guide →
Notes

SiYuan

A block-based personal knowledge management system: block-level references and two-way links, Markdown WYSIWYG editing, a database table view, flashcards with spaced repetition and PDF annotation, served from your own server to the browser. The user interface and Go kernel are AGPL-3.0, with notes stored as JSON files in a workspace folder you mount; the Docker build is browser-only and some member features are paid.
GoTypeScriptSQLite
easyRead guide →
Team chat

Synapse

The reference Matrix homeserver, maintained by Element. It hosts accounts and rooms for the Matrix protocol, which any Matrix client (such as Element) can connect to, and can federate with other Matrix servers.
PythonRustSQLitePostgreSQL
easyRead guide →
Time tracking

TimeTagger

An interactive time tracker with a timeline you drag to record and edit entries, tags, a report view and PDF export, aimed at freelancers and individuals. Python server with a single-file data store; credentials are set with a bcrypt hash in an environment variable.
PythonSQLite
easyRead guide →
Time tracking

Traggo

A self-hosted time tracker built around tags instead of tasks and projects: you record tagged time spans, then slice them in dashboards by any tag. One Go binary with a built-in web UI and SQLite, shipped as a single container.
GoSQLite
easyRead guide →
Notes

Trilium Notes

A hierarchical note-taking app for building a personal knowledge base, with rich-text and code notes, note cloning, per-note encryption and scripting. The server edition serves a web UI and acts as the sync server for the Trilium desktop app.
TypeScriptNode.jsSQLite
easyRead guide →
Project Management

tududi

Personal task and project manager that organizes work into areas, projects, tasks and notes, with tags, recurring tasks, Telegram integration and CalDAV sync. Stores data in a single SQLite file by default, with PostgreSQL supported.
TypeScriptNode.jsExpressReactSQLite
easyRead guide →
Project Management

WeKan

Open-source kanban board with swimlanes, lists, cards, checklists, labels, due dates, attachments and board templates, built on Meteor. The default Docker setup stores data through FerretDB (a MongoDB-compatible layer) on SQLite, with MongoDB and PostgreSQL-backed variants also provided.
JavaScriptMeteorFerretDBSQLite
easyRead guide →
Fitness

Workout Tracker

A workout tracking web application for personal use (or family and friends), geared towards running and other GPX-based activities: upload GPX, TCX or FIT files, add manual workouts, follow statistics, route segments, equipment and a heatmap of where you have been. A single Go binary with SQLite by default.
GoSQLite
easyRead guide →
Social network (Fediverse)

WriteFreely

A minimalist, distraction-free blogging platform for one writer or a whole community. Blogs federate over ActivityPub, so readers on Mastodon and other Fediverse software can follow them.
GoSQLiteMySQL
easyRead guide →

Analytics cookies only (Google Analytics, PostHog). No ad networks, no cross-site tracking. See our privacy policy.