Datasette
Datasette is an open-source data exploration and publishing tool developed by Simon Willison, primarily targeting SQLite database files. It allows users to rapidly transform datasets into browsable, queryable web applications with support for URL-parameter-based filtering, SQL queries, and a JSON API for programmatic access. Datasette is commonly used in data journalism, public dataset publishing, and lightweight data analysis, and its ecosystem includes a rich plugin system for extending visualization, authentication, and other functionality.
Core Facts
Simon Willison is the author of Datasette.
Datasette is an open-source data exploration and publishing tool developed by Simon Willison.
Datasette is an open-source tool that instantly transforms SQLite databases into interactive APIs and web interfaces.
Timeline (last 90 days)
datasette-ports identifies Datasette instances and their listening ports by scanning the operating system's process list, without relying on Datasette's own registration mechanism, so it can detect instances started in different ways such as from the command line, systemd, or containers.
Datasette listens on port 8001 by default; if that port is occupied, it automatically moves on to the next available port.
Datasette uses a plugin-based architecture, where plugins are distributed as Python packages, installed via `datasette install <plugin name>`, and automatically discovered and loaded at startup.
datasette-ports is a Datasette plugin developed by Simon Willison that scans for and lists all Datasette instances currently running on the machine.
Topics covered in the September newsletter include the pricing war, LLMs advancing into mathematics, a surge in accidental cyberattacks, and a vulnerability storm affecting Datasette, among others.
Simon Willison maintains multiple open-source projects, including the LLM command-line tool and Datasette.
Simon Willison refactored all modal dialogs within Datasette into a single Web Component
Datasette, being primarily Python-based with a minimalist frontend, chose Web Components over introducing frameworks like React in order to maintain its lightweight characteristics
Datasette's modal Web Component is now documented and open to plugin developers
Datasette 1.0a41 added native support for OpenTelemetry, contributed by Alec Garcia
32 more timeline events
All Facts (20)
Simon Willison is the author of Datasette.
80%VerifiedDatasette is an open-source data exploration and publishing tool developed by Simon Willison.
80%VerifiedDatasette is an open-source tool that instantly transforms SQLite databases into interactive APIs and web interfaces.
80%VerifiedDatasette is an open-source data exploration tool created by Simon Willison in 2017, designed specifically for SQLite databases.
80%VerifiedPrivilege level and data access scope determine the severity of a vulnerability.
70%VerifiedDatasette is currently in the transitional phase toward the official 1.0 release, with the 1.0 series continuing to iterate in alpha form.
65%VerifiedDatasette released version 0.65.4, a maintenance release focused on security fixes.
65%UnverifiedSimon Willison选择开发独立插件而非修改Datasette默认Referrer-Policy值，因为no-referrer是注重隐私的默认设置，贸然修改可能影响现有用户的安全预期
90%UnverifiedDatasette默认使用Referrer-Policy: no-referrer这一最严格的隐私策略
90%UnverifiedDatasette拥有超过100个插件的生态系统
85%UnverifiedLLM CLI 工具中所有对话历史默认存储在本地 SQLite 数据库，通常位于 ~/.config/io.datasette.llm/ 目录下
85%UnverifiedDatasette项目自2017年发布以来，已形成涵盖数据可视化、地理空间分析、身份认证等数百个扩展插件的生态系统
85%Unverifieddatasette.io使用Cloudflare Turnstile作为人机验证方案，相关路径被排除在限流之外
85%UnverifiedDatasette在数据新闻、开放数据以及快速原型开发等领域有着广泛应用
80%Partially VerifiedSimon Willison是Django Web框架的联合创始人之一，也是数据探索工具Datasette的作者
80%UnverifiedDatasette's permission system supports configuring access control policies separately at the instance level, database level, and table level.
60%UnverifiedThe datasette.io website is deployed on Fly.io and uses the Fly-Client-IP HTTP header to obtain the client's real IP address.
60%Unverifieddatasette-llm-accountant 是 Datasette 生态系统中专门负责 LLM 使用量记账的插件
60%Unverifieddatasette-ports is a Datasette plugin developed by Simon Willison that scans for and lists all Datasette instances currently running on the machine.
50%UnverifiedDatasette uses a plugin-based architecture, where plugins are distributed as Python packages, installed via `datasette install <plugin name>`, and automatically discovered and loaded at startup.
50%