This program was specially developed for an animal welfare organization in order to save data of pangolins and to collaborative work together.
Following features are included: -Offline / Online Synchronization -Report generation for Pangolins (as Excel-File) -File upload / download -User managment -Team collaboration -Pangolin data managment
There are some features that could be security relevant to you -To be able to log in with multiple users in offline mode the local sqlite database also saves user data on client computer local database (usernames, passwordhash) -The following security features still need to be added: --> Adding salt values to each password --> encrypting local database
Requirements are: -You need at least windows 7; recommended: Windows 10 -To synchronize your data you need a MySQL or MariaDB Server; recommended: MariaDB
How to setup?
-
No MySQL-Server initialized: -Set up your MySQL / MariaDB Server (you can use the program XAMPP for instance) -Start the application and click in the left corner on "settings" -Set the Host (can be a domain or ip) and the port (default 3306 of MySQL) of your MySQL Server -Open initialize database menu -Enter a admin username and the password of your MySQL-Server -Click on initalize Database -Now you can log in with the default user "Admin" with password "admin" -Change Admin-Password in admin panel -Make sure to check "synchronize" if you log in the first time
-
MySQL-Server initialized: -Click on the settings "left corner" -Set up host and port (default 3306) -Then you can log in with your credentials -Make sure to check "synchronize" if you log in the first time
You need at least Visual Studio 2019
-
Enter the following command
$ git clone https://github.com/CodingTarik/Pangolin-Database-App.git
This program was created by Tarik Azzouzi and Nico Zeitz as a school project at the Berufliches Gymnasium Gelnhausen in cooperation with the Tikki Hywood Foundation.