Project ideas from Hacker News discussions.

Show HN: Capsule – Single-file web apps that save their data into SQLite

📝 Discussion Summary (Click to expand)

Generating summary…


🚀 Project Ideas

SelfSave HTML Editor

Summary

  • Enables a single HTML file to automatically persist its own state (UI + data) back into the file using the File System Access API, eliminating manual “Save” steps.
  • Provides a tiny JavaScript API (selfSave.saveState()) that developers can call on changes, delivering a true document‑like experience for local‑first apps.

Details

Key Value
Target Audience Developers building personal tools, prototypes, or offline‑first apps who want a zero‑install, single‑file distribution
Core Feature Transparent self‑modifying HTML persistence with conflict‑free auto‑save
Tech Stack Vanilla JS, File System Access API, optional Service Worker for background sync
Difficulty Medium
Monetization Hobby

Notes

  • HN commenters complained about needing a manual Save button and the “HTML file opened locally can't update itself” pain (see yoz, bashtian, Dwedit). This library removes that friction.
  • Enables discussion around secure local‑first apps, paving the way for AI‑generated single‑file tools that truly act like documents.

Capsule Merge & Diff Tool

Summary

  • A visual diff/merge utility for .capsule (or self‑contained HTML) files that shows data and UI changes side‑by‑side and lets users resolve conflicts with a click‑to‑accept UI.
  • Addresses the version‑control pain point where multiple copies diverge and need manual reconciliation, as raised by razerbeans and bashtian.

Details

Key Value
Target Audience Power users and teams sharing capsule‑based apps (e.g., personal CRM, recipe tracker) who need to collaborate without a server
Core Feature Side‑by‑side diff of UUID/timestamp‑tagged records with merge‑conflict resolution UI
Tech Stack Electron/Tauri desktop app, React + Redux, IndexedDB for temporary storage, file‑system access for reading .capsule
Difficulty Medium‑High
Monetization Hobby

Notes

  • HN users highlighted the lack of a merge UI: “How do you merge them? … bashtian: … a merge like UI in the future to confirm which one to use.” (razerbeans, bashtian). This tool fulfills that request.
  • Could spark a new workflow for decentralized collaboration, similar to Git but for single‑file apps, encouraging discussion on conflict‑resolution strategies.

Tauri‑based Capsule Runtime

Summary

  • A lightweight, open‑source viewer/runtime for .capsule files built with Tauri that provides native OS file association, sandboxed execution, and optional cloud‑folder sync, offering a true “double‑click to run” experience without heavy Electron or Java runtimes.
  • Solves the distribution friction of requiring a separate host app (mentioned by al_borland, bashtian, lewisjoe) while keeping the app portable and secure.

Details

Key Value
Target Audience End‑users who want to run personal capsule apps (notes, recipes, small business tools) on Windows/macOS/Linux/Android without installing a bulky runtime
Core Feature Minimal (~10 MB) Tauri host that loads the bundled HTML/JS/SQLite from a .capsule file and exposes a secure API for file‑system access
Tech Stack Tauri (Rust backend), Svelte/React frontend, SQLite via better‑sqlite3, optional Sync via Dropbox API
Difficulty High
Monetization Hobby

Notes

  • Commenters noted the barrier: “If it’s a capsule, they first need to download the capsule app to associate the file extension…” (al_borland). This runtime reduces that barrier to a small, trusted binary.
  • Enables discussion about the future of local‑first, document‑style applications and could become a de‑facto standard for portable web apps, akin to PDF for documents.

Read Later