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.  ;-)

sqlite-users mailing list

Reply via email to