Simon Willison’s Weblog

Subscribe

October 2022

68 posts: 8 entries, 28 links, 3 quotes, 29 beats

Oct. 28, 2022

The essential truth of every social network is that the product is content moderation, and everyone hates the people who decide how content moderation works. Content moderation is what Twitter makes — it is the thing that defines the user experience.

Nilay Patel

# 3:45 pm / moderation, social-media, twitter, nilay-patel

TIL Finding the SQLite version used by Web SQL in Chrome — Google Chrome still includes support for [Web SQL](https://www.w3.org/TR/webdatabase/), the long since abandoned proposed standard for shipping a SQL engine in browser JavaScript. I was reminded of its existence today while reading about the new official [sqlite3 wasm build](https://sqlite.org/wasm/doc/tip/about.md).

About the sqlite3 WASM/JS Subproject. SQLite now maintains an official WebAssembly build. It’s influenced by sql.js but is a fresh implementation with its own API design. It also supports Origin-Private FileSystem (OPFS)—a very new standard which doesn’t yet have wide browser support that allows websites to save and load files using a dedicated folder on the host machine.

# 11:05 pm / javascript, sqlite, webassembly

Oct. 29, 2022

Release json-flatten 0.3 — Python functions for flattening a JSON object to a single dictionary of pairs, and unflattening that dictionary back to a JSON object
TIL git bisect — I extracted and enhanced this TIL from [my April 8th 2020 weeknotes](https://simonwillison.net/2020/Apr/8/weeknotes-zeit-now-v2/#git-bisect) to make it easier to find.

The Perfect Commit

For the last few years I’ve been trying to center my work around creating what I consider to be the Perfect Commit. This is a single commit that contains all of the following:

[... 2,061 words]

Oct. 31, 2022

mitsuhiko/insta (via) I asked for recommendations on Twitter for testing libraries in other languages that would give me the same level of delight that I get from pytest. Two people pointed me to insta by Armin Ronacher, a Rust testing framework for “snapshot testing” which automatically records reference values to your repository, so future tests can spot if they change.

# 1:06 am / armin-ronacher, testing, rust, pytest

TIL The pdb interact command — Today [Carlton told me](https://twitter.com/carltongibson/status/1587155176590385159) about the [interact command](https://docs.python.org/3.10/library/pdb.html#pdbcommand-interact) in the Python debugger.

2022 » October

MTWTFSS
     12
3456789
10111213141516
17181920212223
24252627282930
31