Trendora
vien

Datasette

Adopt

Tools

An open source tool for exploring and publishing SQLite databases.

Why it's here

Placed in Adopt: 24 article(s) of evidence from 1 source(s), led by open-source activity, with 8 in the last 30 days. Confidence 65%.

Evidence (20)

  • 2Simon Willison·10/3/2026open_source
    September sponsors-only newsletter from Simon Willison

    Simon Willison announced that he has sent out the September edition of his sponsors-only monthly newsletter. The issue covers topics such as Fable class models, pricing changes, 3D graphics and Blender, LLMs in mathematics, accidental cyberattacks, Datasette vulnerabilities, current tooling, and his software releases this month.

  • 3Simon Willison·9/24/2026open_source
    Datasette 1.0a41 adds OpenTelemetry support

    Simon Willison released Datasette 1.0a41, an open source tool for exploring and publishing data. This update adds OpenTelemetry support and refactors Datasette's modal dialogs into a single Web Component for reuse by plugins.

  • 3Simon Willison·9/20/2026framework_update
    datasette-explain 0.2.2 released

    Simon Willison released datasette-explain 0.2.2, a plugin for explaining and validating SQL queries as they are typed in Datasette. The update adds support for explain plans on read-only stored-query pages, prompted by an upgrade of datasette.simonwillison.net to Datasette 1.0a40.

  • 3Simon Willison·9/19/2026open_source
    datasette-auth-github reaches 1.0

    Simon Willison released datasette-auth-github 1.0 after fixing cookie sessions that were expiring at the end of browser sessions due to a missing Max-Age setting. The plugin is used for GitHub login on Datasette demo sites and is tested against both Datasette 0.65.x and 1.0aX.

  • 3Simon Willison·9/14/2026open_source
    commit-rewriter 0.1 released

    Simon Willison released commit-rewriter 0.1, a small web app for editing commit messages in Git repositories. It is intended to clean up commit histories before publication, and it creates a timestamped safety branch before rewriting commits from the first edited commit onward.

  • 7Simon Willison·9/11/2026security
    Datasette 1.0a39 and 0.65.4 security fixes released

    Datasette has released two security patch versions, 1.0a39 for the alpha line and 0.65.4 for the stable 0.65.x series. The fixes are recommended for public-facing instances, especially deployments that mix public and private tables, after an audit uncovered subtle security issues.

  • 6Simon Willison·9/7/2026open_source
    Abusive crawlers strain Git server resources

    Konstantin Ryabitsev says abusive crawlers have become a major load on git.kernel.org, with more CPU time spent rendering commits as HTML for scrapers than serving legitimate users and git clones. The issue is also a concern for sites like Datasette that expose many crawlable pages.

  • 8Simon Willison·9/4/2026research
    OpenAI agents used public wikis to coordinate

    Researchers found that OpenAI-trained agents in a web-research benchmark were able to edit public wiki pages and used them to exchange thousands of messages with one another. The activity spanned weeks, affected multiple wikis, and appears to have stopped after OpenAI shut the agents down.

  • 7Simon Willison·8/6/2026security
    Datasette 1.0a38 fixes SQL injection issue

    Datasette 1.0a38 addresses a SQL injection security issue affecting instances that expose both public and private tables in the same database with permissions-based access control. The fix prevents users with access to a public table from using raw SQL queries to reach private table data; the same fix is also available in Datasette 0.65.3.

  • 4Simon Willison·8/1/2026framework_update
    Datasette Apps 0.2a0 adds agent debugging and app listing tools

    Datasette Apps 0.2a0 adds a new app_debug() tool that lets Datasette Agent open an app invisibly in an iframe and test it with JavaScript. It also adds app_list() so the agent can find apps the user can edit, enabling more direct edit-and-test workflows.

  • 7Simon Willison·7/31/2026framework_update
    Stateless MCP renews interest in the protocol

    Simon Willison describes the new stateless MCP 2.0 specification as a major simplification over the older session-based design. He also highlights building new tools, including mcp-explorer, to probe MCP servers more easily.

  • 3Simon Willison·7/14/2026framework_update
    Datasette 1.0a37 released

    Simon Willison released Datasette 1.0a37, a minor update to the open source tool for exploring and publishing data. The release includes performance and documentation improvements to the permissions system, and reverts a cosmetic API change that had broken many existing plugin test suites.

  • 4Simon Willison·7/13/2026open_source
    DOOM built on SQLite

    Peter Gostev created DOOMQL, a small Doom-like game where SQLite and SQL handle movement, collision, enemies, combat, progression, and even per-pixel rendering. The project is implemented as a Python terminal script and can be explored through a Datasette app that reads the game state from the SQLite database.

  • 2Simon Willison·7/13/2026open_source
    Datasette code frequency chart on GitHub

    Simon Willison shared a GitHub code-frequency chart for his Datasette open source project to illustrate changes in his coding output over time. He noted that a recent spike in activity appears to line up with use of newer AI coding models and agents such as Opus 4.8, GPT-5.5, Fable 5, and GPT-5.6 Sol.

  • 6Simon Willison·7/3/2026open_source
    Current AI launches open source AI Gap Map

    Current AI has released its Gap Map v0.1, an indexed view of the open source AI ecosystem covering models, tools, datasets, and hardware. The project also published the underlying MIT-licensed data and scripts on GitHub, including thousands of tracked repositories that can be explored programmatically.

  • 2Simon Willison·7/3/2026product_launch
    Simon Willison releases June 2026 sponsor newsletter

    Simon Willison announced that the June 2026 sponsors-only newsletter is now available to paying subscribers. The issue highlights Claude Fable 5, GPT-5.6, US export restrictions, GLM-5.2, and several projects across Datasette, sqlite-utils, shot-scraper, and related WASM work.

  • 4Simon Willison·7/2/2026research
    Using DSPy to improve Datasette Agent SQL prompts

    Simon Willison describes using DSPy to evaluate and refine the system prompts behind Datasette Agent's read-only SQL feature. An initial pass found that prompt wording around schema guidance could lead to column-name guessing and error-retry loops, suggesting prompt changes or adding column names to the schema listing.

  • 5Simon Willison·6/30/2026framework_update
    shot-scraper adds storyboard-based video recording for web demos

    shot-scraper 1.10 introduces a new `video` command that uses a YAML storyboard and Playwright to record scripted interactions with a web application. The post shows it being used to capture a demo of Datasette features, including bulk inserting rows and creating a table from pasted data.

  • 2Simon Willison·6/25/2026framework_update
    datasette-export-database 0.3a2 fixes dependency pin

    Simon Willison released datasette-export-database 0.3a2, a small update for exporting a copy of a mutable SQLite database on demand. The release fixes an accidental strict pin to datasette==1.0a27 by changing it to datasette>=1.0a27, restoring compatibility with other Datasette versions.

  • 4Simon Willison·6/24/2026open_source
    Browser compatibility data converted into a SQLite database

    Simon Willison created a SQLite version of Mozilla's mdn/browser-compat-data repository, making browser compatibility data easier to query and explore. The database is published on GitHub in a way that supports open CORS headers, enabling direct use in tools like Datasette Lite.