Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,015 results
«« first
« previous
page 64 / 101
next »
last »»
TIL
Open external links in an Electron app using the system browser
— For [Datasette.app](https://github.com/simonw/datasette-app) I wanted to ensure that links to external URLs would [open in the system browser](https://github.com/simonw/datasette-app/issues/34).
TIL
Using the Chrome DevTools console as a REPL for an Electron app
— I figured out how to use the Chrome DevTools to execute JavaScript interactively inside the Electron main process. I always like having a REPL for exploring APIs, and this means I can explore the Electron and Node.js APIs interactively.
TIL
Calculating the AQI based on the Purple Air API for a sensor
— [Purple Air](https://www.purpleair.com/) sensors have an API at `https://www.purpleair.com/map.json?show=SENSOR-ID-HERE`, which returns JSON that looks something like this:
TIL
Searching all columns of a table in Datasette
— I came up with this trick today, when I wanted to run a `LIKE` search against every column in a table.
TIL
Histogram with tooltips in Observable Plot
— Given an array of datetime objects, I wanted to plot a histogram. But I wanted to automatically pick a bucket size for that histogram that resulted in something interesting, no matter what range of time the individual points covered.
Release
datasette-block-robots 1.0
— Datasette plugin that blocks robots and crawlers using robots.txt
TIL
Track timestamped changes to a SQLite table using triggers
— This is more of a "today I figured out" than a TIL.
TIL
Building a specific version of SQLite with pysqlite on macOS/Linux
— I wanted the ability to test my Python software against specific version of SQLite on macOS. I found a way to do that using [pysqlite3](https://github.com/coleifer/pysqlite3).
TIL
Adding Sphinx autodoc to a project, and configuring Read The Docs to build it
— I built a [new API reference page](https://sqlite-utils.datasette.io/en/latest/reference.html) today for `sqlite-utils`, using the Sphinx [autodoc extension](https://www.sphinx-doc.org/en/master/usage/extensions/autodoc.html) to extract docstrings from the code and use them to build a full class reference.
TIL
Find local variables in the traceback for an exception
— For [sqlite-utils issue #309](https://github.com/simonw/sqlite-utils/issues/309) I had an error that looked like this:
TIL
Tailing Google Cloud Run request logs and importing them into SQLite
— The `gcloud` CLI tool has [the alpha ability to tail log files](https://cloud.google.com/logging/docs/reference/tools/gcloud-logging#live-tailing) - but it's a bit of a pain to setup.
Release
datasette-query-links 0.1.2
— Turn SELECT queries returned by a query into links to execute them
Release
datasette-query-links 0.1.1
— Turn SELECT queries returned by a query into links to execute them
«« first
« previous
page 64 / 101
next »
last »»