Elsewhere
Release TIL Research Tool Museum
Filters: Sorted by date
3,116 results
«« first
« previous
page 48 / 104
next »
last »»
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.
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):
Release
datasette-no-truncate 0.1
— Tiny Datasette plugin to disable text truncation in table displays
Release
datasette-chatgpt-plugin 0.1
— A Datasette plugin that turns a Datasette instance into a ChatGPT plugin
Release
datasette-graphql 2.2
— Datasette plugin providing an automatic GraphQL API for your SQLite databases
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.
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.
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.
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.
TIL
Copy rich text to the clipboard
— I've been experimenting with a tool for generating the content for a weekly Substack newsletter by querying the Datasette API for my blog and assembling HTML for the last week of content.
TIL
Running LLaMA 7B and 13B on a 64GB M2 MacBook Pro with llama.cpp
— See also: **[Large language models are having their Stable Diffusion moment right now](https://simonwillison.net/2023/Mar/11/llama/)**.
TIL
Using SQL with GDAL
— Inspired [by Brad Neuberg](https://twitter.com/bradneuberg/status/1633875601789681666) I decided to take a look at the SQL features in the GDAL family of tools.
TIL
Using ChatGPT to write AppleScript
— I found a killer application for ChatGPT today: writing AppleScript!
TIL
Mocking subprocess with pytest-subprocess
— For [apple-notes-to-sqlite](https://github.com/dogsheep/apple-notes-to-sqlite) I needed to write some tests that simulated executing the `osascript` command using the Python `subprocess` module.
TIL
A simple Python wrapper for the ChatGPT API
— OpenAI [released an API for ChatGPT](https://openai.com/blog/introducing-chatgpt-and-whisper-apis) yesterday. It's 1/10th of the price of the `text-davinci-003` model!
TIL
sips: Scriptable image processing system
— I wanted to convert some `.webp` images to `.png` on my Mac. I asked ChatGPT:
TIL
Training nanoGPT entirely on content from my blog
— This is a follow-up to [Running nanoGPT on a MacBook M2 to generate terrible Shakespeare](https://til.simonwillison.net/llms/nanogpt-shakespeare-m2).
TIL
Subqueries in select expressions in SQLite - also window functions
— I figured out a single SQL query for the following today. Given a table of GitHub repositories, for each repository return:
«« first
« previous
page 48 / 104
next »
last »»