enginoid · May 18, 2025 13:32
diff --git a/datasette-ocr.txt b/datasette-ocr.txt
 ```markdown
 # Datasette

 ## An ecosystem of tools for finding stories in data

 ### Datasette
 Datasette 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 with an accompanying API.

 #### Features
 - Datasette-cluster-map
 - Datasette-graphql
 - Datasette-publish-cloudrun
 - Datasette-comments
 - Datasette-query-assistant
 - Datasette-extract

 ### 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.

 #### Usage
 ```python
 from sqlite_utils import Database

 db = Database("chickens.db")
 db.table("chickens").insert_all([
    {"name": "Duke", "color": "brown"},
    {"name": "Diana", "color": "gold"},
    {"name": "Daisy", "color": "white"},
 ])
 db.table("chickens").enable_fts()
 ```

 ### 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 SQL.

 #### Usage
 ```python
 lm = llm.clouds.J3.haiku.functions.generate_text(prompt="I love")
 def extract_numbers(s):
    return re.findall(r'\d+', s)

 r = "I love (1.23) and 456"
 m = extract_numbers(r)
 ```

 ### Resources
 - [sqlite-utils](https://github.com/simonw/sqlite-utils)
 - [LLM](https://github.com/datasets/llm)
 ```
	```markdown
	# Datasette

	## An ecosystem of tools for finding stories in data

	### Datasette
	Datasette 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 with an accompanying API.

	#### Features
	- Datasette-cluster-map
	- Datasette-graphql
	- Datasette-publish-cloudrun
	- Datasette-comments
	- Datasette-query-assistant
	- Datasette-extract

	### 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.

	#### Usage
	```python
	from sqlite_utils import Database

	db = Database("chickens.db")
	db.table("chickens").insert_all([
	{"name": "Duke", "color": "brown"},
	{"name": "Diana", "color": "gold"},
	{"name": "Daisy", "color": "white"},
	])
	db.table("chickens").enable_fts()
	```

	### 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 SQL.

	#### Usage
	```python
	lm = llm.clouds.J3.haiku.functions.generate_text(prompt="I love")
	def extract_numbers(s):
	return re.findall(r'\d+', s)

	r = "I love (1.23) and 456"
	m = extract_numbers(r)
	```

	### Resources
	- [sqlite-utils](https://github.com/simonw/sqlite-utils)
	- [LLM](https://github.com/datasets/llm)
	```