In my personal project (a game) I use an indexed key + a JSONB to store the save state, which comes from Lua.
So I can have cassette.propxyz = {1, 2, “abc”, true}
And
local anotherprop = cassette.leprop
Are you doing this because you also use SQLite for other relational data?
Are you doing this because you also use SQLite for other relational data?