alexwlchan
This website is a static website, built with a static site generator I wrote myself. When I’m working on the site locally, I want it to build quickly. The site is relatively small, modern computers are overflowing with power, so I don’t want to be waiting. Rendering all the HTML pages takes about...
alexwlchan’s notes
SQLite uses schema prefixes like main and temp to disambiguate between attached databases and connection-specific temporary tables.I was reading the SQLite database queries in the Tailscale source code today, and tables are referred to inconsistently: the schema creates tables like CREATE TABLE...
alexwlchan’s notes
It can identify a SQLite database and give you basic information about the version, page count, encoding, and more.Here’s a neat trick that Percy showed me today: the file(1) command is able to recognise SQLite databases, and print some information about the structure of the database. Here’s an...