Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release datasette-render-images 0.4 — Datasette plugin that renders binary blob images using data-uris
TIL Running OpenAI's large context models using llm — OpenAI [announced new models](https://openai.com/blog/function-calling-and-other-api-updates) today. Of particular interest to me is the new `gpt-3.5-turbo-16k` model, which provides GPT 3.5 with a 16,000 token context window (up from 4,000) priced at 1/10th of GPT-4 - $0.003 per 1K input tokens and $0.004 per 1K output tokens.
TIL Consecutive groups in SQL using window functions — I have a database table with all of my Swarm checkins since 2011, created using my [swarm-to-sqlite](https://datasette.io/tools/swarm-to-sqlite) tool.
Release datasette-sqlite-url-lite 0.1 — A pure Python alternative to sqlite-url ready to be used in Datasette Lite
TIL Testing the Access-Control-Max-Age CORS header — Today I noticed that [Datasette](https://datasette.io/) wasn't serving a `Access-Control-Max-Age` header.
TIL 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 LLaMA. The fine-tuning uses 70,000 instruction-output pairs from this JSON file:
TIL mlc-chat - RedPajama-INCITE-Chat-3B on macOS — MLC (Machine Learning Compilation) on May 22nd 2023: [Bringing Open Large Language Models to Consumer Devices](https://mlc.ai/blog/2023/05/22/bringing-open-large-language-models-to-consumer-devices)
TIL hexdump and hexdump -C — While exploring null bytes in [this issue](https://github.com/simonw/ttok/issues/3) I learned that the `hexdump` command on macOS (and presumably other Unix systems) has a confusing default output.
Release sqlite-utils 3.32.1 — Python CLI utility and library for manipulating SQLite databases
Release sqlite-utils 3.32 — Python CLI utility and library for manipulating SQLite databases
Release strip-tags 0.3 — CLI tool for stripping tags from HTML
Release ttok 0.1 — Count and truncate text based on tokens
Release strip-tags 0.2 — CLI tool for stripping tags from HTML
Release strip-tags 0.1 — CLI tool for stripping tags from HTML
Release llm 0.3 — Access large language models from the command-line
TIL Exploring Baseline with Datasette Lite — One of the announcements from Google I/O 2023 was [Baseline](https://web.dev/baseline/), a new initiative to help simplify the challenge of deciding which web platform features are now widely enough supported by modern browsers to be safe to use.
TIL Running Python code in a Pyodide sandbox via Deno — I continue to seek a solution to the Python sandbox problem. I want to run an untrusted piece of Python code in a sandbox, with limits on memory and time.
Release sqlite-utils 3.31 — Python CLI utility and library for manipulating SQLite databases
Release download-esm 0.1a0 — Download ESM modules from npm and jsdelivr
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.
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.
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*
TIL The location of the pip cache directory — `pip` uses a cache to avoid downloading packages again:
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.
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).

Beats

Years

Tags