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
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...
110 words
|
1 minute
Adding Sphinx autodoc to a project, and configuring Read The Docs to build it
I built a [new API reference page](https://sqlite-utils.datasette.io/en/latest/reference.html) today for `sqlite-utils`, using the Sphinx [autodoc ...
910 words
|
5 minutes
nullglob in bash
I ran into a tricky problem while working [on this issue](https://github.com/simonw/datasette-publish-fly/issues/17): the following line was behavi...
320 words
|
2 minutes
Using C_INCLUDE_PATH to install Python packages
I tried to install my [datasette-bplist](https://github.com/simonw/datasette-bplist) plugin today in a fresh Python 3.10 virtual environment on mac...
222 words
|
1 minute
Reporting bugs in GitHub to GitHub
I found out today (via [this post](https://github.com/github-community/community/discussions/19988)) about a dedicated interface for reporting bugs...
55 words
|
1 minute
2024 Security Blacklist and Threat Intelligence
Comprehensive security blacklist and threat intelligence for 2024, covering malicious IPs, domains, and security indicators.
244 words
|
1 minute
Expressive Code Example
How code blocks look in Markdown using Expressive Code.
945 words
|
5 minutes
Using uv to develop Python command-line applications
I finally figured out a process that works for me for hacking on Python CLI utilities using [uv](https://docs.astral.sh/uv/) to manage my developme...
958 words
|
5 minutes