Mercurial > roundup-cc
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.