# HG changeset patch # User Magnus Schieder # Date 1543246640 -3600 # Node ID b07588ac28b6d55ad7a2884692e855783c549a08 # Parent 916fa83b4144e0d65a7b4287e0d558626f7cb1b8# Parent 10167e40a657211737a8c6eb5578eb7ef4c40bae Merge diff -r 916fa83b4144 -r b07588ac28b6 TODO.creole --- a/TODO.creole Mon Nov 26 16:08:27 2018 +0100 +++ b/TODO.creole Mon Nov 26 16:37:20 2018 +0100 @@ -21,9 +21,9 @@ should not depend on a fixed database schema. On idea is to save them as a JSON text in a {{{keywords}}} field. -This maybe be given almost directly to a webbased display system +This maybe given almost directly to a webbased display system based on javascript. -They drawback is that SQL cannot be used to query by keyword details, +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]]. diff -r 916fa83b4144 -r b07588ac28b6 collect_issues.py --- a/collect_issues.py Mon Nov 26 16:08:27 2018 +0100 +++ b/collect_issues.py Mon Nov 26 16:37:20 2018 +0100 @@ -5,6 +5,7 @@ author: Bernhard Reiter author: Sean Engelhardt author: Magnus Schieder + (c) 2010, 2015, 2018 by Intevation GmbH This is Free Software unter the terms of the