Simon Willison’s Weblog

Subscribe

Friday, 28th October 2022

Welcome to hell, Elon (via) If you only read one thing about the Elon acquisition of Twitter make it this, by Nilay Patel. Outstanding insights into what it actually takes to to run a commercial social media service.

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

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

Thursday, 27th October 2022
Saturday, 29th October 2022

2022 » October

MTWTFSS
     12
3456789
10111213141516
17181920212223
24252627282930
31