project-owl / dms-lite Goto Github PK

Issue: The try-block executing the "CREATE TABLE IF NOT EXISTS" query is unreachable.

Potential Solution: Move the try-block above the while-loop.

Currently, the bash install includes all packages. While this is fine, it would make more sense to have an option to select how the PaPi is interfacing with PaPiDuck (WiFi vs serial vs other).

When ready for release, create an easy to install disk image of a working v1.0 release

I noticed some quirks in Wifi-install.sh which are as follows:

• sqlite3 is contained in the Python 3 standard library and doesn't need to be installed, PyPi has no package with that name, hence the pip3 install sqlite3 line should be removed
• doubles dashes for curl paramters in the last line are wrong, it needs to be one dash
• the -y parameter for bash on Raspbian yields this error: bash: -y: invalid option, hence it should be removed from the script
• nodejs 10 installer gives big deprecation warnings, maybe update to 12 ? (I'm no expert on that matter)

Issue: Typo in serial_sqlwriter.py leads to wrong Date/Time format preventing the "online" detection of the ducks-view from working.

Solution: Change line nr. 26 in serial_sqlwriter.py from

theTime = strftime("%Y-%m-%d %Hs:%M:%S", gmtime())

to

theTime = strftime("%Y-%m-%d %H:%M:%S", gmtime())

Is this similar to the dashboard shown in Linus Tech Tips video?

The use of docker containers would simplify the deployment of the software and other operating systems (e.g. Ubuntu Linux, Hypriot OS, Balena OS) could be supported. Furthermore, dependencies can be better managed and the installation can be done via script.

Here is a link to an example that shows how a Node.js application can be dockerized: https://nodejs.org/fr/docs/guides/nodejs-docker-webapp/

Right now the PaPiDuck sends data to the PaPi using the PaPi's WiFi AP. While this works pretty well, there are openings for issues (such as problems connecting, security, using too much energy) and adds more complexity than necessary.

A more reliable solution would be to have a serial connection between the PaPi and PaPiDuck. This can be done using Tx and Rx pins or using a USB connection.

Issue: Currently there is no easy way to select data to export to CSV, Delete data, or Filter out Data

Potential Solution: Some buttons on the front-end that would allow users to easily manipulate the data and export to a CSV if wanted.

Issue: Currently you can only see your data in table format. While this is useful to see a log of all your data it would also be helpful to some users to be able to generate some simple graphs about their networks. See Examples

Ex: DMS-Lite can be used to inform a user about how their network is performing, the health of devices, sensor data, etc... Anything really that could enhance network management.

Ex: Some of the Clusterduck devices have the ability to send GPS coordinates so maybe an interactive maps page to visualize where your ducks may be deployed.

Probably not the right space to leave this issue ... but what replaced your "no longer active" https://project--owl.slack.com?
I would like to motivate at least one of my student to try this superb project idea.
Best regards
Fred
https://people.hes-so.ch/en/profile/jeanfred.wagen