Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Release TIL Research Tool Museum

Filters: Sorted by date

TIL Installing lxml for Python on an M1/M2 Mac — I ran into this error while trying to run `pip install lxml` on an M2 Mac, inside a virtual environment I had intitially created using `pipenv shell`:
28th Jan 2023, 6:58 am
TIL SQLite pragma_function_list() — The SQLite `pragma_function_list()` table-valued function returns a list of functions that have been registered with SQLite, including functions that were added by extensions.
28th Jan 2023, 3:06 am
Release datasette-render-markdown 2.1.1 — Datasette plugin for rendering Markdown
27th Jan 2023, 11:31 pm · datasette
Release datasette-youtube-embed 0.1 — Turn YouTube URLs into embedded players in Datasette
27th Jan 2023, 8:09 pm · datasette
TIL Rewriting a Git repo to remove secrets from the history — I decided to make a GitHub repository public today that had previously been private. Unfortunately the revision history of that repository included some secret values, one of which I could not figure out a way to revoke.
25th Jan 2023, 1:26 am
Release datasette-granian 0.1a0 — Run Datasette using the Granian HTTP server
20th Jan 2023, 1:50 am · datasette
Release datasette-faiss 0.2 — Maintain a FAISS index for specified Datasette tables
19th Jan 2023, 11:37 pm · datasette
Release datasette-openai 0.2 — SQL functions for calling OpenAI APIs
14th Jan 2023, 2:28 am
Release openai-to-sqlite 0.2 — Save OpenAI API results to a SQLite database
13th Jan 2023, 4:59 pm
Release datasette-cookies-for-magic-parameters 0.1.2 — UI for setting cookies to populate magic parameters
12th Jan 2023, 7:04 pm · datasette
Release datasette-openai 0.1a2 — SQL functions for calling OpenAI APIs
12th Jan 2023, 6:16 pm
Release datasette-cookies-for-magic-parameters 0.1.1 — UI for setting cookies to populate magic parameters
11th Jan 2023, 11:42 pm · datasette
Release datasette-cookies-for-magic-parameters 0.1 — UI for setting cookies to populate magic parameters
11th Jan 2023, 10:52 pm · datasette
TIL Upgrading a pipx application to an alpha version — I wanted to upgrade my [git-history](https://datasette.io/tools/git-history) installation to a new alpha version.
11th Jan 2023, 8:19 pm
Release git-history 0.7a0 — Tools for analyzing Git history using SQLite
11th Jan 2023, 8:13 pm
Release datasette 0.64.1 — An open source multi-tool for exploring and publishing data
11th Jan 2023, 6:27 pm · datasette
Release datasette-faiss 0.1a0 — Maintain a FAISS index for specified Datasette tables
11th Jan 2023, 5:25 am · datasette
TIL Scraping the Sky News Westminster Accounts, a Flourish application — Sky News in partnership with [Tortoise](https://www.tortoisemedia.com/) published a fantastic piece of investigative data reporting: [the Westminster Accounts](https://news.sky.com/story/westminster-accounts-methodology-12764656), a database of money in UK politics that brought together data from three different sources and make it explorable.
10th Jan 2023, 8:31 pm
Release json-to-files 0.1 — Create separate files on disk based on a JSON object
10th Jan 2023, 8:12 pm
Release datasette-openai 0.1a1 — SQL functions for calling OpenAI APIs
10th Jan 2023, 6:23 pm
Release datasette-auth-passwords 1.1 — Datasette plugin for authentication using passwords
9th Jan 2023, 8:53 pm · datasette
Release datasette 0.64 — An open source multi-tool for exploring and publishing data
9th Jan 2023, 4:49 pm · datasette
Release datasette-publish-fly 1.3 — Datasette plugin for publishing data using Fly
9th Jan 2023, 2:16 am · datasette
Release shapefile-to-sqlite 0.4.2 — Load shapefiles into a SQLite (optionally SpatiaLite) database
8th Jan 2023, 8:24 pm
TIL Loading SQLite extensions in Python on macOS — I finally found a workaround for this error when attempting to load a SQLite extension in Python on macOS:
8th Jan 2023, 12:17 am
TIL Geopoly in SQLite — I noticed this morning that one of my Datasette installations had the [Geopoly](https://www.sqlite.org/geopoly.html) SQLite extension enabled. I don't know how it got there - it has to be compiled specifically - but since it was there I decided to try it out.
4th Jan 2023, 5:52 pm
Release datasette-openai 0.1a0 — SQL functions for calling OpenAI APIs
3rd Jan 2023, 7:17 pm
Release openai-to-sqlite 0.1a0 — Save OpenAI API results to a SQLite database
3rd Jan 2023, 1:24 am
TIL Breakfast tacos with eggs, vegetarian sausages and avocado sauce — Ingredients (serves 2)
2nd Jan 2023, 5:03 pm
TIL Querying the GitHub archive with the ClickHouse playground — Via [this comment](https://news.ycombinator.com/item?id=34197637) on Hacker News I started exploring the [ClickHouse Playground](https://clickhouse.com/docs/en/getting-started/playground/). It's really cool, and among other things it allows CORS-enabled API hits that can query a decade of history from the GitHub events archive in less than a second.
1st Jan 2023, 5:06 am

Beats

Years

Tags