4 ms·
OLAP and batch analytics is just getting so much more common. Thinking back 30 years ago, column stores were rare and SQL was all about OLTP CRUD. It still do
by willvarfar 10mo ago
OLAP and batch analytics is just getting so much more common. Thinking back 30 years ago, column stores were rare and SQL was all about OLTP CRUD. It still does all that, but it's also become mainstream as the data science and analytics becomes ever more routine and approachable too.
And the dialects of the language itself, SQL keeps getting more relaxed and interoperable and forgiving. With WITH and CTEs and things it keeps getting easier and cleaner to express things, so it's going steadily in the right direction. There are still a few slight differences in the syntax for window functions between bigquery and duckdb, for an example I fight often, but they are all a lot closer to each other today than they used to be back 30 years ago when you had to use SQL differently and construct complicated queries differently just to run on Oracle vs MySQL vs Postgres.