Elsewhere

TIL Using the sqlite3 Python module in Pyodide - Python WebAssembly — [Pyodide](https://github.com/pyodide/pyodide) provides "Python with the scientific stack, compiled to WebAssembly" - it's an incredible project which lets you run a full working Jupyter notebook, complete with complex packages such as numpy and pandas, entirely in your browser without any server-side Python component running at all.

18th Oct 2021, 6:04 pm

Release datasette-statistics 0.2 — SQL statistics functions for Datasette

15th Oct 2021, 6:47 pm · datasette

Release datasette-auth-tokens 0.3 — Datasette plugin for authenticating access using API tokens

15th Oct 2021, 12:54 am · datasette

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

14th Oct 2021, 7:31 pm · datasette

TIL Using Fabric with an SSH public key — Inspired by [this tweet](https://twitter.com/driscollis/status/1445772718507376646) by Mike Driscoll I decided to try using Fabric to run commands over SSH from a Python script, using a public key for authentication.

6th Oct 2021, 6:22 pm

Release datasette-template-request 0.1 — Expose the Datasette request object to custom templates

23rd Sep 2021, 5:29 pm · datasette

Release datasette-notebook 0.1a1 — A markdown wiki and dashboarding system for Datasette

22nd Sep 2021, 11:59 pm · datasette

Release datasette-notebook 0.1a0 — A markdown wiki and dashboarding system for Datasette

22nd Sep 2021, 11:35 pm · datasette

Release datasette-render-markdown 2.0 — Datasette plugin for rendering Markdown

22nd Sep 2021, 10:18 pm · datasette

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

22nd Sep 2021, 8:51 pm · sqlite, sqlite-utils

TIL Loading lit from Skypack — [Lit 2](https://lit.dev/blog/2021-09-21-announcing-lit-2/) stable was released today, offering a tiny, feature-full framework for constructing web components using modern JavaScript.

22nd Sep 2021, 1:03 am

Release twitter-to-sqlite 0.22 — Save data from Twitter to a SQLite database

21st Sep 2021, 5:41 pm

TIL Publishing to a public Google Cloud bucket with gsutil — I decided to publish static CSV files to accompany my https://cdc-vaccination-history.datasette.io/ project, using a Google Cloud bucket (see [cdc-vaccination-history issue #9](https://github.com/simonw/cdc-vaccination-history/issues/9)).

20th Sep 2021, 8:13 pm

Release datasette-statistics 0.1.1 — SQL statistics functions for Datasette

16th Sep 2021, 3:21 am · datasette

Release datasette-statistics 0.1 — SQL statistics functions for Datasette

16th Sep 2021, 3:08 am · datasette

Release json-flatten 0.2 — Python functions for flattening a JSON object to a single dictionary of pairs, and unflattening that dictionary back to a JSON object

14th Sep 2021, 8:27 pm

TIL Configuring auto-update for an Electron app — This is _almost_ really simple. I used [electron/update-electron-app](https://github.com/electron/update-electron-app) for it, the instructions for which are:

14th Sep 2021, 3:57 am

Release datasette-app 0.2.1 — The Datasette macOS application

13th Sep 2021, 11:20 pm · datasette

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

13th Sep 2021, 8:14 pm · datasette

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

13th Sep 2021, 7 pm · datasette

TIL Cumulative total over time in SQL — This is a quick trick for creating a cumulative chart of the total number of items created over time based just on their creation date.

13th Sep 2021, 3:33 pm

Release datasette-app 0.2.0 — The Datasette macOS application

13th Sep 2021, 12:54 am · datasette

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

13th Sep 2021, 12:40 am · datasette

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

12th Sep 2021, 11:51 pm · datasette

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

12th Sep 2021, 11:40 pm · datasette

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

12th Sep 2021, 9:59 pm · datasette

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

12th Sep 2021, 8:21 pm · datasette

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

11th Sep 2021, 11:07 pm · datasette

Release datasette-write 0.2 — Datasette plugin providing a UI for executing SQL writes against the database

11th Sep 2021, 6:03 am · datasette

Release datasette-schema-versions 0.2 — Datasette plugin that shows the schema version of every attached database

11th Sep 2021, 2:44 am · datasette

Simon Willison’s Weblog

Elsewhere

Beats

Years

Tags