Generating documentation from tests using files-to-prompt and LLM
2024-09-21
I was experimenting with [wasmtime-py](https://github.com/bytecodealliance/wasmtime-py) today and found the [current documentation](https://bytecod...
541 words
|
3 minutes
Summarizing Hacker News discussion themes with Claude and LLM
2024-09-20
I've been experimenting with the combination of [Claude](https://claude.ai/) and my [LLM CLI tool](https://llm.datasette.io/) to give me quick summ...
2342 words
|
12 minutes
mlc-chat - RedPajama-INCITE-Chat-3B on macOS
2024-09-19
MLC (Machine Learning Compilation) on May 22nd 2023: [Bringing Open Large Language Models to Consumer Devices](https://mlc.ai/blog/2023/05/22/bring...
617 words
|
3 minutes
Using grep to write tests in CI
2024-09-10
GitHub Actions workflows fail if any of the steps executes something that returns a non-zero exit code.
156 words
|
1 minute
Dump out all GitHub Actions context
2024-09-07
Useful for seeing what's available for `if: ` conditions (see [context and expression syntax](https://help.github.com/en/actions/reference/context-...
123 words
|
1 minute
Use labels on Cloud Run services for a billing breakdown
2024-09-07
Thanks to [@glasnt](https://github.com/glasnt) for the tip on this one. If you want a per-service breakdown of pricing on your Google Cloud Run ser...
346 words
|
2 minutes
Generating OpenAPI specifications using GPT-3
2024-09-06
I wanted to start playing around with [OpenAPI](https://www.openapis.org/). I decided to see if I could get GPT-3 to generate the first version of ...
339 words
|
2 minutes
Writing Fly logs to S3
2024-09-05
[Fly](https://fly.io/) offers [fly-log-shipper](https://github.com/superfly/fly-log-shipper) as a container you can run in a Fly application to sen...
481 words
|
2 minutes
Using macOS stickies to display a workshop link on the screen
2024-09-04
When giving a workshop it's often useful to have a URL to the workshop materials visible on screen at all times. I use a bit.ly link for these.
79 words
|
1 minute
git bisect
2024-08-31
I extracted and enhanced this TIL from [my April 8th 2020 weeknotes](https://simonwillison.net/2020/Apr/8/weeknotes-zeit-now-v2/#git-bisect) to mak...
497 words
|
2 minutes
Publishing a simple client-side JavaScript package to npm with GitHub Actions
2024-08-31
Here's what I learned about publishing a single file JavaScript package to NPM for my [Prompts.js](https://simonwillison.net/2024/Dec/7/prompts-js/...
639 words
|
3 minutes
Open external links in an Electron app using the system browser
2024-08-30
For [Datasette.app](https://github.com/simonw/datasette-app) I wanted to ensure that links to external URLs would [open in the system browser](http...
191 words
|
1 minute
GUnion to combine geometries in SpatiaLite
2024-08-29
I was playing around with [datanews/amtrak-geojson](https://github.com/datanews/amtrak-geojson), which provides GeoJSON for Amtrak stations and tra...
463 words
|
2 minutes
SQLite pragma_function_list()
2024-08-27
The SQLite `pragma_function_list()` table-valued function returns a list of functions that have been registered with SQLite, including functions th...
932 words
|
5 minutes
SQLite BLOB literals
2024-08-26
I wanted to construct a string of SQL that would return a blob value:
114 words
|
1 minute
Configuring Django SQL Dashboard for Fly PostgreSQL
2024-08-25
I have a Fly application that uses their PostgreSQL service. I wanted to run [Django SQL Dashboard]() with a read-only user against that database.
518 words
|
3 minutes
Summing columns in remote Parquet files using DuckDB
2024-08-22
[vivym/midjourney-messages](https://huggingface.co/datasets/vivym/midjourney-messages) on Hugging Face is a large (~8GB) dataset consisting of 55,0...
2277 words
|
11 minutes
Export a Mastodon timeline to SQLite
2024-08-22
I've been playing around with [the Mastodon timelines API](https://docs.joinmastodon.org/methods/timelines/). It's pretty fun!
342 words
|
2 minutes
Natural Earth in SpatiaLite and Datasette
2024-08-22
Natural Earth ([website](https://www.naturalearthdata.com/), [Wikipedia](https://en.wikipedia.org/wiki/Natural_Earth)) is a a public domain map dat...
758 words
|
4 minutes
Using tree-sitter with Python
2024-08-22
[tree-sitter](https://tree-sitter.github.io/tree-sitter/) is a "parser generator tool and an incremental parsing library". It has a very good reput...
795 words
|
4 minutes
Using the gcloud run services list command
2024-08-22
The `gcloud run services list` command lists your services running on Google Cloud Run:
381 words
|
2 minutes
Annotated package.json for idb-keyval
2024-08-21
Jake Archibald [pointed to](https://twitter.com/jaffathecake/status/1491771402294370306) his `package.json` for `idb-keyval` as a "modernish exampl...
804 words
|
4 minutes
Verifying your GitHub profile on Mastodon
2024-08-21
Mastodon has a really neat way of implementing verification, using the [rel=me microformat](https://microformats.org/wiki/rel-me).
565 words
|
3 minutes
Complete Guide to Amazon ECS: Container Orchestration at Scale
2024-08-20
Complete guide to Amazon ECS - fully managed container orchestration service for Docker containers with EC2 and Fargate launch types, service discovery, and auto scaling.
3147 words
|
16 minutes