| Logical type | PostgreSQL | SQLite notes |
|---|---|---|
| strings | `TEXT` (or `VARCHAR`) | `TEXT` - SQLite ignores the length specifier
anyway | | booleans | `BOOLEAN DEFAULT FALSE` | declare as `BOOLEAN`; Diesel
serialises to 0 / 1 so this is fine | | integers | `INTEGER` / `BIGINT` | ditto
| | decimals | `NUMERIC` | stored as FLOAT in SQLite; Diesel's `Numeric`
round-trips, but beware precision | | blobs / raw | `BYTEA` | `BLOB` |
