News for hackers. Stuff that matters.
Re:Ask HN: Does anyone else think SQL needs help? by setr on Sunday September 11, 2022 @11:58PM (#32805931)
Relational databases are perfect for data analysis scenarios, especially when it fits in a single server. Why are you pumping data over the network, and serializing/deserializing it from a table structure usually back into a table structure, when you could just process it , often using only the data in the datastore, and pipe the final computed results over?

Hell they even have a name for databases specialized for this usecase — OLAP

The problem is that databases, and SQL, are such a pain to extend and define sufficiently general operations that you don’t just have scipy in the database, and thus your complicated analytics have to be fully specified with the few rudimentary analytic functions that are actually provided to you.

Re:Ask HN: Does anyone else think SQL needs help? by ttfkam on Monday September 12, 2022 @09:41AM (#32810083)
https://madlib.apache.org/

https://docs.timescale.com/timescaledb/latest/how-to-guides/...

https://duckdb.org/2022/05/04/friendlier-sql.html

It's a shame that so many people regard SQL using the reference SQL92 spec when in fact that it is continually evolving and improving like any other language still in use.