| 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`                                                                          |
