view TODO.creole @ 36:59e1659a0a0b tip

Update 'TODO.creole' * Old TODOs moved to 'doc/old_TODO.creole'
author Magnus Schieder <mschieder@intevation.de>
date Mon, 26 Nov 2018 16:52:45 +0100
parents 33d7c7769155
children
line wrap: on
line source
=== Technical ideas
Keywords can change over time for a tracker, so collecting them
should not depend on a fixed database schema.

On idea is to save them as a JSON text in a {{{keywords}}} field.
This maybe given almost directly to a webbased display system
based on javascript.
The drawback is that SQL cannot be used to query by keyword details,
but advanced database functions can be used for improving this situation
like [[https://www.sqlite.org/json1.html|SQlite' JSON1 extension]].

The same could be used for priorities and status values, as they
could also change.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)