The Wayback Machine - https://web.archive.org/web/20220424101325/https://github.com/simonw

simonw Follow

Simon Willison simonw

Follow

3.1k followers · 133 following

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

Sponsors

Sponsoring

Achievements

Achievements

Highlights

Developer Program Member
5 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

asyncinject 0.5 - 2022-04-22

django-sql-dashboard 1.1 - 2022-04-20

shot-scraper 0.13 - 2022-04-18

tweet-images 0.1.2 - 2022-04-18

geojson-to-sqlite 1.1.1 - 2022-04-13

sqlite-utils 3.26 - 2022-04-13

summarize-template 0.1 - 2022-04-13

pypi-to-sqlite 0.2.2 - 2022-04-08

More recent releases

On my blog

Building a Covid sewage Twitter bot (and other weeknotes) - 2022-04-18

Pillar Point Stewards, pypi-to-sqlite, improvements to shot-scraper and appreciating datasette-dashboards - 2022-04-08

Weeknotes: datasette-auth0 - 2022-03-28

Datasette 0.61: The annotated release notes - 2022-03-24

SQLite Happy Hour - a Twitter Spaces conversation about three interesting projects building on SQLite - 2022-03-23

Weeknotes: Tildes not dashes, and the big refactor - 2022-03-19

More on simonwillison.net

TIL

How to get credentials for a new Twitter bot - 2022-04-17

Trick Apple Photos into letting you access your video files - 2022-04-12

GUnion to combine geometries in SpatiaLite - 2022-04-12

Using awk to add a prefix - 2022-04-08

Logging users out of Auth0 - 2022-04-04

More on til.simonwillison.net

Pinned

datasette Public

An open source multi-tool for exploring and publishing data

Python 6k 413
sqlite-utils Public

Python CLI utility and library for manipulating SQLite databases

Python 812 65
dogsheep/github-to-sqlite Public

Save data from GitHub to a SQLite database

Python 190 28
s3-credentials Public

A tool for creating credentials for accessing S3 buckets

Python 108 7
git-history Public

Tools for analyzing Git history using SQLite

Python 94 6
shot-scraper Public

Tools for taking automated screenshots of websites

Python 520 21

5,003 contributions in the last year

Learn how we count contributions

Less More

Activity overview

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

Contribution activity

April 2022

Created 195 commits in 22 repositories

Created 6 repositories

simonw/covidsewage-bot Apr 17
simonw/tweet-images Python Apr 17
simonw/news-homepages Python Apr 17
simonw/summarize-template Python Apr 13
simonw/pypi-to-sqlite Python Apr 7
simonw/pypi-datasette-packages Shell Apr 7

Created a pull request in palewire/news-homepages that received 5 comments

Show timezone to clarify local time

Potential clarification for: #82

+2 −2 • 5 comments

Opened 2 other pull requests in 2 repositories

simonw/asyncinject 1 merged

Switch from class-based to function-based Apr 15

simonw/shot-scraper 1 merged

--js-selector and --js-selector-all options Apr 9

Created an issue in simonw/datasette.io that received 23 comments

Use releases information from PyPI, not GitHub

I want to start listing more plugins by other people, for example https://github.com/rclement/datasette-dashboards The site currently uses GitHub r…

23 comments

Opened 81 other issues in 16 repositories

natbat/pillarpointstewards 2 open 27 closed

Make /admin/ redirect to the Auth0 login Apr 22
Link to dashboard from navigation Apr 22
Link to /admin/ for admin users Apr 7
Add django-sql-dashboard Apr 5
Allow users to edit their displayed name Apr 5
Git scraping backup mechanism Apr 5
Fail tests on warnings (specifically timezone ones) Apr 4
Arrow warning when running the tests Apr 4
Logout needs to ensure login doesn't log you back in again instantly Apr 4
Signup magic link should go to signup, not login Apr 4
Configure Google production keys for Auth0 Apr 3
Try to slim down the Docker container a bit Apr 3
Mechanism for letting people create active accounts Apr 2
New user accounts need to be approved before they can access the site Apr 2
Secure secret URL for shifts.ics calendar Apr 2
Show weather forecast for shift, if possible Apr 2
/shifts/ page with details of all upcoming shifts Apr 2
Logins in production go over http, should be https Apr 2
Update /admin/import-shifts/ tool for finished notebook Apr 2
Calculated shift times should rounded to 15 minutes Apr 1
"Your account has not yet been activated" when logging in again Apr 1
Implement /logout/ Apr 1
Set up a base template Apr 1
Page per shift Apr 1
Get some example data running in production Apr 1
Some issues not shown.

simonw/datasette 5 closed 8 open

Configure git blame to ignore Black commit Apr 22
Refactor TableView to use asyncinject Apr 22
Datasette feature for publishing snapshots of query results Apr 14
Make "<Binary: 2427344 bytes>" easier to read Apr 12
Template context powered entirely by the JSON API format Apr 11
Guide for plugin authors to upgrade their plugins for 1.0 Apr 11
Redesigned JSON API with ?_extra= parameters Apr 11
1.0a0 release notes Apr 11
How to upgrade your plugin for 1.0 documentation Apr 8
File PRs against incompatible plugins pinning to datasette<1.0 Apr 8
Be more consistent with column quoting Apr 7
Use + for spaces instead of ~20 Apr 6
Add a warning about bots and Cloud Run Apr 3

simonw/shot-scraper 6 closed 1 open

simonw/pypi-to-sqlite 6 closed 1 open

It should be safe to run the command against an existing database Apr 8
--prefix option for table prefixes Apr 8
Do something more with the requires_dist field Apr 8
Link to a live demo Apr 7
Split versions out into a separate table Apr 7
Show help and generated schema in the README Apr 7
Initial command Apr 7

simonw/asyncinject 4 closed 1 open

Ability to resolve an unregistered function Apr 21
Turn that visualization hack into a feature Apr 18
Investigate a non-class-based version Apr 15
Record start and end times for each step when logging Apr 15
A way to turn off parallel execution (for easier comparison) Apr 15

simonw/datasette.io 3 open 1 closed

Why SQLite? Page Apr 17
Datasette for Geospatial analysis Apr 12
Support plugins/tools that aren't hosted on GitHub Apr 8
datasette.io/ideas Apr 8

simonw/covidsewage-bot 2 closed 1 open

Tweet at 7am San Francisco time Apr 18
Generate useful alt text Apr 17
Add a logo to the Twitter account Apr 17

simonw/sqlite-utils 1 open 2 closed

simonw/museums 2 closed

Hiller Aviation Museum listed twice Apr 15
Remove the about.db and map.db hacks Apr 14

simonw/geojson-to-sqlite 1 closed 1 open

simonw/tweet-images 1 closed

TWITER_ACCESS_TOKEN_SECRET environment variable misspelled Apr 17

palewire/news-homepages 1 open

"local time" wasn't obvious to me Apr 17

simonw/datasette-sqlite-fts4 1 closed

Interactive demo is broken Apr 17

Sobeston/ziglearn 1 open

Link to the next page at the bottom of each chapter Apr 16

simonw/s3-credentials 1 open

Every command should have example usage in --help Apr 14

simonw/django-sql-dashboard 1 closed

Allow the <br> tag in HTML Apr 7

47 contributions in private repositories Apr 1 – Apr 22