Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,015 results
«« first
« previous
page 69 / 101
next »
last »»
Release
datasette-publish-azure 0.1a0
— Publish Datasette instances to Azure Functions (in progress)
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/)
Release
hacker-news-to-sqlite 0.4
— Create a SQLite database containing data pulled from Hacker News
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.
«« first
« previous
page 69 / 101
next »
last »»