Pain point · API & developer experience · Blocks work
No way to store NULL values in fields
1 source thread · first seen 2024-12
Summary
A user wanting a lightweight Firebase alternative finds PocketBase cannot store null values even though SQLite supports them, forcing magic constants or extra boolean columns.
- Affects
- developer storing optional numeric data
- Workaround
- Add a separate boolean column indicating whether the numeric column is filled
Evidence
Excerpts are copied word for word from the source; follow the link to read it in full.
“There's no ability to set null as a value of an item despite null being a perfectly valid data type in SQLite”