simonw

Follow

Simon Willison simonw

Follow

3.8k followers · 135 following

Datasette
Half Moon Bay, CA
02:44 (UTC -08:00)
https://simonwillison.net/
@simonw

Sponsors

Sponsoring

Achievements

BetaSend feedback

Achievements

BetaSend feedback

Highlights

Developer Program Member
Pro

Block or Report

Block or report simonw

Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse

simonw/README.md

Currently working on Datasette and associated projects. Read my blog or follow @simon@simonwillison.net on Mastodon.

Recent releases

datasette-gunicorn 0.1.1 - 2022-12-18

datasette 0.63.3 - 2022-12-18

datasette-ripgrep 0.8 - 2022-12-15

datasette-media 0.5.1 - 2022-12-13

datasette-secret-santa 0.1 - 2022-12-11

datasette-render-binary 0.3.1 - 2022-12-10

datasette-public 0.2.2 - 2022-12-02

datasette-ephemeral-tables 0.2.2 - 2022-12-02

More recent releases

On my blog

Weeknotes: Datasette 0.63.3, datasette-ripgrep - 2022-12-20

Datasette 1.0a2: Upserts and finely grained permissions - 2022-12-15

Over-engineering Secret Santa with Python cryptography and Datasette - 2022-12-11

Weeknotes: datasette-ephemeral-tables, datasette-export - 2022-12-05

AI assisted learning: Learning Rust with ChatGPT, Copilot and Advent of Code - 2022-12-05

A new AI game: Give me ideas for crimes to do - 2022-12-04

More on simonwillison.net

TIL

Start, test, then stop a localhost web server in a Bash script - 2022-12-18

Comparing database rows before and after with SQLite JSON functions - 2022-12-14

SQLite can use more than one index for a query - 2022-12-12

Viewing GeoPackage data with SpatiaLite and Datasette - 2022-12-12

Show files opened by pytest tests - 2022-12-12

More on til.simonwillison.net

Pinned

datasette Public

An open source multi-tool for exploring and publishing data

Python 6.8k 477
sqlite-utils Public

Python CLI utility and library for manipulating SQLite databases

Python 1.1k 81
dogsheep/github-to-sqlite Public

Save data from GitHub to a SQLite database

Python 265 35
s3-credentials Public

A tool for creating credentials for accessing S3 buckets

Python 136 10
git-history Public

Tools for analyzing Git history using SQLite

Python 128 12
shot-scraper Public

A command-line utility for taking automated screenshots of websites

Python 814 41

6,266 contributions in the last year

Learn how we count contributions

Less More

Activity overview

Contributed to simonw/datasette, simonw/til, simonw/sqlite-utils and 290 other repositories

Contribution activity

December 2022

Created 266 commits in 27 repositories

Created 5 repositories

simonw/datasette-geopackage Python Dec 12
simonw/cummings.ee SCSS Dec 10
simonw/datasette-secret-santa Python Dec 10
simonw/todomvc-datasette JavaScript Dec 2
simonw/advent-of-code-2022-in-rust Rust Dec 1

Created a pull request in simonw/datasette that received 30 comments

Port as many tests as possible to async def tests against ds_client

Refs: #1959 📚 Documentation preview 📚: https://datasette--1960.org.readthedocs.build/en/1960/

+1,300 −977 • 30 comments

Opened 10 other pull requests in 4 repositories

simonw/datasette 3 merged 1 closed

Use click.echo() instead of print() for --root option Dec 16
register_permissions() plugin hook Dec 9
"permissions" blocks in metadata.json/yaml Dec 8
/db/table/-/upsert Dec 3

palewire/cummings.ee 4 merged

ONE X: death is more than Dec 11
ONE VIII: isten my children and you Dec 11
FOUR VIII: some ask praise of their fellows Dec 10
FOUR IX: supposing i dreamed this), refs #181 Dec 10

natbat/cbwg 1 merged

Deploy on Fly instead of Heroku Dec 15

simonw/cummings.ee 1 closed

ONE X: death is more than Dec 11

Reviewed 4 pull requests in 2 repositories

palewire/cummings.ee 3 pull requests

ONE VIII: isten my children and you Dec 11
FOUR VIII: some ask praise of their fellows Dec 10
FOUR IX: supposing i dreamed this), refs #181 Dec 10

simonw/datasette 1 pull request

Port as many tests as possible to async def tests against ds_client Dec 17

Created an issue in simonw/advent-of-code-2022-in-rust that received 40 comments

Day 7: No Space Left On Device

https://adventofcode.com/2022/day/7 Puzzle input looks like this: $ ls dir a 14848514 b.txt 8504156 c.dat dir d $ cd a $ ls dir e 29116 f 2557 g 62…

40 comments

Opened 68 other issues in 15 repositories

simonw/datasette 11 open 14 closed

simonw/advent-of-code-2022-in-rust 1 open 15 closed

simonw/datasette-secret-santa 8 closed

Link to /santa/create_secret_santa if none exist Dec 11
Sort out navigation Dec 10
Better error if you get your password wrong Dec 10
Add a styled UI, with animated snowflakes Dec 10
message_read_at should record when they read the message Dec 10
Do a better job of encrypting the private key with a password Dec 10
Test that exercises whole flow Dec 10
Build a secret santa system Dec 10

simonw/sqlite-utils 2 closed 1 open

simonw/datasette.io 2 open 1 closed

Upgrade the examples page Dec 6
Discord invite link gave me an error Dec 3
Deploys are broken, Google Cloud actions error Dec 1

simonw/todomvc-datasette 2 open 1 closed

simonw/datasette-ripgrep 2 closed

Show a gap between ranges of lines in search results Dec 14
Demo has gone stale Dec 14

nolanlawson/pinafore 1 open

"Open original page" menu item for a toot Dec 24

simonw/datasette-gunicorn 1 closed

render_template() called before await ds.invoke_startup() Dec 15

simonw/datasette-media 1 closed

500 error if content is blank Dec 13

simonw/help-scraper 1 closed

Drop Griffe Dec 13

simonw/datasette-geopackage 1 closed

Try and get SRID queries working against GeoPackage database files Dec 12

eyeseast/datasette-geojson 1 open

"Object of type bytes is not JSON serializable" Dec 12

simonw/datasette-public 1 closed

Should be possible to make views public in the same way as tables Dec 2

simonw/datasette-ephemeral-tables 1 closed

Fails to drop tables with hyphens in their name Dec 2

Answered 1 discussion in 1 repository

simonw/datasette

Sqlite Virtual Table as Datasette plugin?
This contribution was made on Dec 15

20 contributions in private repositories Dec 1 – Dec 16