Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release dclient 0.1a0 — A client CLI utility for Datasette instances
TIL Wider tooltip areas for Observable Plot — In [this Observable notebook](https://observablehq.com/@simonw/mastodon-users-and-statuses-over-time) I'm plotting a line on a chart, but I want to provide tooltips showing the exact value at any point on the line.
Release datasette-graphql 2.1.2 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette 0.63.2 — An open source multi-tool for exploring and publishing data
Release datasette-edit-schema 0.5.2 — Datasette plugin for modifying table schemas
Release datasette-indieauth 1.2.2 — Datasette authentication using IndieAuth and RelMeAuth
Release datasette-import-table 0.3.1 — Datasette plugin for importing tables from other Datasette instances
Release datasette-public 0.2.1 — Make selected Datasette databases and tables visible to the public
Release datasette-copyable 0.3.2 — Datasette plugin for outputting tables in formats suitable for copy and paste
Release datasette-edit-templates 0.2 — Plugin allowing Datasette templates to be edited within Datasette
Release datasette-configure-fts 1.1.1 — Datasette plugin for enabling full-text search against selected table columns
Release datasette-socrata 0.3.1 — Import data from Socrata into Datasette
Release datasette-ripgrep 0.7.1 — Web interface for searching your code using ripgrep, built as a Datasette plugin
Release datasette-search-all 1.1.1 — Datasette plugin for searching all searchable tables at once
TIL Verifying your GitHub profile on Mastodon — Mastodon has a really neat way of implementing verification, using the [rel=me microformat](https://microformats.org/wiki/rel-me).
TIL How to create a tarball of a git repository using "git archive" — I figured this out in [a Gist in 2016](https://gist.github.com/simonw/a44af92b4b255981161eacc304417368) which has attracted a bunch of comments over the years. Now I'm upgrading it to a retroactive TIL.
TIL HTML datalist — A [Datasette feature suggestion](https://github.com/simonw/datasette/issues/1890) concerning autocomplete against a list of known values inspired me to learn how to use the HTML `<datalist>` element ([see MDN](https://developer.mozilla.org/en-US/docs/Web/HTML/Element/datalist)).
TIL Writing tests with Copilot — I needed to write a relatively repetitive collection of tests, for a number of different possible error states.
TIL JSON Pointer — I'm [looking at options](https://github.com/simonw/datasette/issues/1875) for representing JSON validation errors in more JSON. The recent [RFC 7807: Problem Details for HTTP APIs](https://datatracker.ietf.org/doc/draft-ietf-httpapi-rfc7807bis/) looks relevant here.
TIL Generating OpenAPI specifications using GPT-3 — I wanted to start playing around with [OpenAPI](https://www.openapis.org/). I decided to see if I could get GPT-3 to generate the first version of a specification for me.
Release datasette 0.63.1 — An open source multi-tool for exploring and publishing data
TIL Export a Mastodon timeline to SQLite — I've been playing around with [the Mastodon timelines API](https://docs.joinmastodon.org/methods/timelines/). It's pretty fun!
TIL Getting Mastodon running on a custom domain — This TIL is mainly a rehash of these two articles by Jacob and Andrew:
TIL GitHub Pages: The Missing Manual — [GitHub Pages](https://pages.github.com/) is an excellent free hosting platform, but the documentation is missing out on some crucial details.
TIL The pdb interact command — Today [Carlton told me](https://twitter.com/carltongibson/status/1587155176590385159) about the [interact command](https://docs.python.org/3.10/library/pdb.html#pdbcommand-interact) in the Python debugger.
TIL git bisect — I extracted and enhanced this TIL from [my April 8th 2020 weeknotes](https://simonwillison.net/2020/Apr/8/weeknotes-zeit-now-v2/#git-bisect) to make it easier to find.
Release json-flatten 0.3 — Python functions for flattening a JSON object to a single dictionary of pairs, and unflattening that dictionary back to a JSON object
TIL Finding the SQLite version used by Web SQL in Chrome — Google Chrome still includes support for [Web SQL](https://www.w3.org/TR/webdatabase/), the long since abandoned proposed standard for shipping a SQL engine in browser JavaScript. I was reminded of its existence today while reading about the new official [sqlite3 wasm build](https://sqlite.org/wasm/doc/tip/about.md).
Release datasette-edit-templates 0.1 — Plugin allowing Datasette templates to be edited within Datasette
Release datasette 0.63 — An open source multi-tool for exploring and publishing data

Beats

Years

Tags