The simplest recursive CTE
I found this really simple recursive CTE useful for ensuring I understood how to write recursive CTEs.
161 words
|
1 minute
Show the SQL schema for a PostgreSQL database
This took me longer to figure out than I care to admit.
58 words
|
1 minute
Streaming indented output of a JSON array
I wanted to produce the following output from a command-line tool:
184 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.
624 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...
780 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...
677 words
|
3 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...
505 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...
61 words
|
1 minute