search

stats4sd / Portal-de-Quinua

Mobile app to provide information for quinua farmers in the Andes region
GNU General Public License v3.0
1 stars 0 forks source link

Do we need databases at all? #16

Closed chrismclarke closed 8 years ago

chrismclarke commented 8 years ago

So I've been thinking, seeing as we're predefining all the queries and not generating them on the fly (correct?), doesn't it just make sense to also run them and store all the query names, text and results in a seperate file to import?

This is essentially what we were planning on doing by running queries at the start anyway, but this way instead of every user having to go through this initialisation process we just do it once per app build.

chrismclarke commented 8 years ago

Following skype call tentative plans is:

  1. Set of main initiatlisation queries predefined and saved in json file. This json file will need to be updated manually whenever new data is added and app updated. This should hopefully also enable basic functionality on older phones (?)
  2. Ability to run custom queries for use in later functionality. These queries should be able to be stored locally so as not to be rerun everytime same info is sought, however some mechanism will need to be put in place so they are recached when new data is added. A sensible naming system will need to be added to help know what queries have been cached.