Simon Willison’s Weblog

Subscribe

Saturday, 13th March 2021

TIL Querying for items stored in UTC that were created on a Thursday in PST — This came up as [a question](https://news.ycombinator.com/item?id=26443148) on Hacker News. How can you query a SQLite database for items that were created on a Thursday in PST, when the data is stored in UTC?
13th Mar 2021, 3:55 am
Release django-sql-dashboard 0.1a — Django app for building dashboards using raw SQL queries
13th Mar 2021, 5:31 am
Release django-sql-dashboard 0.1a2 — Django app for building dashboards using raw SQL queries
13th Mar 2021, 5:38 am
Release django-sql-dashboard 0.1a3 — Django app for building dashboards using raw SQL queries
13th Mar 2021, 5:50 am
Release hacker-news-to-sqlite 0.4 — Create a SQLite database containing data pulled from Hacker News
13th Mar 2021, 7:15 pm

2021 » March

MTWTFSS
1234567
891011121314
15161718192021
22232425262728
293031