The MEILI Database is the backend storage module for the MEILI System and has the following functionality:
- Storage
- data collected by the MEILI Mobility Collector clients (GPS locations fused with accelerometer readings)
- data annotated by the same clients using the MEILI Travel Diary (trips and triplegs)
- Functions for
- CRUD operations for MEILI Travel Diary
- pagination operations for MEILI Travel Diary
- API specific operations for the backend part of MEILI Travel Diary
The MEILI Database is written (and licensed) for academic purposes, and as such, it is a proof of concept and SHOULD NOT be used as it is in production. Complex issues such as performance tunning, security, anonymization and any further development should be addressed by experts before running it in production.
1.0.0
The MEILI Database is built on Postgres 9.3 and uses PostGIS 2.1.7.
Set up your database, go to the location of init.sql and run:
$ psql -U yourUsername -d yourDatabase -a -f init.sql -v ON_ERROR_STOP=1Install pgTap, go to the Unit_Tests folder and run:
$ chmod +x script.sh
$ ./script.sh db_name user_nameWant to contribute? Great! See the Todos list for needed improvements. Also, you can contact me on github or my email address for further details.
- Use different roles for calling functions, based on the necessary permissions
- Generate test data
For any inquiries regarding setting up MEILI in production, you can contact the team leader for the MEILI system project (see http://adrianprelipcean.github.io/)
This DATABASE is made available under the Open Data Commons Attribution License (ODC-By) v1.0. It is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
Copyright © 2014-2016 Adrian C. Prelipcean - http://adrianprelipcean.github.io/ Copyright © 2016 Badger AB - https://github.com/Badger-MEILI
You should have received a copy of the Open Data Commons Attribution License (ODC-By) v1.0 along with this program. If not, see http://opendatacommons.org/wp-content/uploads/2010/01/odc_by_1.0_public_text.txt