Pavel Korytov :emacs:☮️ on Nostr: I've decided to do a project with #sqlite in #emacs. It's been a few years since I ...

I've decided to do a project with #sqlite in #emacs. It's been a few years since I used an RDBMS without an ORM.

SQLite is so weird in some ways:
- Foreign keys are disabled by default. You have to enable them on every connection;
- Arbitrary datatype names are allowed, which are implicitly cast to 5 "affinities". E.g., the name contains "int", therefore INTEGER.
- ...but you can make tables STRICT to disable that
- NULL values are distinct for UNIQUE constraints
- All joins are nested loops, which are executed in the order they are written in the query. Beware

Also, no transactional DDL, which I expected.

#sql