simonw Follow

Simon Willison simonw

JSK @ Stanford
San Francisco, CA
Sign in to view email
https://simonwillison.net/

Developer Program Member

Block or report user

Report or block simonw

Contact Support about this user’s behavior.

Learn more about reporting abuse

JSK @ Stanford
San Francisco, CA
Sign in to view email
https://simonwillison.net/

Block or report user

Report or block simonw

Contact Support about this user’s behavior.

Learn more about reporting abuse

Pinned

datasette

A tool for exploring and publishing data

Python 3.5k 199
sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Python 134 9
csvs-to-sqlite

Convert CSV files into a SQLite database

Python 464 39
dogsheep/twitter-to-sqlite

Save data from Twitter to a SQLite database

Python 121 2
dogsheep/github-to-sqlite

Save data from GitHub to a SQLite database

Python 36 4
til

Today I Learned

HTML 117 15

4,580 contributions in the last year

Activity overview

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

Contribution activity

June 2020

simonw/datasette-auth-tokens Python Jun 11
simonw/xeus-sqlite C++ Jun 11
simonw/datasette-permissions-sql Python Jun 10
simonw/asgi-auth-github Python • Built by Jun 10

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

New WIP writable canned queries

Refs #698. Replaces #703 Still todo: Unit tests ~~Figure out .json mode~~ Flash message solution ~~CSRF protection~~ Better error message display on er…

+263 −22 • 9 comments

New version of plugin designed to integrate with Datasette 0.44 Jun 11

Expanded usage instructions, refs #49 Jun 11

datasette-auth-github is now asgi-auth-github Jun 10

Sign csrftoken value with itsdangerous Jun 3

Created an issue in simonw/datasette that received 20 comments

"flash messages" mechanism

Passing ?_success like this isn't necessarily the best approach. Potential improvements include: Signing this message so it can't be tampered wit…

20 comments

{"$file": ...} mechanism is broken Jun 12
Plugin $env secrets mechanism doesn't work inside lists Jun 11
actor_matches_allow fails to consider all keys Jun 11
Mechanism for skipping CSRF checks on API posts Jun 11
Plugin idea: on_startup Jun 11
/-/metadata and so on should respect view-instance permission Jun 11
Having view-table permission but NOT view-database should still grant access to /db/table Jun 11
It would be more intuitive if "allow": none meant "no-one can do this" Jun 10
Redesign register_facet_classes plugin hook Jun 10
Ability to set ds_actor cookie such that it expires Jun 10
Horizontal scrollbar on changelog page on mobile Jun 10
Document CSRF protection (for plugins) Jun 9
Document the ds_actor signed cookie Jun 9
Way to enable a default=False permission for anonymous users Jun 9
Example authentication plugin Jun 9
Documentation is inconsistent about "id" as required field on actor Jun 9
request.url_vars helper property Jun 9
Add Response class to internals documentation Jun 9
Idea: Plugin hook for registering canned queries Jun 9
Example permissions plugin Jun 8
Drop resource_type from permission_allowed system Jun 8
Come up with a new example for extra_template_vars plugin Jun 8
Group permission checks by request on /-/permissions debug page Jun 8
Remove --debug option from datasette serve Jun 8
Mechanism for specifying allow_sql permission in metadata.json Jun 8
Some issues not shown.

Add test for resource matching Jun 11
"fallback": true option for supporting -1 = false Jun 11
Depend on Datasette 0.44 once it is released Jun 11

Split off asgi-auth-github Jun 10
Integrate with new authentication system in Datasette 0.44 Jun 8

Make this work with authentication in Datasette 0.44 Jun 12

Kernel dies in Binder demo Jun 11

Integrate Datasette permissions Jun 6

7 contributions in private repositories Jun 1 – Jun 10

You can’t perform that action at this time.