Skip to content
TopicTracker
From HackerNewsView original
TranslationTranslation

Datasette-apps: Apps that live inside Datasette

Datasette-apps is a new system that allows users to bundle and install full applications within Datasette, turning it into a platform for data-driven apps. It enables developers to create self-contained packages combining SQLite databases, metadata, plugins, templates, and assets.

Background

- Datasette is an open-source tool (created by Simon Willison) that turns any SQLite database into an explorable, publishable web interface. It lets non-engineers browse, filter, and query data without writing code. - Datasette Apps is a new extension framework that lets developers build full-featured web applications that run *inside* Datasette. Instead of just viewing tables, users get custom tools like dashboards, visualizations, or data entry forms—all powered by the same underlying SQLite data. - This matters because it turns Datasette from a simple data browser into a platform for building lightweight, data-centric web apps without needing a separate backend or server. It's part of a broader trend of "batteries-included" tools that make publishing interactive data easier for journalists, scientists, and small teams.

Related stories

  • Datasette Apps is a new plugin that lets users host custom HTML+JavaScript apps inside Datasette in a sandboxed iframe with a Content Security Policy. The apps can run read-only SQL queries and optionally write data via stored queries. The feature supports AI-assisted creation through copyable prompts for LLMs.

  • Simon Willison released an alpha package, micropython-wasm, that runs MicroPython code inside a WebAssembly sandbox via wasmtime. It enforces memory/CPU limits, restricts file and network access, and supports persistent state and host functions for safely executing untrusted code in Python applications.

  • Simon Willison created a GitHub repository that converts Mozilla's browser-compat-data into a ~66MB SQLite database, using an AI-generated script and GitHub Actions to build and host the database on an orphan branch with open CORS headers for easy access via Datasette Lite.

  • Simon Willison released llm-coding-agent 0.1a0, an experimental coding agent built on his LLM library. The agent provides tools for reading, editing, searching files and executing commands, and ships with a Python API and CLI. It was developed using Claude Code (Fable 5) via TDD with a spec-first approach, and is available as a slop-alpha on PyPI.

  • Datasette 1.0a35 has been released, introducing a new "Create table" interface and JSON API, an "Alter table" feature with table modification capabilities, and official documentation for template context variables as a stable API for custom templates until version 2.0.