simonw Follow

simonw Follow

Simon Willison simonw

Follow

2k followers · 133 following · 1.2k

Highlights

Arctic Code Vault Contributor
Developer Program Member

simonw/README.md

Currently working on Datasette and associated projects. Read my blog or follow @simonw on Twitter.

Recent releases

sphinx-to-sqlite 0.1a1 - 2020-10-22

datasette-cluster-map 0.14 - 2020-10-22

inaturalist-to-sqlite 0.2.1 - 2020-10-22

pocket-to-sqlite 0.2.1 - 2020-10-22

datasette 0.51a0 - 2020-10-20

datasette-json-preview 0.2 - 2020-10-20

github-to-sqlite 2.7 - 2020-10-19

dogsheep-beta 0.9 - 2020-10-17

More recent releases

On my blog

Weeknotes: incremental improvements - 2020-10-24

Weeknotes: evernote-to-sqlite, Datasette Weekly, scrapers, csv-diff, sqlite-utils - 2020-10-16

Building an Evernote to SQLite exporter - 2020-10-16

Weeknotes: Mainly Datasette 0.50 - 2020-10-10

Datasette 0.50: The annotated release notes - 2020-10-09

More on simonwillison.net

TIL

Writing JavaScript that responds to media queries - 2020-10-22

Explicit file encodings using click.File - 2020-10-16

Upgrading Python Homebrew packages using pip - 2020-10-14

Searching for repositories by topic using the GitHub GraphQL API - 2020-10-10

Running Datasette on DigitalOcean App Platform - 2020-10-07

More on til.simonwillison.net

Pinned

datasette

An open source multi-tool for exploring and publishing data

Python 3.9k 222
sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Python 234 16
csvs-to-sqlite

Convert CSV files into a SQLite database

Python 514 44
dogsheep/twitter-to-sqlite

Save data from Twitter to a SQLite database

Python 146 6
dogsheep/github-to-sqlite

Save data from GitHub to a SQLite database

Python 68 6
datasette-graphql

Datasette plugin providing an automatic GraphQL API for your SQLite databases

Python 23 2

6,409 contributions in the last year

Activity overview

Contributed to simonw/datasette, simonw/til, simonw/museums and 5 other repositories

Contribution activity

October 2020

simonw/feed-to-sqlite Python Oct 18
simonw/sphinx-to-sqlite Python Oct 18
simonw/datasette-json-preview Python Oct 11
simonw/ca-fires-history Oct 8
simonw/nhs-risky-venues Oct 8
simonw/buildpack-datasette-demo Oct 6

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

datasette.client internal requests mechanism

Refs #943

+163 −100 • 18 comments

/db/table/-/blob/pk/column.blob download URL Oct 21
Run tests against Python 3.9 Oct 5

Upgrade for latest sqlite-utils Oct 18

Create LICENSE Oct 11

Add raw_path to scope in ASGITransport Oct 9

Test against Python 3.9 Oct 8

/db/table/-/blob/pk/column.blob download URL Oct 21

Add raw_path to scope in ASGITransport Oct 9

Add pull requests Oct 6

Created an issue in simonw/datasette that received 17 comments

Better way of representing binary data in .csv output

I just noticed this: https://latest.datasette.io/fixtures/binary_data.csv rowid,data 1,b'\x15\x1c\x02\xc7\xad\x05\xfe' 2,b'\x15\x1c\x03\xc7\xad\x05…

17 comments

Document recommendations for plugin authors to design URLs Oct 26
Column action menu overlapped by Leaflet maps Oct 26
Better display of binary data on arbitrary query results page Oct 25
Switch to .blob render extension for BLOB downloads Oct 25
Documentation and unit tests for urls.row() urls.row_blob() methods Oct 25
A new section in the docs about how Datasette handles BLOB columns Oct 24
Link to blob downloads in the right places Oct 24
Document that datasette.render_template(template, ...) also accepts a list of templates Oct 23
Plugin hook for loading templates Oct 23
extra_js_urls and extra_css_urls should respect base_url setting Oct 22
Add an animation to the column actions menu Oct 21
Add horizontal scrollbar to tables Oct 21
Make it possible to download BLOB data from the Datasette UI Oct 20
datasette.urls.table(..., format="json") argument Oct 20
datasette.urls.static_plugins(...) method Oct 20
Bring date parsing into Datasette core Oct 19
--load-extension=spatialite shortcut Oct 17
Add documentation on serving Datasette behind a proxy using base_url Oct 15
How should datasette.client interact with base_url Oct 15
Fix last remaining links to "/" that do not respect base_url Oct 15
Figure out how to run an environment that exercises the base_url proxy setting Oct 15
Fix issues relating to base_url Oct 15
Method for datasette.client() to forward on authentication Oct 14
Add a "delete" icon next to filters (in addition to "remove filter") Oct 11
Research: could Datasette install its own plugins? Oct 11
Some issues not shown.

Better handling of OCR data Oct 11
Figure out how to display images from <en-media> tags inline in Datasette Oct 11
Configure FTS + add an index on the date columns Oct 11
Use a content hash for the note IDs Oct 11
Convert dates to a better format Oct 11
Documentation on how to use this with Datasette Oct 11

Change order in which tools are displayed Oct 1
Update README for non-alpha version Oct 1
Support permission checks against database/table resources Oct 1
"allow" block in plugin configuration Oct 1
Rename this to datasette-edit-schema Oct 1

Use new datasette.urls.static_plugins() method Oct 24
Default popup format should be something other than JSON Oct 19
Plugin can break other plugins Oct 1

Show links/quotes mixed in order with entries on mobile Oct 21
Upgrade django-redis-cache Oct 1

Add search highlighting snippets Oct 19
Switch to using datasette.client Oct 17

Add SVG output option Oct 12
Some parameters need to accept a list Oct 2

Feature suggestion: expose sqlite3_column_database_name family of functions Oct 25

Link to BLOB downloads Oct 25

sdist release in addition to wheel Oct 23

Some workout columns should be float, not text Oct 23

Option to extract Point geometries into latitude/longitude columns Oct 22

Switch to using datasette.client Oct 19

Option to fetch README and/or HTML-rendered README for repos Oct 19

Release notes for 1.0 Oct 16

API suggestion: soup.all("div") and soup.first("div") Oct 10

Missing link in 0.27.0 release notes Oct 2

Errors no longer get passed to Sentry Oct 1

45 contributions in private repositories Oct 1 – Oct 26

You can’t perform that action at this time.