Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

TIL Expanding ChatGPT Code Interpreter with Python packages, Deno and Lua — The ChatGPT Code Interpreter alpha remains incredibly interesting. I wrote about how I was using it [for Python and SQLite benchmarking](https://simonwillison.net/2023/Apr/12/code-interpreter/) a few weeks ago. Today I found a neat pattern for expanding its capabilities with custom binaries.
None
Release s3-credentials 0.15 — A tool for creating credentials for accessing S3 buckets
TIL Social media cards generated with shot-scraper — My [TIL website](https://til.simonwillison.net/) has social media card images to make links shared from it look slightly more interesting when shared on sites like Mastodon and Twitter.
None
Release openai-to-sqlite 0.3 — Save OpenAI API results to a SQLite database
TIL Deno KV — *Initial article: April 28th 2023 - see below for an update*
None
TIL The location of the pip cache directory — `pip` uses a cache to avoid downloading packages again:
None
Release datasette 0.64.3 — An open source multi-tool for exploring and publishing data
TIL A few notes on Rye — [Rye](https://github.com/mitsuhiko/rye) is Armin Ronacher's new experimental Python packaging tool. I decided to take it for a test-run.
None
Release shot-scraper 1.2 — A command-line utility for taking automated screenshots of websites
Release datasette-explain 0.1a2 — Explain and validate SQL queries as you type them into Datasette
TIL Interpreting photo orientation and locations in EXIF data — I upgraded my [Niche Museums](https://www.niche-museums.com/) site to use [PhotoSwipe](https://photoswipe.com/) for its photo galleries today. Here's [my issue](https://github.com/simonw/museums/issues/37).
None
Museum Pioneer Memorial Museum — 300 N Main Street, Salt Lake City, Utah
A grand building with Pioneer Memorial Museum written in gold letters along the top, and a plaque in front of it reading Headquarters International Society Daughters of Utah Pioneers
Museum Misalignment Museum — 1699 3rd St. San Francisco, CA, 94158
A sign above the gallery wall reads Sorry for killing most of humanity
Release asyncinject 0.6 — Run async workflows using pytest-fixtures-style dependency injection
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."
None
Museum Mattie Leeds Sculpture Garden — 7258 Empire Grade, Santa Cruz, CA 95060
Pots, pots - so many beautiful pots. They are enormous, and brightly coloured, and jumbled together in an outdoor space.
Release swarm-to-sqlite 0.3.4 — Create a SQLite database containing your checkin history from Foursquare Swarm
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.
None
Release sqlite-history 0.1 — Track changes to SQLite tables using triggers
TIL Unix timestamp in milliseconds in SQLite — I wanted to retrieve the time in milliseconds since the Unix epoch in SQLite.
None
Release sqlite-history 0.1a0 — Track changes to SQLite tables using triggers
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/).
None
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.
None
Release datasette-explain 0.1a1 — Explain and validate SQL queries as you type them into 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`:
None
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).
None
Release llm 0.2 — Access large language models from the command-line
Release llm 0.1 — Access large language models from the command-line
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.
None
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.
None