Cecil Westerhof wrote: > my SQLite database contains for example: > > "5BF19111-9FD5-48CA-B919-A09411346A87" "[ > ""The journey of a thousand miles > must begin with a single step. > > - Lao Tzu"", > ""Welke stap kun je vandaag zetten, > om dat verre doel te bereiken?"" > ]" "2018-07-07" > > Respectively quoteID, quote (with extra line(s)) and lastUsed. > > Is this an acceptable way to implement it, or would it be better to unravel > the elements in different records?
Putting the quotes into a separate table, one per row, would allow you to access them individually. If you never need to access individual quotes, and if you know that this will never happen in the future, you could just as well keep storing the quotes as an array. (And then please tell us how you manage to predict the future. ;-) Regards, Clemens _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users