Skip to content
Avatar
  • Block or report user

    Block or report simonw

    Block user

    Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

    Report abuse

    Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

    Report abuse
2.1k followers · 133 following · 1.2k

Highlights

simonw/README.md

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

Recent releases

datasette-indieauth 1.2 - 2020-11-19

datasette-copyable 0.3.1 - 2020-11-14

datasette-search-all 1.0 - 2020-11-12

sqlite-utils 3.0 - 2020-11-08

sqlite-fts4 1.0.1 - 2020-11-06

csvs-to-sqlite 1.2 - 2020-11-03

datasette 0.51.1 - 2020-11-01

datasette-configure-fts 1.1 - 2020-11-01

More recent releases

On my blog

Implementing IndieAuth for Datasette - 2020-11-18

Personal Data Warehouses: Reclaiming Your Data - 2020-11-14

Weeknotes: sqlite-utils 3.0 alpha, Git scraping in the zeitgeist - 2020-11-07

Datasette 0.51 (plus weeknotes) - 2020-11-01

Weeknotes: incremental improvements - 2020-10-24

More on simonwillison.net

TIL

Dropdown menu with details summary - 2020-11-01

Decorators with optional arguments - 2020-10-28

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

More on til.simonwillison.net

Build README How this works

Pinned

  1. datasette

    An open source multi-tool for exploring and publishing data

    Python 4.1k 232

  2. sqlite-utils

    Python CLI utility and library for manipulating SQLite databases

    Python 265 18

  3. csvs-to-sqlite

    Convert CSV files into a SQLite database

    Python 522 44

  4. dogsheep/twitter-to-sqlite

    Save data from Twitter to a SQLite database

    Python 161 8

  5. dogsheep/github-to-sqlite

    Save data from GitHub to a SQLite database

    Python 78 6

  6. datasette-graphql

    Datasette plugin providing an automatic GraphQL API for your SQLite databases

    Python 25 2

6,469 contributions in the last year

Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Mon Wed Fri
Learn how we count contributions.
Less
More

Contribution activity

November 2020

Created 115 commits in 15 repositories
Created 1 repository

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

table.search() improvements plus sqlite-utils search command

Refs #192. Still needs tests.

+425 −57 • 3 comments
Opened 2 other pull requests in 1 repository
simonw/datasette
2 merged
Reviewed 1 pull request in 1 repository

Created an issue in simonw/sqlite-utils that received 19 comments

Introspect if table is FTS4 or FTS5

I want .search() to work against both FTS5 and FTS4 tables - but sort by rank should only work for FTS5. This means I need to be able to introspec…

19 comments
Opened 59 other issues in 12 repositories
simonw/datasette-indieauth
22 closed 1 open
simonw/datasette
11 open 4 closed
simonw/sqlite-utils
1 open 8 closed
simonw/datasette-search-all
3 closed
simonw/datasette-graphql
2 open
encode/httpx
1 open
simonw/datasette-copyable
1 closed
simonw/simonwillisonblog
1 closed
simonw/datasette-cluster-map
1 open
alex/nyt-2020-election-scraper
1 closed
polm/posuto
1 open
simonw/sqlite-fts4
1 closed
Started 1 discussion in 1 repository
5 contributions in private repositories Nov 2 – Nov 12

Seeing something unexpected? Take a look at the GitHub profile guide.

You can’t perform that action at this time.