Processing Data from End Devices. (draft exploration)

 

https://www.flickr.com/photos/160422661@N07/49717997972/in/datetaken/

end device capture and database side code
update with http://reactivex.io/documentation/observable.html 

with an interesting link??:
why? we might have multiple threads and we need to handle them asynchronously. see ryan dahl's node.js talk:
https://www.youtube.com/watch?v=jo_B4LTHi3I

https://www.youtube.com/watch?v=CrZL-A2v0s0  (end devices side w/ http get on laptop)

https://www.youtube.com/watch?v=lS5El3wH6XA (subset: sensor to lora board)



Utilized links:
https://heltec-automation-docs.readthedocs.io/en/latest/esp32/quick_start.html
https://stackoverflow.com/questions/6768793/get-the-full-url-in-php
https://developer.couchbase.com/documentation/server/3.x/developer/java-2.0/observables.html
https://reactphp.org/http-client/
https://www.php.net/manual/en/function.var-dump.php
https://stackoverflow.com/questions/7492145/php-mysql-insert-new-record-into-table-with-auto-increment-on-primary-key
https://stackoverflow.com/questions/5665571/auto-increment-in-phpmyadmin
https://stackoverflow.com/questions/3137925/mysql-maxid-called-from-php-produces-strange-value
https://www.php.net/manual/en/function.date.php
https://stackoverflow.com/questions/14912943/how-to-print-current-url-path
https://stackoverflow.com/questions/7537377/how-to-include-a-php-variable-inside-a-mysql-statement
https://stackoverflow.com/questions/6768793/get-the-full-url-in-php
https://www.php.net/manual/en/mysqli.query.php
https://www.thegeekstuff.com/2017/05/php-mysql-connect/
https://mediatemple.net/community/products/dv/204643880/how-can-i-create-a-phpinfo.php-page
https://hostadvice.com/how-to/how-to-enable-apache-mod_rewrite-on-an-ubuntu-18-04-vps-or-dedicated-server/
https://linuxize.com/post/show-tables-in-mysql-database/
https://www.petefreitag.com/item/516.cfm (installing php on apache 2)
https://ubuntuforums.org/showthread.php?t=1001780 (reset apache2 back to default)
https://stackoverflow.com/questions/12224431/create-a-root-password-for-phpmyadmin
https://stackoverflow.com/questions/37879448/mysql-fails-on-mysql-error-1524-hy000-plugin-auth-socket-is-not-loaded
https://tableplus.com/blog/2018/11/what-is-the-default-username-password-in-mysql.html
https://stackoverflow.com/questions/11657829/error-2002-hy000-cant-connect-to-local-mysql-server-through-socket-var-run
https://linuxconfig.org/how-to-reset-root-mysql-password-on-ubuntu-18-04-bionic-beaver-linux
https://support.rackspace.com/how-to/mysql-resetting-a-lost-mysql-root-password/
https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-18-04
https://github.com/Embedotronics/Sending-Temperature-and-Humidity-Data-to-MySQL-Server-PHPMYADMIN-using-Arduino/blob/master/DHT11_data_to_phpmyadmindatabase.ino (see related YouTube video)https://www.sitepoint.com/community/t/class-calling-external-function/3514
https://www.php.net/manual/en/function.var-dump.php
https://packagist.org/packages/react/react
https://reactphp.org/http-client/
https://requests.ryanmccue.info/
http://reactivex.io/documentation/observable.html
https://developer.couchbase.com/documentation/server/3.x/developer/java-2.0/observables.html
https://github.com/ReactiveX/RxPHP
https://www.php.net/manual/en/function.preg-filter.php
https://reactphp.org/event-loop/
https://www.gnu.org/software/grep/manual/grep.html#Generic-Program-Information
https://www.php.net/manual/en/context.http (simple http request. no library)