Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,015 results
«« first
« previous
page 67 / 101
next »
last »»
TIL
Building a Markdown summary of Django group permissions
— [Django SQL Dashboard](https://django-sql-dashboard.datasette.io/) can display rendered markdown generated by a SQL query.
TIL
Finding CSV files that start with a BOM using ripgrep
— For [sqlite-utils issue 250](https://github.com/simonw/sqlite-utils/issues/250) I needed to locate some test CSV files that start with a UTF-8 BOM.
TIL
Running Docker on an M1 Mac
— *TLDR: Use `platform: linux/amd64` in `docker-compose.yml` and your containers will probably work!*
TIL
Docker Compose for Django development
— I had to get Docker Compose working for a Django project, primarily to make it easier for other developers to get a working development environment.
TIL
Finding duplicate records by matching name and nearby distance
— I wanted to find potentially duplicate records in my data, based on having the exact same name and being geographically located within 500 meters of each other.
TIL
Switching between gcloud accounts
— I have two different Google Cloud accounts active at the moment. Here's how to list them with `gcloud auth list`:
TIL
Django data migration using a PostgreSQL CTE
— I figured out how to use a PostgreSQL CTE as part of an update statement in a Django data migration. The trick here is mainly understanding how to combine CTEs with a PostgreSQL update - here's the pattern for that:
TIL
KNN queries with SpatiaLite
— The latest version of SpatiaLite adds KNN support, which makes it easy to efficiently answer the question "what are the X closest records to this point".
TIL
Enabling a gin index for faster LIKE queries
— I tried using a gin index to speed up `LIKE '%term%'` queries against a column.
TIL
Vega-Lite bar charts in the same order as the data
— I've been puzzling over this one for a couple of years now, and I finally figured out the solution.
TIL
The Wikipedia page stats API
— Via https://alexgarcia.xyz/dataflow/examples/wiki-pageviews/ I found this API for retrieving daily pageview stats from Wikipedia for any article:
TIL
Scroll page to form if there are errors
— For a Django application I'm working on ([this issue](https://github.com/simonw/django-sql-dashboard/issues/44)) I have a form that can be quite a long way down the page.
«« first
« previous
page 67 / 101
next »
last »»