Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,015 results
«« first
« previous
page 47 / 101
next »
last »»
TIL
Start, test, then stop a localhost web server in a Bash script
— I wanted to write a bash script that would start a Datasette server running, run a request against it using `curl`, then stop the server again.
Release
datasette-ripgrep 0.8
— Web interface for searching your code using ripgrep, built as a Datasette plugin
TIL
Comparing database rows before and after with SQLite JSON functions
— Here's a trick I've been using to compare the rows in a table before and after I perform an operation against it. It works well for a few hundred (and maybe a few thousand) rows.
TIL
SQLite can use more than one index for a query
— I was trying to figure out if SQLite has the ability to use more than one index as part of executing a single query, or if it only ever picks a single index that it thinks will give the best performance.
TIL
Viewing GeoPackage data with SpatiaLite and Datasette
— I managed to display polygons fom a GeoPackage database file today, using SpatiaLite and Datasette.
TIL
Show files opened by pytest tests
— My test suite for [Datasette](https://github.com/simonw/datasette) has grown so large that running the whole thing sometimes causes me to run out of file handles.
TIL
Reformatting text with Copilot
— I wanted to write alt text for the following screenshot ([of this page]()), so I could include it in [this post on Mastodon](https://fedi.simonwillison.net/@simon/109484810256112309).
TIL
Finding uses of an API with the new GitHub Code Search
— The [GitHub Code Search beta](https://docs.github.com/en/search-github/github-code-search) is really powerful - it allows advanced search - including regular expression matches - against every public repo on GitHub.
TIL
Workaround for google-github-actions/setup-gcloud errors
— I used the [google-github-actions/setup-gcloud](https://github.com/google-github-actions/setup-gcloud) action in all of my GitHub Actions workflows that deploy applications to Cloud Run.
TIL
Using pipenv and Docker
— I had [a Django project](https://github.com/natbat/cbwg) that used `pipenv` (in particular a `Pipfile.lock`) to manage dependencies and I wanted to build a Docker container for it.
TIL
actions/setup-python caching for setup.py projects
— I used to use a combination of `actions/setup-python` and `actions/cache` in all of my Python GitHub Actions projects in order to install Python dependencies via a cache, rather than hitting PyPI to download copies every time.
TIL
Lazy loading images in HTML
— [Most modern browsers](https://caniuse.com/loading-lazy-attr) now include support for the `loading="lazy"` image attribute, which causes images not to be loaded unti the user scrolls them into view.
TIL
Writing a CLI utility that is also a Datasette plugin
— I'm working on [dclient](https://github.com/simonw/dclient), a CLI tool for interacting with Datasette instances via the Datasette API.
«« first
« previous
page 47 / 101
next »
last »»