Comment on SQLite as a Document Database (2020)Comments−mococa13dIn 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}Andlocal anotherprop = cassette.leprop−nonethewiser13dAre you doing this because you also use SQLite for other relational data?−mococa13dPossibly yes, otherwise I could use another simple solution
Comments
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?
Possibly yes, otherwise I could use another simple solution