Set up data base for saving logs

SpyCop / cleanup-logger

Node.js Web application for visual logging on OSM of stray litter cleanup

0 stars 0 forks source link

Set up data base for saving logs #4

Open SpyCop opened 2 years ago

SpyCop commented 2 years ago

To save historical record of logs, a data base should be implemented

[x] Design a data base model
[ ] Implement a data base backend
[ ] #5

SpyCop commented 2 years ago

For a log model:

Points – array of lat long, get these from polygon creation event (might come from a GeoJSON object)
Bags of litter – between 0 and 5 float get these from a user form on creation
Date time – add date picker, or day picker for a week back?
Picker name – string or connection to simple user model?

For implementation, maybe use sequelize like in SpyCop/better-chat-app

SpyCop commented 2 years ago

A newer/better idea is to use Elasticsearch. This needs to be set up in such a way that the NodeJS app can interact with it as database, and allows for saving and querying on the JSON data in the app