Flattening nested JSON objects with jq
I wanted to take a nested set of JSON objects and import them into a SQLite database using `sqlite-utils insert` - but I wanted to "flatten" some o...
367 words
|
2 minutes
Serving a JavaScript project built using Vite from GitHub Pages
I figured out how to serve a JavaScript project built using [Vite](https://vitejs.dev/) using GitHub Pages and a custom build script that runs usin...
597 words
|
3 minutes
Loading radio.garden into SQLite using jq
http://radio.garden/ is an amazing website which displays a 3D globe covered in radio stations and lets you listen to any of them.
292 words
|
1 minute
Configuring Dependabot for a Python project
GitHub's Dependabot can automatically file PRs with bumps to dependencies when new versions of them are available.
131 words
|
1 minute
Reusing an existing Click tool with register_commands
The [register_commands](https://docs.datasette.io/en/stable/plugin_hooks.html#register-commands-cli) plugin hook lets you add extra sub-commands to...
142 words
|
1 minute
Controlling the style of dumped YAML using PyYAML
I had a list of Python dictionaries I wanted to output as YAML, but I wanted to control the style of the output.
370 words
|
2 minutes
Running tests against multiple versions of a Python dependency in GitHub Actions
My [datasette-export-notebook](https://github.com/simonw/datasette-export-notebook) plugin worked fine in the stable release of Datasette, currentl...
283 words
|
1 minute
Upgrading Python Homebrew packages using pip
[VisiData 2.0](https://www.visidata.org/) came out today. I previously installed VisiData using Homebrew, but the VisiData tap has not yet been upd...
99 words
|
1 minute