Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,116 results
«« first
« previous
page 52 / 104
next »
last »»
TIL
Generating OpenAPI specifications using GPT-3
— I wanted to start playing around with [OpenAPI](https://www.openapis.org/). I decided to see if I could get GPT-3 to generate the first version of a specification for me.
TIL
Export a Mastodon timeline to SQLite
— I've been playing around with [the Mastodon timelines API](https://docs.joinmastodon.org/methods/timelines/). It's pretty fun!
TIL
Getting Mastodon running on a custom domain
— This TIL is mainly a rehash of these two articles by Jacob and Andrew:
TIL
GitHub Pages: The Missing Manual
— [GitHub Pages](https://pages.github.com/) is an excellent free hosting platform, but the documentation is missing out on some crucial details.
TIL
The pdb interact command
— Today [Carlton told me](https://twitter.com/carltongibson/status/1587155176590385159) about the [interact command](https://docs.python.org/3.10/library/pdb.html#pdbcommand-interact) in the Python debugger.
TIL
git bisect
— I extracted and enhanced this TIL from [my April 8th 2020 weeknotes](https://simonwillison.net/2020/Apr/8/weeknotes-zeit-now-v2/#git-bisect) to make it easier to find.
Release
json-flatten 0.3
— Python functions for flattening a JSON object to a single dictionary of pairs, and unflattening that dictionary back to a JSON object
TIL
Finding the SQLite version used by Web SQL in Chrome
— Google Chrome still includes support for [Web SQL](https://www.w3.org/TR/webdatabase/), the long since abandoned proposed standard for shipping a SQL engine in browser JavaScript. I was reminded of its existence today while reading about the new official [sqlite3 wasm build](https://sqlite.org/wasm/doc/tip/about.md).
Release
datasette-edit-templates 0.1
— Plugin allowing Datasette templates to be edited within Datasette
TIL
os.remove() on Windows fails if the file is already open
— I puzzled over this one for [quite a while](https://github.com/simonw/sqlite-utils/issues/503) this morning. I had this test that was failing with Windows on Python 3.11:
TIL
Writing a Datasette CLI plugin that mostly duplicates an existing command
— My new [datasette-gunicorn](https://datasette.io/plugins/datasette-gunicorn) plugin adds a new command to Datasette - `datasette gunicorn` - which mostly replicates the existing `datasette serve` command but with a few differences.
TIL
Simple load testing with Locust
— I've been using [Locust](https://locust.io/) recently to run some load tests - most significantly [these tests](https://github.com/simonw/django_sqlite_benchmark/issues?q=is%3Aissue+is%3Aclosed) against SQLite running with Django and [this test](https://github.com/simonw/datasette-gunicorn/issues/1) exercising Datasette and Gunicorn.
TIL
Adding a Datasette ASGI app to Django
— [Datasette](https://datasette.io/) is implemented as an ASGI application.
TIL
Guessing Amazon image URLs using GitHub Copilot
— I was experimenting with the new [Readwise export API](https://readwise.io/api_deets#export) and it gave me back the following JSON:
TIL
shot-scraper for a subset of table columns
— For [Datasette issue #1844](https://github.com/simonw/datasette/issues/1844) I wanted to create the following screenshot:
TIL
Using psutil to investigate "Too many open files"
— I was getting this intermittent error running my Datasette test suite:
TIL
Pisco sour
— This classic Peruvian cocktail recipe is particularly useful if you have both a lemon tree and chickens producing fresh eggs!
TIL
Querying newline-delimited JSON logs using AWS Athena
— I've been writing my Fly logs to S3 in newline-delimited JSON format using the recipe described in [Writing Fly logs to S3](https://til.simonwillison.net/fly/fly-logs-to-s3).
«« first
« previous
page 52 / 104
next »
last »»