Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,116 results
«« first
« previous
page 50 / 104
next »
last »»
TIL
Loading SQLite extensions in Python on macOS
— I finally found a workaround for this error when attempting to load a SQLite extension in Python on macOS:
TIL
Geopoly in SQLite
— I noticed this morning that one of my Datasette installations had the [Geopoly](https://www.sqlite.org/geopoly.html) SQLite extension enabled. I don't know how it got there - it has to be compiled specifically - but since it was there I decided to try it out.
TIL
Querying the GitHub archive with the ClickHouse playground
— Via [this comment](https://news.ycombinator.com/item?id=34197637) on Hacker News I started exploring the [ClickHouse Playground](https://clickhouse.com/docs/en/getting-started/playground/). It's really cool, and among other things it allows CORS-enabled API hits that can query a decade of history from the GitHub events archive in less than a second.
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.
«« first
« previous
page 50 / 104
next »
last »»