Copy tables between SQLite databases
I figured out a pattern for doing this today using the `sqlite3` CLI tool - given two SQLite databases in the current folder, called `tils.db` and ...
98 words
|
1 minute
Seeing files opened by a process using opensnoop
I decided to try out [atuin](https://github.com/ellie/atuin?utm_source=tldrnewsletter), a shell extension that writes your history to a SQLite data...
248 words
|
1 minute
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