I ended up with date_, set_, dict_ prefixes.
date_
set_
dict_
is_ is also a nice prefix, but I think json_ prefixes in SQLite should avoided due to JSON1 extension functions also starts with json_.
is_
json_
dict_media TEXT NOT NULL DEFAULT '{}', set_cardId TEXT NOT NULL DEFAULT '{}', -- I wonder if this can be indexed date_nextReview DATETIME NOT NULL,
and, how to use
JOIN deck d ON json_extract(d.set_cardId, '$.'||c.uid) = 1
for (const k of Object.keys(r)) { const [k1, k2] = k.split('_') if (k2 && r[k]) { if (k1 === 'dict') { r[k2] = JSON.parse(r[k]) delete r[k] } else if (k1 === 'set') { r[k2] = Object.keys(JSON.parse(r[k])) delete r[k] } else if (k1 === 'date') { r[k2] = new Date(r[k]) delete r[k] } } }
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
I ended up with
date_
,set_
,dict_
prefixes.is_
is also a nice prefix, but I thinkjson_
prefixes in SQLite should avoided due to JSON1 extension functions also starts withjson_
.and, how to use