Is the double life with both JSON and SQL necessary? [medium/hard]

futurice / festapp-android

festapp Android client

http://futurice.github.io/festapp-server/

MIT License

12 stars 15 forks source link

Is the double life with both JSON and SQL necessary? [medium/hard] #53

Open wijnbladh opened 10 years ago

wijnbladh commented 10 years ago

Currently the App uses an SQL database, where it stores the information that arrives in JSON. Is the database really necessary, could flat files and/or a cache work just as well? Remember that networks may get very jammed in the festival area during the festival.

dwarfcrank commented 10 years ago

We, Robot 6, would like to work on this issue.

dwarfcrank commented 10 years ago

After looking at the code, we came to the following conclusion:

Removing the database does not simplify the code enough to justify the effort of building a new system for storing news. It also does not result in any meaningful performance improvements.
JSON will be parsed anyway, so getting rid of the database will not affect that.
It is useful to keep the database around as it makes merging multiple data sources (ie. JSON stored locally or in the web) much easier.