TILs
Filters: Sorted by date
576 results
«« first
« previous
page 15 / 20
next »
last »»
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.
TIL
migrations.RunSQL.noop for reversible SQL migrations
— `migrations.RunSQL.noop` provides an easy way to create "reversible" Django SQL migrations, where the reverse operation does nothing (but keeps it possible to reverse back to a previous migration state without being blocked by an irreversible migration).
TIL
Django Admin action for exporting selected rows as CSV
— I wanted to add an action option to the Django Admin for exporting the currently selected set of rows (or every row in the table) as a CSV file.
TIL
Constructing GeoJSON in PostgreSQL
— In order to efficiently generate a GeoJSON representation of a vast number of locations, I'm currently experimenting with generating the GeoJSON directly inside a PostgreSQL SQL query using `json_build_object()` and friends.
TIL
Filter by comma-separated values in the Django admin
— I have a text column which contains comma-separated values - inherited from an older database schema.
TIL
Usable horizontal scrollbars in the Django admin for mouse users
— I got a complaint from a Windows-with-mouse user of a Django admin project I'm working on: they couldn't see the right hand columns in a table without scrolling horizontally, but since the horizontal scrollbar was only available at the bottom of the page they had to scroll all the way to the bottom first in order to scroll sideways.
TIL
Enabling the fuzzystrmatch extension in PostgreSQL with a Django migration
— The PostgreSQL [fuzzystrmatch extension](https://www.postgresql.org/docs/13/fuzzystrmatch.html) enables several functions for fuzzy string matching: `soundex()`, `difference()`, `levenshtein()`, `levenshtein_less_equal()`, `metaphone()`, `dmetaphone()` and `dmetaphone_alt()`.
TIL
Listing files uploaded to Cloud Build
— Today while running `datasette publish cloudrun ...` I noticed the following:
TIL
Using json_extract_path in PostgreSQL
— The `json_extract_path()` function in PostgreSQL can be used to extract specific items from JSON - but I couldn't find documentation for the path language it uses.
TIL
Using unnest() to use a comma-separated string as the input to an IN query
— [django-sql-dashboard](https://github.com/simonw/django-sql-dashboard) lets you define a SQL query plus one or more text inputs that the user can provide in order to execute the query.
TIL
Efficient bulk deletions in Django
— I needed to bulk-delete a large number of objects today. Django deletions are relatively inefficient by default, because Django implements its own version of cascading deletions and fires signals for each deleted object.
TIL
Language-specific indentation settings in VS Code
— When I'm working with Python I like four space indents, but for JavaScript or HTML I like two space indents.
TIL
Useful Markdown extensions in Python
— I wanted to render some markdown in Python but with the following extra features:
TIL
Writing an Azure Function that serves all traffic to a subdomain
— [Azure Functions](https://docs.microsoft.com/en-us/azure/azure-functions/) default to serving traffic from a path like `/api/FunctionName` - for example `https://your-subdomain.azurewebsites.net/api/MyFunction`.
TIL
Redirecting all paths on a Vercel instance
— I wanted to redirect all traffic to `https://something.vercel.app/` to a different domain - preserving the path and the querystring and serving a 301 status code.
TIL
Closest locations to a point
— Here's a PostgreSQL SQL query that returns the closest locations to a point, based on a brute-force approach where the database calculates the distance (in miles) to every single row and then sorts by that distance.
TIL
Installing packages from Debian unstable in a Docker image based on stable
— For [Datasette #1249](https://github.com/simonw/datasette/issues/1249) I wanted to build a Docker image from the `python:3.9.2-slim-buster` base image ("buster" is the current stable release of Debian) but include a single package from "sid", the unstable Debian distribution.
TIL
Tracing every executed Python statement
— Today I learned how to use the Python [trace module](https://docs.python.org/3/library/trace.html) to output every single executed line of Python code in a program - useful for figuring out exactly when a crash or infinite loop happens.
TIL
Running gdb against a Python process in a running Docker container
— While investigating [Datasette issue #1268](https://github.com/simonw/datasette/issues/1268) I found myself with a Python process that was hanging, and I decided to try running `gdb` against it based on tips in [Debugging of CPython processes with gdb](https://www.podoliaka.org/2016/04/10/debugging-cpython-gdb/)
TIL
Querying for items stored in UTC that were created on a Thursday in PST
— This came up as [a question](https://news.ycombinator.com/item?id=26443148) on Hacker News. How can you query a SQLite database for items that were created on a Thursday in PST, when the data is stored in UTC?
TIL
Querying for GitHub issues open for less than 60 seconds
— While [writing this thread](https://twitter.com/simonw/status/1370390336514658310) about my habit of opening issues and closing them a few seconds later just so I could link to them in a commit message I decided to answer the question "How many of my issues were open for less than 60 seconds?"
TIL
How to almost get facet counts in the Django admin
— For a tantalizing moment today I thought I'd found a recipe for adding facet counts to the Django admin.
TIL
Converting no-decimal-point latitudes and longitudes using jq
— I had some data with weird co-ordinates in it:
«« first
« previous
page 15 / 20
next »
last »»