Intercepting fetch in a service worker
I'm learning service workers. I wanted to start with one that intercepts calls to a `/path` and returns "Hello World".
245 words
|
1 minute
Combining CTEs and VALUES in SQLite
Here's how to use SQLite's `VALUES` syntax with a CTE to create a temporary table that you can then perform joins against in a query:
124 words
|
1 minute
Extracting web page content using Readability.js and shot-scraper
[Readability.js](https://github.com/mozilla/readability) is "A standalone version of the readability library used for Firefox Reader View".
451 words
|
2 minutes
Generating a calendar week grid with the Python Calendar module
I needed to generate a grid calendar that looks like this (design [by Natalie Downe](https://github.com/natbat/pillarpointstewards/issues/23)):
166 words
|
1 minute
Combined release notes from GitHub with jq and paginate-json
Matt Holt [asked](https://twitter.com/mholt6/status/1690177417393135616):
732 words
|
4 minutes
Splitting on commas in SQLite
I had an input string in `x,y,z` format and I needed to split it into three separate values in SQLite. I managed to do it using a confusing combina...
110 words
|
1 minute
Geospatial SQL queries in SQLite using TG, sqlite-tg and datasette-sqlite-tg
[TG](https://github.com/tidwall/tg) is an exciting new project in the world of open source geospatial libraries. It's a single C file (an amalgamat...
815 words
|
4 minutes
Calculating embeddings with gtr-t5-large in Python
I've long wanted to run some kind of large language model on my own computer. Now that I have a M2 MacBook Pro I'm even more keen to find interesti...
1055 words
|
5 minutes