SQLite vs. PostgreSQL

I like both databases, but there are some downsides and/or gotchas to SQLite that aren't covered here. Examples are:

- forgetting to use STRICT

- realising you actually did need complicated concurrency options like SKIP LOCKED or multiple writers

- discovering you need to add a read-only user for an analytics tool and suddenly everything becomes a lot harder because SQLite doesn't do networks or replicas or users

There are also certain things that have workarounds but aren't nice to work with, like FULL OUTER JOIN or ALTER TABLE.