Currently working on Datasette and associated projects. Read my blog or follow @simon@simonwillison.net on Mastodon.
-
Datasette
- Half Moon Bay, CA
-
22:02
(UTC -07:00) - https://simonwillison.net/
- @simonw
Sponsors
Highlights
Block or Report
Block or report simonw
Report abuse
Contact GitHub support about this user’s behavior. Learn more about reporting abuse.
Report abusePinned
-
-
-
-
-
shot-scraper Public
A command-line utility for taking automated screenshots of websites
5,321 contributions in the last year
Less
More
Activity overview
Contribution activity
April 2023
Created 67 commits in 11 repositories
Created 3 repositories
- simonw/mastodon-to-sqlite Python
- simonw/sqlite-history Python
- simonw/llm Python
Created a pull request in myles/mastodon-to-sqlite that received 1 comment
Opened 3 other pull requests in 3 repositories
biglocalnews/datasette.biglocalnews.org
1
open
myles/mastodon-to-sqlite
1
merged
simonw/datasette
1
open
Created an issue in simonw/sqlite-history that received 40 comments
Initial design for a change tracking system for SQLite tables
Goal: On demand, create a snapshot backup of a table Ability to restore those snapshots Snapshots use minimal space, ideally by avoiding storing m…
40
comments
Opened 26 other issues in 9 repositories
simonw/sqlite-history
3
open
4
closed
- Document how to handle alter table
- Try saving space by not creating full duplicate history row until first edit
- Store changed timestamp in ms since the epoch, not seconds
- --all option confused by FTS tables
- Functions for restoring tables or individual rows
- Documentation should show the SQL triggers
- Can't handle tables with a column called "order" or other reserved words
simonw/llm
3
open
4
closed
simonw/datasette
4
open
myles/mastodon-to-sqlite
2
closed
simonw/simonwillisonblog
2
closed
dogsheep/swarm-to-sqlite
1
closed
dair-ai/Prompt-Engineering-Guide
1
open
simonw/datasette-lite
1
open
simonw/datasette-explain
1
closed
13
contributions
in private repositories
Apr 1 – Apr 11







