Skip to content

Instantly share code, notes, and snippets.

@enginoid
Created May 18, 2025 13:32
Show Gist options
  • Select an option

  • Save enginoid/5c91c920124d4a2e0ab253df769e35fa to your computer and use it in GitHub Desktop.

Select an option

Save enginoid/5c91c920124d4a2e0ab253df769e35fa to your computer and use it in GitHub Desktop.
```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)
```
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment