annotate 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
rev   line source
18
325757454907 Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff changeset
1 === Technical ideas
325757454907 Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff changeset
2 Keywords can change over time for a tracker, so collecting them
325757454907 Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff changeset
3 should not depend on a fixed database schema.
325757454907 Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff changeset
4
325757454907 Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff changeset
5 On idea is to save them as a JSON text in a {{{keywords}}} field.
22
33d7c7769155 Fix typos in TODO.creole (minor)
Bernhard Reiter <bernhard@intevation.de>
parents: 19
diff changeset
6 This maybe given almost directly to a webbased display system
18
325757454907 Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff changeset
7 based on javascript.
22
33d7c7769155 Fix typos in TODO.creole (minor)
Bernhard Reiter <bernhard@intevation.de>
parents: 19
diff changeset
8 The drawback is that SQL cannot be used to query by keyword details,
18
325757454907 Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff changeset
9 but advanced database functions can be used for improving this situation
325757454907 Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff changeset
10 like [[https://www.sqlite.org/json1.html|SQlite' JSON1 extension]].
325757454907 Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff changeset
11
325757454907 Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff changeset
12 The same could be used for priorities and status values, as they
325757454907 Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff changeset
13 could also change.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)