bernhard@18: === Technical ideas bernhard@18: Keywords can change over time for a tracker, so collecting them bernhard@18: should not depend on a fixed database schema. bernhard@18: bernhard@18: On idea is to save them as a JSON text in a {{{keywords}}} field. bernhard@22: This maybe given almost directly to a webbased display system bernhard@18: based on javascript. bernhard@22: The drawback is that SQL cannot be used to query by keyword details, bernhard@18: but advanced database functions can be used for improving this situation bernhard@18: like [[https://www.sqlite.org/json1.html|SQlite' JSON1 extension]]. bernhard@18: bernhard@18: The same could be used for priorities and status values, as they bernhard@18: could also change.