simonw Follow

simonw Follow

Simon Willison simonw

Follow

2.5k followers · 133 following · 1.4k

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

Sponsors

Sponsoring

Achievements

Achievements

Highlights

Developer Program Member
2 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.11 - 2021-06-20

dogsheep-beta 0.10.2 - 2021-06-13

yaml-to-sqlite 1.0 - 2021-06-13

markdown-to-sqlite 1.0 - 2021-06-13

db-to-sqlite 1.4 - 2021-06-11

datasette-mask-columns 0.2.1 - 2021-06-10

datasette 0.58a0 - 2021-06-10

datasette-placekey 0.1 - 2021-06-10

More recent releases

On my blog

Joining CSV and JSON data with an in-memory SQLite database - 2021-06-19

Weeknotes: New releases across nine different projects - 2021-06-12

Weeknotes: Docker architectures, sqlite-utils 3.7, nearly there with Datasette 0.57 - 2021-06-03

Weeknotes: Spinning back up on Datasette - 2021-05-25

Weeknotes: Velma, more Django SQL Dashboard - 2021-05-18

More on simonwillison.net

TIL

Scraping Reddit via their JSON API - 2021-06-21

Mouse support in vim - 2021-06-19

Running a MySQL server using Homebrew - 2021-06-11

Exporting Amplitude events to SQLite - 2021-06-06

Building a Markdown summary of Django group permissions - 2021-06-03

More on til.simonwillison.net

Pinned

datasette

An open source multi-tool for exploring and publishing data

Python 5.2k 321
sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Python 457 43
csvs-to-sqlite

Convert CSV files into a SQLite database

Python 612 45
dogsheep/twitter-to-sqlite

Save data from Twitter to a SQLite database

Python 227 12
dogsheep/github-to-sqlite

Save data from GitHub to a SQLite database

Python 139 14
datasette-graphql

Datasette plugin providing an automatic GraphQL API for your SQLite databases

Python 45 4

6,444 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

June 2021

Created 198 commits in 28 repositories

Created 3 repositories

simonw/waitlist Jun 18
simonw/docs-1 JavaScript Jun 11
simonw/datasette-placekey Python Jun 10

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

sqlite-utils memory command for directly querying CSV/JSON data

Refs #272. Initial implementation only does CSV data, still needs: Implement --save Add --dump to the documentation Add --attach example to the…

+355 −54 • 10 comments

Opened 4 other pull requests in 4 repositories

tractordev/waitlist

1 merged

simonw Jun 18

simonw/db-to-sqlite

1 merged

Run tests in GitHub Actions Jun 11

simonw/datasette-graphql

1 merged

Use datasette.client instead of TableView Jun 6

simonw/datasette

1 merged

Make custom pages compatible with base_url setting Jun 5

Reviewed 5 pull requests in 5 repositories

simonw/datasette 1 pull request

DRAFT: A new plugin hook for dynamic metadata Jun 21

simonw/sqlite-utils 1 pull request

sqlite-utils memory command for directly querying CSV/JSON data Jun 16

CAVaccineInventory/vial 1 pull request

Reflect auth0 roles in VIAL Jun 14

simonw/django-sql-dashboard 1 pull request

Add a Docker Compose setup for development. Jun 12

simonw/datasette-graphql 1 pull request

Use datasette.client instead of TableView Jun 6

Created an issue in CAVaccineInventory/vial that received 34 comments

Populate Location fields: vaccines_offered, accepts_appointments and accepts_walkins

Replaces #504 - needed by #649. From https://docs.google.com/document/d/17svyCVXcloArj1wbUgu7QwEb6xeIDa-p7C3U0_yLgKg/edit BASIC RULES For durable…

34 comments

Opened 82 other issues in 22 repositories

CAVaccineInventory/vial

11 closed 8 open

simonw/datasette

9 open 9 closed

simonw/sqlite-utils

15 closed 1 open

sqlite-utils memory blah.json --schema Jun 20
Update rowid examples in the docs Jun 20
Add installation instructions Jun 19
Introspection property for telling if a table is a rowid table Jun 19
.transform(types=) turns rowid into a concrete column Jun 19
memory: Shouldn't detect types for JSON Jun 19
Automatic type detection for CSV data Jun 19
Mechanism for explicitly stating CSV or JSON or TSV for sqlite-utils memory Jun 18
Add --encoding option to sqlite-utils memory Jun 18
sqlite-utils memory should handle TSV and JSON in addition to CSV Jun 18
Enable code coverage Jun 16
sqlite-utils dump my.db command Jun 16
Idea: import CSV to memory, run SQL, export in a single command Jun 15
table.upsert_all() fails if input has a single column that should be a primary key Jun 13
db.schema property and sqlite-utils schema command Jun 11
Add some types, enforce with mypy Jun 7

simonw/datasette.io

4 closed

Content in pre blocks in Markdown is incorrectly urlified Jun 19
Broken markdown on the homepage Jun 19
Add a footer linking to the site code Jun 13
Better build scripts plus development documentation Jun 13

simonw/us-counties-datasette

3 closed

Basic county search Jun 16
12 counties have ambiguous names within their states Jun 16
DC is missing from the states list Jun 16

simonw/django-sql-dashboard

1 open 2 closed

willmcgugan/textual

1 open 1 closed

simonw/db-to-sqlite

2 closed

Can't load plugin: sqlalchemy.dialects:postgres Jun 11
Switch CI to GitHub Actions Jun 11

simonw/xml-analyser

2 closed

Use parent counts as a tie-breaker Jun 7
Support - to read from standard input Jun 7

Python-Markdown/markdown

1 open

Option to avoid automatic hyperlinking of URLs inside fenced code blocks would be useful Jun 19

simonw/asgi-csrf

1 open

Callback for skipping checks Jun 14

dogsheep/dogsheep-beta

1 closed

Searching for whitespace throws an error Jun 13

eyeseast/datasette-geojson

1 closed

Feature request: at least one bullet point in the release notes Jun 13

simonw/yaml-to-sqlite

1 closed

Ability to create a table from a list of items Jun 13

simonw/markdown-to-sqlite

1 closed

Should be markdown-to-sqlite DBNAME PATHS, not markdown-to-sqlite PATHS DBNAME Jun 13

simonw/datasette-mask-columns

1 closed

Switch to GitHub Actions Jun 10

simonw/datasette-placekey

1 open

Add a live demo instance to the documentation Jun 10

etianen/django-reversion

1 open

"Revert" feature in admin reverts entire revision, not specific version Jun 7

simonw/datasette-graphql

1 open

Upgrade bundled GraphiQL and React dependencies Jun 7

simonw/datasette-bplist

1 open

Switch to bpylist2 Jun 7

simonw/datasette-upload-csvs

1 closed

Defaults to uploading to _internal which is wrong Jun 7

avidal/fastlike

1 open

I'm not sure what -backend <proxy address> means Jun 5

Started 1 discussion in 1 repository

simonw/datasette

Requiring CSP protection for Datasette plugins and custom templates? Jun 6

Answered 2 discussions in 1 repository

simonw/datasette

Nice! Can be used to host blog? Jun 6
Add "Back" link to Invalid SQL page Jun 6

37 contributions in private repositories Jun 5 – Jun 21