simonw Follow

Simon Willison simonw

Follow

2.9k followers · 132 following

Datasette
San Francisco, CA
https://simonwillison.net/
@simonw

Sponsors

Sponsoring

Achievements

Achievements

Highlights

Developer Program Member
4 discussions answered

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 @simonw on Twitter.

Recent releases

sqlite-utils 3.22.1 - 2022-01-26

s3-credentials 0.10 - 2022-01-25

datasette 0.60.1 - 2022-01-21

datasette-pretty-traces 0.4 - 2022-01-14

datasette-leaflet-freedraw 0.3 - 2022-01-14

datasette-graphql 2.0.1 - 2022-01-12

stream-delay 0.1 - 2022-01-08

datasette-tiddlywiki 0.1 - 2021-12-23

More recent releases

On my blog

Weeknotes: python_requires, documentation SEO - 2022-01-25

Weeknotes: s3-credentials prefix and Datasette 0.60 - 2022-01-18

Datasette 0.60: The annotated release notes - 2022-01-14

How I build a feature - 2022-01-12

What's new in sqlite-utils 3.20 and 3.21 - 2022-01-11

Weeknotes: Taking a break in Moss Landing - 2022-01-04

More on simonwillison.net

TIL

Opt-in integration tests with pytest --integration - 2022-01-26

Using the undocumented Fly GraphQL API - 2022-01-21

Linking from /latest/ to /stable/ on Read The Docs - 2022-01-20

Promoting the stable version of the documentation using rel=canonical - 2022-01-20

Pixel editing a favicon with Pixelmator - 2022-01-20

More on til.simonwillison.net

Pinned

datasette Public

An open source multi-tool for exploring and publishing data

Python 5.7k 389
sqlite-utils Public

Python CLI utility and library for manipulating SQLite databases

Python 620 54
dogsheep/twitter-to-sqlite Public

Save data from Twitter to a SQLite database

Python 294 14
dogsheep/github-to-sqlite Public

Save data from GitHub to a SQLite database

Python 171 26
s3-credentials Public

A tool for creating credentials for accessing S3 buckets

Python 99 6
git-history Public

Tools for analyzing Git history using SQLite

Python 82 4

5,036 contributions in the last year

Learn how we count contributions

Less More

Activity overview

Contributed to CAVaccineInventory/vial, simonw/datasette, simonw/sqlite-utils and 5 other repositories

Contribution activity

January 2022

Created 170 commits in 19 repositories

Created 2 repositories

simonw/assume-aws-role-action TypeScript Jan 18
simonw/stream-delay Python Jan 8

Created a pull request in simonw/sqlite-utils that received 15 comments

--lines and --text and --convert and --import

Refs #356 Still TODO: Get --lines working, with tests Get --text working, with tests Get regular JSON import working with --convert with tests …

+697 −368 • 15 comments

Opened 6 other pull requests in 5 repositories

simonw/sqlite-utils 1 merged 1 closed

sqlite-utils bulk command Jan 10
Initial prototype of .analyze() methods Jan 8

simonw/datasette-publish-fly 1 open

Volume support plus integration tests Jan 26

readthedocs/readthedocs.org 1 merged

Canonical can point as stable, not just latest Jan 20

simonw/s3-credentials 1 merged

list-roles command Jan 19

saml-to/assume-aws-role-action 1 merged

Fix broken link to FAQs Jan 18

Reviewed 1 pull request in 1 repository

simonw/s3-credentials 1 pull request

list-roles command Jan 19

Created an issue in simonw/datasette-publish-fly that received 22 comments

Research how to deploy with latest flyctl and with a volume

Just got "Error: unknown flag: --builder" from flyctl apps create while trying to run a deploy.

22 comments

Opened 76 other issues in 13 repositories

simonw/sqlite-utils 24 closed 2 open

sqlite-utils bulk --batch-size option Jan 26
sqlite-utils bulk progress bar Jan 26
sqlite-utils upsert should require --pk more elegantly Jan 26
Plausible analytics for documentation Jan 26
Link to stable docs from older versions Jan 26
Python library docs should start with a self contained example Jan 22
Better "contributing" documentation Jan 19
Add examples to every --help Jan 12
Add documentation page with the output of --help Jan 11
--where option for sqlite-rows Jan 11
sqlite-utils rows options --limit and --offset Jan 11
Release notes for 3.21 Jan 11
CLI options for running ANALYZE Jan 11
analyze=True parameter for some methods Jan 10
--nl mode should ignore blank lines Jan 10
sqlite-utils bulk command Jan 9
--fmt should imply -t Jan 9
List --fmt options in the docs Jan 9
Idea: suffix and stem file columns Jan 9
Support mutating row in --convert without returning it Jan 9
Research how much of a difference analyze / sqlite_stat1 makes Jan 9
Offer python -m sqlite_utils as an alternative to sqlite-utils Jan 9
Python library methods for calling ANALYZE Jan 7
--batch-size 1 doesn't seem to commit for every item Jan 6
Better error message if --convert code fails to return a dict Jan 6
Some issues not shown.

simonw/datasette 10 open 11 closed

Try again with SQLite codemirror support Jan 26
Improvements to help make Datasette a better tool for learning SQL Jan 26
Avoid ever running count(*) against SpatiaLite KNN table Jan 25
Ensure "pip install datasette" still works with Python 3.6 Jan 21
Documentation should clarify /stable/ vs /latest/ Jan 20
More detailed information about installed SpatiaLite version Jan 20
Tests failing against Python 3.6 Jan 20
Option to assign a domain/subdomain using datasette publish cloudrun Jan 19
A proper favicon Jan 19
plugins --all example should use cog Jan 15
Add architecture documentation Jan 14
Replace update-docs-help.py script with cog Jan 14
"datasette inspect" has no help summary Jan 14
Documentation page warning of changes coming in 1.0 Jan 13
Release notes for 0.60 Jan 13
Add a CLI reference page to the docs, inspired by sqlite-utils Jan 13
Row pages should show links to foreign keys Jan 12
Maybe let plugins define custom serve options? Jan 12
explain query plan select is too strict about whitespace Jan 9
Add sqlite_stat1(-4) tables to hidden table list Jan 8
Fire base caching for publish cloudrun Jan 1

simonw/s3-credentials 8 closed 10 open

Is "Condition": {} really necessary? Jan 20
create fails if user already has two access keys Jan 19
General solution for paginating AWS endpoints Jan 19
list-roles command Jan 19
Command for creating roles Jan 19
Research potential for an access points feature Jan 18
Support one or more --key options to create credentials restricted to a specific key Jan 18
Support multiple --prefix options Jan 18
Make list-user-policies work with --nl and --csv and --tsv Jan 18
--prefix example policies in README plus integration tests Jan 17
Clean up resources created in #51 Jan 17
list-bucket command should accept an optional prefix Jan 17
Manually test --prefix against litestream.io Jan 17
delete-bucket command Jan 17
Add a --csv output option Jan 17
Standard default output should be a valid JSON array Jan 17
Consider --cors-policy option Jan 5
Integrate with simulate policies API Jan 1

simonw/datasette-publish-fly 1 closed 1 open

--generate-dir option Jan 26
Support Fly volumes Jan 21

simonw/simonwillisonblog 1 closed

Faceting should not persist the page number Jan 25

superfly/flyctl 1 open

Confusion over the --builder option Jan 21

observablehq/feedback 1 open

A pattern for storing API secrets, maybe even obtained via OAuth Jan 21

simonw/datasette-jq 1 open

Migrate to GitHub Actions Jan 15

simonw/covid-19-datasette 1 open

covid-19.datasettes.com serving same content as cdc-vaccination-history.datasette.io Jan 13

simonw/datasette-app 1 open

Mechanism for plugins that need a specific DB Jan 12

simonw/datasette-graphql 1 closed

Bug in the example query in the README Jan 12

multiprocessio/dsq 1 open

Suggestion for Comparisons section Jan 12

pallets/click 1 open

Mechanism for testing long-running processes Jan 9

29 contributions in private repositories Jan 2 – Jan 25