Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

None
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
None
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
None
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
None
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.
None
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
None
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.
None
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:
Sighting 10:43 PM — California Sea Lion, in San Francisco County, US, CA
California Sea Lion
California Sea Lion
Sighting 10:42 PM — American Crow, in San Francisco County, US, CA
American Crow
American Crow
American Crow
American Crow
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
Release sqlite-utils 2.7.2 — Python CLI utility and library for manipulating SQLite databases
Release datasette-render-markdown 1.1.2 — Datasette plugin for rendering Markdown
None
TIL Constant-time comparison of strings in Node — When comparing secrets, passwords etc it's important to use a constant-time compare function to avoid timing attacks.
Release sqlite-utils 2.7.1 — Python CLI utility and library for manipulating SQLite databases
Release github-to-sqlite 2.1 — Save data from GitHub to a SQLite database
None
TIL Accessing repository dependencies in the GitHub GraphQL API — [Access to a Repositories Dependency Graph](https://developer.github.com/v4/previews/#access-to-a-repositories-dependency-graph) describes a preview API for accessing GitHub repository dependencies.