11 ms·
IIRC Sqlite stores all data types as text. It seems like a very weird decision to me.
by nick_ 3y ago
IIRC Sqlite stores all data types as text. It seems like a very weird decision to me.
- ncruces 3y agoThis is wrong. Integers (in SQLite columns) are stored as varints and floats as IEEE 754 doubles. Numbers in JSONB are stored as text.