Elsewhere

TIL Using boto3 from the command line — I found a useful pattern today for automating more complex AWS processes as pastable command line snippets, using [Boto3](https://aws.amazon.com/sdk-for-python/).

3rd Aug 2022, 3:34 am

Release shot-scraper 0.14.3 — A command-line utility for taking automated screenshots of websites

2nd Aug 2022, 11:41 pm

Release s3-credentials 0.12.1 — A tool for creating credentials for accessing S3 buckets

1st Aug 2022, 7:50 pm

TIL Related content with SQLite FTS and a Datasette template function — Today I added "related TILs" to this TIL website - so each TIL now shows five related TILs at the bottom of the page.

1st Aug 2022, 12:53 am

Release datasette-sqlite-fts4 0.3.2 — Datasette plugin that adds custom SQL functions for working with SQLite FTS4

31st Jul 2022, 2:46 pm · datasette

TIL Emulating a big-endian s390x with QEMU — I got [a bug report](https://github.com/simonw/sqlite-fts4/issues/6) concerning my [sqlite-fts4](https://github.com/simonw/sqlite-fts4) project running on PPC64 and s390x architectures.

30th Jul 2022, 2:44 am

Release sqlite-fts4 1.0.3 — Custom Python functions for working with SQLite FTS4

30th Jul 2022, 1:13 am

TIL Migrating a GitHub wiki from one repository to another — I figured out how to migrate a [GitHub wiki](https://docs.github.com/en/communities/documenting-your-project-with-wikis/about-wikis) (public or private) from one repository to another while preserving all history.

28th Jul 2022, 8:08 pm

Release shot-scraper 0.14.2 — A command-line utility for taking automated screenshots of websites

28th Jul 2022, 6:32 pm

Release datasette-sqlite-fts4 0.3.1 — Datasette plugin that adds custom SQL functions for working with SQLite FTS4

28th Jul 2022, 4:47 pm · datasette

TIL struct endianness in Python — TIL the Python standard library [struct](https://docs.python.org/3/library/struct.html) module defaults to interpreting binary strings using the endianness of your machine.

28th Jul 2022, 3:48 pm

Release sqlite-fts4 1.0.2 — Custom Python functions for working with SQLite FTS4

28th Jul 2022, 3:33 pm

TIL Testing things in Fedora using Docker — I got [a report](https://twitter.com/peterjanes/status/1552407491819884544) of a bug with my [s3-ocr tool](https://simonwillison.net/2022/Jun/30/s3-ocr/) running on Fedora.

27th Jul 2022, 10:41 pm

TIL Deploying a redbean app to Fly — [redbean](https://redbean.dev/) is a fascinating project - it provides a web server in a self-contained executable which you can add assets (or dynamic Lua code) to just by zipping them into the same binary package.

25th Jul 2022, 12:46 am

TIL Using pytest and Playwright to test a JavaScript web application — I [decided to add](https://github.com/simonw/datasette-lite/issues/35) automated tests to my [Datasette Lite](https://simonwillison.net/2022/May/4/datasette-lite/) project. Datasette Lite bundles my Datasette Python web application as a client-side application running inside WebAssembly using Pyodide.

24th Jul 2022, 6:47 pm

Release datasette-publish-vercel 0.14.1 — Datasette plugin for publishing data using Vercel

23rd Jul 2022, 2:58 am · datasette

Release datasette-insert 0.8 — Datasette plugin for inserting and updating data

22nd Jul 2022, 5:52 pm · datasette

Release s3-ocr 0.5 — Tools for running OCR against files stored in S3

19th Jul 2022, 2:35 am

Release datasette-graphql 2.1.1 — Datasette plugin providing an automatic GraphQL API for your SQLite databases

18th Jul 2022, 9:13 pm · datasette

Release datasette-sentry 0.2a0 — Datasette plugin for configuring Sentry

18th Jul 2022, 8:30 pm · datasette

Release datasette 0.62a1 — An open source multi-tool for exploring and publishing data

18th Jul 2022, 1:09 am · datasette

Release sqlite-utils 3.28 — Python CLI utility and library for manipulating SQLite databases

15th Jul 2022, 11:02 pm · sqlite, sqlite-utils

TIL Freezing requirements with pip-tools — I tried [pip-tools](https://github.com/jazzband/pip-tools) for the first time today to pin the requirements for the [natbat/pillarpointstewards](https://github.com/natbat/pillarpointstewards) Django app.

14th Jul 2022, 6:22 pm

TIL Testing Electron apps with Playwright and GitHub Actions — Yesterday [I figured out (issue 133)](https://github.com/simonw/datasette-app/issues/133) how to use Playwright to run tests against my Electron app, and then execute those tests in CI using GitHub Actions, for my [datasett-app](https://github.com/simonw/datasette-app) repo for my [Datasette Desktop](https://datasette.io/desktop) macOS application.

13th Jul 2022, 10:29 pm

Release datasette-publish-vercel 0.14 — Datasette plugin for publishing data using Vercel

13th Jul 2022, 3:48 pm · datasette

TIL Upgrading packages with npm — There's a new version of [Vite](https://vitejs.dev/) out (3.0) and I wanted to upgrade my [datasette-table](https://github.com/simonw/datasette-table) package to use it.

13th Jul 2022, 3:04 pm

Release datasette-app 0.2.2 — The Datasette macOS application

13th Jul 2022, 1:08 am · datasette

Release datasette-app-support 0.11.6 — Part of https://github.com/simonw/datasette-app

12th Jul 2022, 7:30 pm · datasette

Release sqlite-comprehend 0.2.2 — Tools for running data in a SQLite database through AWS Comprehend

12th Jul 2022, 2:21 pm

Release datasette-ics 0.5.2 — Datasette plugin for outputting iCalendar files

12th Jul 2022, 2:08 am · datasette

Simon Willison’s Weblog

Elsewhere

Beats

Years

Tags