Скачать или смотреть ambient Linear regression + stats in PostgreSQL

This is a very simple set of three SQL queries demonstrating how in-server data processing can enable some basic data analytics. It may seem mute when this can be easily done with Python or other code in fewer lines. But pushing the data processing part within the RDBMS server via properly crafted SQL can enable ultra-low-power IoT devices with absolutely minimal memory and processing resources (for example a micro-controller) to do stuff that are typically unfeasible otherwise.

See the full video at the Youtube channel central. Enable captions for more details and walk-through. Source code available at the Github repository (see channel info).
#ambient #coding #programming #notalking #terminal #console #sql #postgresql #shorts #short #shortsvideo #shortvideo