Today I learned that SQLite doesn't have array types
Pontifications
- Today I learned that SQLite doesn’t have array types; just NULL, INTEGER, REAL, TEXT, BLOB.
- Therefore if I want to store json with arrays, I can
- a) store the JSON in a blog
- b) put the arrays in a separate table
- c) flatten the arrays into a string or some such kludge
- I’ll probably do c) first and then b) later for my Firefox support analyst notes