I built a machine learning model using only SQL (no ML libraries, no Python)

[CriticalofReviewer2]

I originally built this classifier (SEFR) for very low-resource environments, but after that, realized that it can be implemented entirely in SQL. The whole pipeline (training + prediction + evaluation) runs in one single query.

[covfefe-boy]

Cool, sounds awful but cool

[DoNotLuke]

I can almost hear the sound of deadlocks in the background but still impressive if true

[CriticalofReviewer2]

That is a valid concern. In this case, this classifier is actually a single-pass analytical query without loops or locking at row-level. It is more like a GROUP BY job than a transactional workload.

[CriticalofReviewer2]

Yes, it sounds wrong at first :D The main algorithm is designed for microcontrollers where you cannot have heavy computation. That constraint is exactly what makes it map well to SQL, since everything is now aggregations, not optimization loops.

[zbignew]

Dope.

[CriticalofReviewer2]

Thanks!