Simon Willison’s Weblog

Subscribe

Monday, 17th January 2022

SQLime: SQLite Playground (via) Anton Zhiyanov built this useful mobile-friendly online playground for trying things out it SQLite. It uses the sql.js library which compiles SQLite to WebAssembly, so it runs everything in the browser—but it also supports saving your work to Gists via the GitHub API. The JavaScript source code is fun to read: the site doesn’t use npm or Webpack or similar, opting instead to implement everything library-free using modern JavaScript modules and Web Components.

# 7:08 pm / javascript, sqlite, web-components, webassembly, anton-zhiyanov

TIL Streaming indented output of a JSON array — I wanted to produce the following output from a command-line tool:
Sunday, 16th January 2022
Tuesday, 18th January 2022

2022 » January

MTWTFSS
     12
3456789
10111213141516
17181920212223
24252627282930
31