Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release sqlite-utils 3.27 — Python CLI utility and library for manipulating SQLite databases
TIL Using iconv to convert the text encoding of a file — In [sqlite-utils issue 439](https://github.com/simonw/sqlite-utils/issues/439) I was testing against a CSV file that used UTF16 little endian encoding, also known as `utf-16-le`.
Release datasette-low-disk-space-hook 0.1a0 — Datasette plugin providing the low_disk_space hook for other plugins to check for low disk space
Release datasette-socrata 0.2 — Import data from Socrata into Datasette
Release datasette-ics 0.5.1 — Datasette plugin for outputting iCalendar files
Release datasette-socrata 0.1.1 — Import data from Socrata into Datasette
Release datasette-socrata 0.1 — Import data from Socrata into Datasette
Release datasette-upload-csvs 0.7.1 — Datasette plugin for uploading CSV files and converting them to database tables
TIL Formatting thousands in Jinja — Here's how to format a number in Jinja with commas for thousands, without needing any custom filters or template functions:
TIL Making HTTP calls using IPv6 — Tiny TIL today: I learned how to make an HTTP call to an IPv6 address. The trick is to enclose the address in the URL in square braces:
TIL Using just with Django — Jeff Triplett [convinced me](https://twitter.com/webology/status/1532860591307726851) to take a look at [just](https://github.com/casey/just) as a command automation tool - sort of an alternative to Make, except with a focus on commands rather than managing build dependencies.
Release datasette-upload-csvs 0.7 — Datasette plugin for uploading CSV files and converting them to database tables
Release mbox-to-sqlite 0.1a0 — Load email from .mbox files into SQLite
Release datasette-graphql 2.0.2 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-auth-existing-cookies 1.0a1 — Datasette plugin that authenticates users based on existing domain cookies
Release datasette-auth-existing-cookies 1.0a0 — Datasette plugin that authenticates users based on existing domain cookies
TIL Wildcard DNS and SSL on Fly — [Fly](https://fly.io/) makes it surprisingly easy to configure wildcard DNS, such that `anything.your-new-domain.dev` is served by a single Fly application (which can include multiple instances in multiple regions with global load-balancing).
TIL Writing Fly logs to S3 — [Fly](https://fly.io/) offers [fly-log-shipper](https://github.com/superfly/fly-log-shipper) as a container you can run in a Fly application to send all of the logs from your other applications to a logging provider.
Release datasette-unsafe-expose-env 0.1 — Datasette plugin to expose some environment variables at /-/env for debugging
Release shot-scraper 0.14.1 — A command-line utility for taking automated screenshots of websites
TIL Using the Fly Docker registry — [Fly.io](https://fly.io/) lets you deploy Docker containers that will be compiled as a Firecracker VM and run in locations around the world.
Release google-calendar-to-sqlite 0.1a0 — Create a SQLite database containing your data from Google Calendar
Release shot-scraper 0.14 — A command-line utility for taking automated screenshots of websites
TIL Optimizing PNGs in GitHub Actions using Oxipng — My [datasette-screenshots](https://github.com/simonw/datasette-screenshots) repository generates screenshots of [Datasette](https://datasette.io/) using my [shot-scraper](https://github.com/simonw/shot-scraper) tool, for people who need them for articles or similar.
TIL GitHub Actions job summaries — New feature [announced here](https://github.blog/2022-05-09-supercharging-github-actions-with-job-summaries/). Here's the [full documentation](https://docs.github.com/en/actions/using-workflows/workflow-commands-for-github-actions#adding-a-job-summary).
Release datasette-upload-dbs 0.1.1 — Upload SQLite database files to Datasette
Release datasette-upload-dbs 0.1 — Upload SQLite database files to Datasette
Release datasette-insert 0.7 — Datasette plugin for inserting and updating data
TIL Efficiently copying a file — **TLDR:** Use `shutil.copyfileobj(fsrc, fdst)`

Beats

Years

Tags