Migrating a GitHub wiki from one repository to another
I figured out how to migrate a [GitHub wiki](https://docs.github.com/en/communities/documenting-your-project-with-wikis/about-wikis) (public or pri...
123 words
|
1 minute
Using nginx to proxy to a Unix domain socket
I figured this out while adding `--uds` support to Datasette in [#1388](https://github.com/simonw/datasette/issues/1388). Save the following in `ng...
120 words
|
1 minute
The simplest recursive CTE
I found this really simple recursive CTE useful for ensuring I understood how to write recursive CTEs.
229 words
|
1 minute
Show the SQL schema for a PostgreSQL database
This took me longer to figure out than I care to admit.
63 words
|
1 minute
Streaming indented output of a JSON array
I wanted to produce the following output from a command-line tool:
199 words
|
1 minute
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.
658 words
|
3 minutes
Comparing two training datasets using sqlite-utils
[WizardLM](https://github.com/nlpxucan/WizardLM) is "an Instruction-following LLM Using Evol-Instruct". It's a fine-tuned model on top of Meta's LL...
893 words
|
4 minutes
Using pytest-django with a reusable Django application
I published a reusable Django application today: **[django-http-debug](https://github.com/simonw/django-http-debug)**, which lets you define mock H...
744 words
|
4 minutes
Collecting replies to tweets using JavaScript
I ran [a survey](https://twitter.com/simonw/status/1843290729260703801) on Twitter the other day to try and figure out what people mean when they u...
532 words
|
3 minutes
Downloading MapZen elevation tiles
[Via Tony Hirst](https://twitter.com/psychemedia/status/1357280624319553537) I found out about [MapZen's elevation tiles](https://www.mapzen.com/bl...
69 words
|
1 minute
Running jupyterlab via uv tool install
I tried to get [jupyterlab](https://jupyter.org/install) working via `uv tool install` today and ran into some sharp edges.
231 words
|
1 minute
Installing different PostgreSQL server versions in GitHub Actions
The GitHub Actions `ubuntu-latest` default runner currently includes an installation of PostgreSQL 13. The server is not running by default but you...
224 words
|
1 minute
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...
390 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...
654 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.
306 words
|
2 minutes
Configuring Dependabot for a Python project
GitHub's Dependabot can automatically file PRs with bumps to dependencies when new versions of them are available.
142 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...
160 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.
394 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...
310 words
|
2 minutes
From NeoVim to LunarVim
Guide for transitioning from NeoVim to LunarVim, an IDE layer for Neovim.
656 words
|
3 minutes
vsFTP on Ubuntu
Guide for setting up vsFTP on Ubuntu.
216 words
|
1 minute
Windows Control
Venting frustrations and providing solutions for managing Windows features.
204 words
|
1 minute
Getting Started with Windows Server 2019
A guide to getting started with Windows Server 2019, including setting up user accounts, an IIS web server, and adding a static website.
350 words
|
2 minutes
Elgato on Archlinux
Guide on setting up the Elgato Streamdeck on Arch Linux, including installing necessary packages, configuring the environment, and accessing Elgato devices.
160 words
|
1 minute