Simon Willison’s Weblog

Subscribe

Friday, 24th January 2020

Generated Columns in SQLite (via) SQLite 3.31.0 released today, and generated columns are the single most notable new feature. PostgreSQL 12 added these in October 2019, and MySQL has had them since 5.7 in October 2015. MySQL and SQLite both offer either “stored” or “virtual” generated columns, with virtual columns being calculated at runtime. PostgreSQL currently only supports stored columns.

# 4:20 am / mysql, postgresql, sql, sqlite

2020 Web Milestones (via) A lot of stuff is happening in 2020! Mike Sherov rounds it up—highlights include the release of Chromium Edge (Microsoft’s Chrome-powered browser for Windows 7+), Web Components supported in every major browser, Deno 1.x, SameSite Cookies turned on by default (which should dramatically reduce CSRF exposure) and Python 2 and Flash EOLs.

# 4:43 am / chrome, csrf, flash, ie, javascript, python, web, deno, samesite

2020 » January

MTWTFSS
  12345
6789101112
13141516171819
20212223242526
2728293031