Elsewhere

Museum Pioneer Memorial Museum — 300 N Main Street, Salt Lake City, Utah

21st Apr 2023, 11:35 pm

Museum Misalignment Museum — 1699 3rd St. San Francisco, CA, 94158

16th Apr 2023, 3:42 am

Release asyncinject 0.6 — Run async workflows using pytest-fixtures-style dependency injection

14th Apr 2023, 1:22 am

TIL Running Dolly 2.0 on Paperspace — [Dolly 2.0](https://www.databricks.com/blog/2023/04/12/dolly-first-open-commercially-viable-instruction-tuned-llm) looks to be a big deal. It calls itself "the first open source, instruction-following LLM, fine-tuned on a human-generated instruction dataset licensed for research and commercial use."

12th Apr 2023, 4:02 pm

Museum Mattie Leeds Sculpture Garden — 7258 Empire Grade, Santa Cruz, CA 95060

12th Apr 2023, 4:24 am

Release swarm-to-sqlite 0.3.4 — Create a SQLite database containing your checkin history from Foursquare Swarm

11th Apr 2023, 3:18 am

TIL Creating desktop backgrounds using Midjourney — I decided to create a new desktop background for my Mac using [Midjourney](https://midjourney.com/). My laptop has a 16:10 aspect ratio and a retina screen, so I wanted as high a resolution image as possible.

10th Apr 2023, 11:36 pm

Release sqlite-history 0.1 — Track changes to SQLite tables using triggers

9th Apr 2023, 5:09 am

TIL Unix timestamp in milliseconds in SQLite — I wanted to retrieve the time in milliseconds since the Unix epoch in SQLite.

9th Apr 2023, 4:52 am

Release sqlite-history 0.1a0 — Track changes to SQLite tables using triggers

9th Apr 2023, 1:25 am

TIL Saving an in-memory SQLite database to a file in Python — I was messing around in Python with an in-memory SQLite database, when I decided I actually wanted to save my experimental database to a file so I could explore it using [Datasette](https://datasette.io/).

9th Apr 2023, 12:15 am

TIL GPT-4 for API design research — I came up with a really useful prompt for GPT-4 today. I was [considering options](https://github.com/simonw/datasette/issues/2054#issuecomment-1499491258) for refactoring how Datasette's core view functions work, and was contemplating alternative ways to dispatch to different functions based on a combination of the URL path and the HTTP verb.

6th Apr 2023, 7:17 pm

Release datasette-explain 0.1a1 — Explain and validate SQL queries as you type them into Datasette

4th Apr 2023, 7:10 pm · datasette

TIL Copy tables between SQLite databases — I figured out a pattern for doing this today using the `sqlite3` CLI tool - given two SQLite databases in the current folder, called `tils.db` and `simonwillisonblog.db`:

3rd Apr 2023, 5:32 pm

TIL Reading thermometer temperatures over time from a video — [Natalie](https://www.instagram.com/natbat.art/) has been experimenting with using a microwave as a kiln for pottery, specifically for [Raku](https://en.wikipedia.org/wiki/Raku_ware).

2nd Apr 2023, 5:29 pm

Release llm 0.2 — Access large language models from the command-line

1st Apr 2023, 10:30 pm · llm

Release llm 0.1 — Access large language models from the command-line

1st Apr 2023, 10:01 pm · llm

TIL Using the ChatGPT streaming API from Python — I wanted to stream the results from the ChatGPT API as they were generated, rather than waiting for the entire thing to complete before displaying anything.

1st Apr 2023, 8:31 pm

TIL Interactive row selection prototype with Datasette — I added a new [llms](https://simonwillison.net/tags/llms/) tag to my blog, for my content about Large Language Models.

30th Mar 2023, 11:26 pm

TIL Using jq in an Observable notebook — I use the `jq` language quite a lot these days, mainly because I can get ChatGPT to write little JSON transformation programs for me very quickly.

26th Mar 2023, 1:32 am

TIL Convert git log output to JSON using jq — I just spent way too long messing around with ChatGPT ([transcript here](https://gist.github.com/simonw/c3b486fa90d7c32a0e8dfb47e151090a)) trying to figure this out. After much iteration, here's a recipe that works (mostly written by me at this point):

25th Mar 2023, 9:45 pm

Release datasette-no-truncate 0.1 — Tiny Datasette plugin to disable text truncation in table displays

24th Mar 2023, 7:08 pm · datasette

Release datasette-chatgpt-plugin 0.1 — A Datasette plugin that turns a Datasette instance into a ChatGPT plugin

24th Mar 2023, 2:32 pm · datasette

Release datasette-graphql 2.2 — Datasette plugin providing an automatic GraphQL API for your SQLite databases

23rd Mar 2023, 4:33 am · datasette

TIL Use DuckDB to convert parquet to JSON and then open it in Datasette Lite — [pickapic.io](https://pickapic.io/) is a new tool funded by [stability.ai](https://stability.ai/) which asks people to generate and then vote on images in order to provide data to be used for fine tuning an open source image generation model.

21st Mar 2023, 10:49 pm

TIL A simple Python implementation of the ReAct pattern for LLMs — A popular nightmare scenario for AI is giving it access to tools, so it can make API calls and execute its own code and generally break free of the constraints of its initial environment.

17th Mar 2023, 2:52 pm

TIL Scraping Reddit and writing data to the Datasette write API — Today I built a system for monitoring Reddit for new posts that link to various domains that I own.

14th Mar 2023, 5:45 am

Release datasette-atom 0.9 — Datasette plugin that adds a .atom output format

14th Mar 2023, 3:50 am · datasette

TIL How to read Hacker News threads with most recent comments first — [Hacker News](https://news.ycombinator.com/) displays comments in a tree. This can be frustrating if you want to keep track of a particular conversation, as you constantly have to seek through the tree to find the latest comment.

12th Mar 2023, 8:41 pm

Release datasette-simple-html 0.2 — Datasette SQL functions for very simple HTML operations

12th Mar 2023, 5:30 pm · datasette

Simon Willison’s Weblog

Elsewhere

Beats

Years

Tags