> Missing sqlite comparison point: data types. SQLite is like JS with column datatypes, except even looser. Also defaults: - sqlite has STRICT tables, you hav

> Missing sqlite comparison point: data types. SQLite is like JS with column datatypes, except even looser. Also defaults: - sqlite has STRICT tables, you have to opt in, per table. - sqlite does not check foreign keys by default, you have to opt in, per connection. - sqlite has WAL mode, you have to opt in, per database. And even with that you may want / need to add a fair amount of work to ensure you're not upgrading connections lazily (fecking SQLITE_BUSY).