Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release asgi-csrf 0.3.1 — ASGI middleware for protecting against CSRF attacks
Release asgi-csrf 0.3 — ASGI middleware for protecting against CSRF attacks
Release datasette-ics 0.4 — Datasette plugin for outputting iCalendar files
Release db-to-sqlite 1.2.1 — CLI tool for exporting tables or queries from any SQL database to a SQLite file
Release db-to-sqlite 1.2 — CLI tool for exporting tables or queries from any SQL database to a SQLite file
Release datasette-atom 0.6 — Datasette plugin that adds a .atom output format
TIL Asserting a dictionary is a subset of another dictionary — My [lazy approach to writing unit tests](https://simonwillison.net/2020/Feb/11/cheating-at-unit-tests-pytest-black/) means that sometimes I want to run an assertion against most (but not all) of a dictionary.
Release datasette 0.43 — An open source multi-tool for exploring and publishing data
TIL Introspecting Python function parameters — For https://github.com/simonw/datasette/issues/581 I want to be able to inspect a Python function to determine which named parameters it accepts and send only those arguments.
Release dogsheep-photos 0.4.1 — Upload your photos to S3 and import metadata about them into a SQLite database
Release datasette-cluster-map 0.10 — Datasette plugin that shows a map for any data with latitude/longitude columns
Release dogsheep-photos 0.4 — Upload your photos to S3 and import metadata about them into a SQLite database
Release datasette-media 0.2 — Datasette plugin for serving media based on a SQL query
Release sqlite-utils 2.9.1 — Python CLI utility and library for manipulating SQLite databases
TIL Adding project links to PyPI — I spotted a neat looking project links section on https://pypi.org/project/ExifReader/
Release sqlite-utils 2.9 — Python CLI utility and library for manipulating SQLite databases
TIL Converting HTML and rich-text to Markdown — If you copy and paste from a web page - including a full table - into a GitHub issue comment GitHub converts it to the corresponding Markdown for you. Really quick way to construct Markdown tables.
Release datasette-media 0.1 — Datasette plugin for serving media based on a SQL query
Release datasette 0.42 — An open source multi-tool for exploring and publishing data
Release datasette-media 0.1a — Datasette plugin for serving media based on a SQL query
Release datasette-publish-vercel 0.5.1 — Datasette plugin for publishing data using Vercel
Release datasette 0.41 — An open source multi-tool for exploring and publishing data
TIL List all columns in a SQLite database — Here's a devious trick for listing ALL columns in a SQLite database, using a SQL query that generates another SQL query.
TIL Use setup.py to install platform-specific dependencies — For [photos-to-sqlite](https://github.com/dogsheep/photos-to-sqlite) I needed to install `osxphotos` as a dependency, but only if the platform is macOS - it's not available for Linux.
Release dogsheep-photos 0.3a — Upload your photos to S3 and import metadata about them into a SQLite database
TIL Search across all loaded resources in Firefox — You can search for a string in any resource loaded by a page (including across HTML, JavaScript and CSS) in the Debugger pane by hitting Command+Shift+F.
TIL Installing and upgrading Datasette plugins with pipx — If you installed `datasette` using `pipx install datasette` you can install additional plugins with `pipx inject` like so:
Release sqlite-utils 2.8 — Python CLI utility and library for manipulating SQLite databases
Release github-to-sqlite 2.2 — Save data from GitHub to a SQLite database

Beats

Years

Tags