Skip to content

Instantly share code, notes, and snippets.

@simonw

simonw/output.md Secret

Last active May 18, 2025 13:51
Show Gist options
  • Save simonw/3ececa5f5ff109a81bc6893be06f00b1 to your computer and use it in GitHub Desktop.
Save simonw/3ececa5f5ff109a81bc6893be06f00b1 to your computer and use it in GitHub Desktop.

2025-05-18T13:07:30 conversation: 01jvhr3mrfftvta100ctzmav5f id: 01jvhr3ckbx8vpw2pfw6wa30ej

Model: qwen2.5vl:latest

Prompt

extract text

Attachments

  1. image/jpeg: /private/tmp/p/poster.jpg

Response

The text in the image is as follows:


Datasetette

An ecosystem of tools for finding stories in data

Datasetette

Datasetette is a tool for exploring and publishing data. It helps data journalists (and everyone else) take data of any shape, analyze and explore it, and publish it as an interactive website and accompanying API.

sqlite-utils

sqlite-utils is a Python library and CLI tool for manipulating SQLite databases. It aims to make the gap from "I have data" to "that data is in SQLite" as small as possible.

LLM

LLM is a Python library and CLI tool for interacting with Large Language Models. It provides a plugin-based abstraction over hundreds of different models, both local and hosted, and logs every interaction with them to SQLite.

Datasetette has over 180 plugins adding features for visualizing, editing and transforming data.

  • datasetette-cluster-map
  • datasetette-graphql
  • datasetette-publish-cloudrun
  • datasetette-query-query-assistant
  • datasetette-extract-extract

And in the terminal:

from sqlite_utils import Database
db = Database("chickens.db")
db.table("chickens").insert_all([
    {"name": "Lila", "color": "white"},
    {"name": "Suna", "color": "gold"},
    {"name": "Snowy", "color": "blue"},
])
db.table("chickens").enable_fts([
    ["name", "color"]
])
sqlite-utils transform places.db \ --rename_attractions pk_id \ --default_name name Untitled \ --drop address

This text describes the features and capabilities of the Datasetette ecosystem, including its tools for SQLite database manipulation, Large Language Models (LLMs), and various plugins for data visualization and transformation.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment