Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,116 results
«« first
« previous
page 68 / 104
next »
last »»
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
Release
datasette-query-links 0.1
— Turn SELECT queries returned by a query into links to execute them
TIL
SQLite aggregate filter clauses
— SQLite supports aggregate filter clauses (as of [3.30.0, released 2019-10-04](https://www.sqlite.org/changes.html#version_3_30_0)), as described in this [SQL Pivot in all databases](https://modern-sql.com/use-case/pivot) tutorial.
TIL
Set a GIF to loop using ImageMagick
— I managed to accidentally create a GIF that ran once without looping. I think this is because I created it in [LICEcap](https://www.cockos.com/licecap/) but then deleted some frames and re-saved it using macOS Preview.
TIL
Check spelling using codespell
— Today I discovered [codespell](https://github.com/codespell-project/codespell/) via [this Rich commit](https://github.com/willmcgugan/rich/commit/9c12a4537499797c43725fff5276ef0da62423ef#diff-ce84a1b2c9eb4ab3ea22f610cad7111cb9a2f66365c3b24679901376a2a73ab2). `codespell` is a really simple spell checker that can be run locally or incorporated into a CI flow.
TIL
Search and replace with regular expressions in VS Code
— I wanted to replace all instances of this:
Release
datasette-haversine 0.2
— Datasette plugin that adds a custom SQL function for haversine distances
TIL
Extracting objects recursively with jq
— The Algolia-powered Hacker News API returns nested comment threads that look like this: https://hn.algolia.com/api/v1/items/27941108
«« first
« previous
page 68 / 104
next »
last »»