Skip to content

Instantly share code, notes, and snippets.

@simonw
Created June 9, 2026 23:20
Show Gist options
  • Select an option

  • Save simonw/e77abf645156ade8c5c610f524226dcb to your computer and use it in GitHub Desktop.

Select an option

Save simonw/e77abf645156ade8c5c610f524226dcb to your computer and use it in GitHub Desktop.

2026-06-09T23:13:47 conversation: 01ktqamcp69kwmsj3h8bbgkke7 id: 01ktqakpama4gk96656709dfwg

Model: anthropic/claude-fable-5

Prompt

List all of Simon Willion's open source projects, most recent first, each with a rough date of when they were first released

Response

I think you mean Simon Willison — the prolific open source developer, co-creator of Django, and creator of Datasette.

An important caveat upfront: a truly complete list isn't feasible. Simon Willison is famously prolific — he has published hundreds of repositories (Datasette alone has 100+ plugins, many written by him), and my knowledge has a cutoff date, so I'll be missing his most recent work. Below are his notable projects with approximate initial release dates, most recent first:

Notable projects (approximate dates)

  • files-to-prompt (April 2024) – concatenates files into a single prompt for LLMs
  • datasette-extract (2024) – plugin for extracting structured data using LLMs
  • LLM (May–June 2023) – CLI tool and Python library for interacting with large language models, plus a large ecosystem of plugins (llm-gpt4all, llm-mistral, llm-claude, etc., 2023 onward)
  • symbex (June 2023) – search Python code for symbols
  • ttok and strip-tags (May 2023) – CLI tools for token counting and HTML cleanup for LLM pipelines
  • datasette-lite (May 2022) – Datasette running entirely in the browser via WebAssembly/Pyodide
  • shot-scraper (March 2022) – automated website screenshots via Playwright
  • s3-credentials (November 2021) – CLI for creating scoped AWS S3 credentials
  • django-sql-dashboard (2021) – SQL reporting dashboards for Django
  • Dogsheep suite (2019) – personal analytics tools: twitter-to-sqlite, github-to-sqlite, healthkit-to-sqlite, dogsheep-beta, etc.
  • sqlite-utils (2018) – CLI and Python library for manipulating SQLite databases
  • Datasette (November 2017) – his flagship project; tool for exploring and publishing data
  • csvs-to-sqlite (2017) – convert CSV files to SQLite
  • Various early tools (~2007–2010) – soupselect, json-head, geocoders, and others
  • Django (developed 2003–2005, open-sourced July 2005) – co-created with Adrian Holovaty at the Lawrence Journal-World

For an accurate, current list

I'd recommend checking these sources directly:

  • His GitHub profile: github.com/simonw (sorted by recently created)
  • His blog: simonwillison.net, where he announces nearly every release
  • His "projects" page on his blog, which he maintains himself

Would you like more detail on any specific project?

Token usage

38 input, 1,690 output

2026-06-09T23:14:38 conversation: 01ktqangr0s1cs5pz3n1e5hr79 id: 01ktqan8pg3c7c5h7j1jkcnnn1

Model: anthropic/claude-opus-4-8

Prompt

List all of Simon Willion's open source projects, most recent first, each with a rough date of when they were first released

Response

I don't have a reliable, comprehensive, and date-verified list of all of Simon Willison's open source projects, and I want to be honest about that rather than risk giving you inaccurate dates or fabricated entries.

Here's what I can tell you with reasonable confidence:

Well-known projects by Simon Willison:

  • LLM (~2023) – A command-line tool and Python library for interacting with large language models.

  • Datasette (~2017) – A tool for exploring and publishing data, probably his most prominent recent project.

  • sqlite-utils (~2018-2019) – A Python library and CLI tool for manipulating SQLite databases, often used alongside Datasette.

  • Django (2005) – He is one of the co-creators of the Django web framework, along with Adrian Holovaty, originally developed at the Lawrence Journal-World newspaper.

He also maintains a large ecosystem of Datasette plugins and many smaller utilities (often with names like shot-scraper, various *-to-sqlite tools for importing data, etc.).

Why I'm hedging: Simon Willison is extremely prolific—he has published a very large number of small tools and plugins, and I can't reliably enumerate all of them or pin down precise release dates without risking errors.

For an accurate, complete list, I'd recommend:

  • His GitHub profile: github.com/simonw
  • His blog: simonwillison.net, where he documents project releases (his "TILs" and project announcements are well-dated there)

Would you like me to share more detail on any of the specific projects I mentioned?

Token usage

38 input, 533 output

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment