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