Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Release TIL Research Tool Museum Sighting Comment

Filters: Sorted by date

Release sqlite-utils 3.9 — Python CLI utility and library for manipulating SQLite databases
12th Jun 2021, 2:08 am · sqlite, sqlite-utils
Release db-to-sqlite 1.4 — CLI tool for exporting tables or queries from any SQL database to a SQLite file
11th Jun 2021, 10:55 pm
None
TIL Running a MySQL server using Homebrew — First, install MySQL like so:
11th Jun 2021, 6:48 pm
Release datasette-mask-columns 0.2.1 — Datasette plugin that masks specified database columns
10th Jun 2021, 7:51 pm · datasette
Release datasette 0.58a0 — An open source multi-tool for exploring and publishing data
10th Jun 2021, 4:52 am · datasette
Release datasette-placekey 0.1 — SQL functions for working with placekeys
10th Jun 2021, 2:32 am
Release datasette 0.57.1 — An open source multi-tool for exploring and publishing data
8th Jun 2021, 4:28 pm · datasette
Release xml-analyser 1.2 — Simple command line tool for quickly analysing the structure of an arbitrary XML file
7th Jun 2021, 5:28 pm
Release datasette-upload-csvs 0.6.1 — Datasette plugin for uploading CSV files and converting them to database tables
7th Jun 2021, 4:41 pm · datasette
Release xml-analyser 1.1 — Simple command line tool for quickly analysing the structure of an arbitrary XML file
7th Jun 2021, 12:41 am
None
TIL Exporting Amplitude events to SQLite — [Amplitude](https://amplitude.com/) offers an "Export Data" button in the project settings page. This can export up to 365 days of events (up to 4GB per export), where the export is a zip file containing `*.json.gz` gzipped newline-delimited JSON.
6th Jun 2021, 8:56 pm
Release django-sql-dashboard 0.16 — Django app for building dashboards using raw SQL queries
6th Jun 2021, 7:12 pm
Release datasette-auth-passwords 0.4.1 — Datasette plugin for authentication using passwords
5th Jun 2021, 11:39 pm · datasette
Release datasette 0.57 — An open source multi-tool for exploring and publishing data
5th Jun 2021, 10:11 pm · datasette
Release datasette 0.56.1 — An open source multi-tool for exploring and publishing data
5th Jun 2021, 10 pm · datasette
Release django-sql-dashboard 0.15.1 — Django app for building dashboards using raw SQL queries
3rd Jun 2021, 4:27 pm
None
TIL Building a Markdown summary of Django group permissions — [Django SQL Dashboard](https://django-sql-dashboard.datasette.io/) can display rendered markdown generated by a SQL query.
3rd Jun 2021, 4:15 pm
Release sqlite-utils 3.8 — Python CLI utility and library for manipulating SQLite databases
3rd Jun 2021, 5:17 am · sqlite, sqlite-utils
Release sqlite-utils 3.7 — Python CLI utility and library for manipulating SQLite databases
29th May 2021, 5:49 am
None
TIL Finding CSV files that start with a BOM using ripgrep — For [sqlite-utils issue 250](https://github.com/simonw/sqlite-utils/issues/250) I needed to locate some test CSV files that start with a UTF-8 BOM.
29th May 2021, 5:23 am
Release datasette 0.57a1 — An open source multi-tool for exploring and publishing data
27th May 2021, 4:58 pm · datasette
None
TIL Running Docker on an M1 Mac — *TLDR: Use `platform: linux/amd64` in `docker-compose.yml` and your containers will probably work!*
25th May 2021, 11:30 pm
None
TIL Turning an array of arrays into objects with jq — Input:
25th May 2021, 3:33 pm
None
TIL Docker Compose for Django development — I had to get Docker Compose working for a Django project, primarily to make it easier for other developers to get a working development environment.
25th May 2021, 5:08 am
Release django-sql-dashboard 0.15 — Django app for building dashboards using raw SQL queries
25th May 2021, 12:34 am
Release datasette 0.57a0 — An open source multi-tool for exploring and publishing data
23rd May 2021, 12:46 am · datasette
Release geojson-to-sqlite 0.3.1 — CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)
20th May 2021, 7:15 pm
None
TIL Finding duplicate records by matching name and nearby distance — I wanted to find potentially duplicate records in my data, based on having the exact same name and being geographically located within 500 meters of each other.
20th May 2021, 3:52 am
None
TIL Switching between gcloud accounts — I have two different Google Cloud accounts active at the moment. Here's how to list them with `gcloud auth list`:
18th May 2021, 9:35 pm
None
TIL Django data migration using a PostgreSQL CTE — I figured out how to use a PostgreSQL CTE as part of an update statement in a Django data migration. The trick here is mainly understanding how to combine CTEs with a PostgreSQL update - here's the pattern for that:
18th May 2021, 12:04 am

Beats

Years

Tags