3 ms·
My thought abstraction on this: Joins are what make database technologies... If you can call Excel a database technology... So powerful.
by anonu 7y ago
My thought abstraction on this: Joins are what make database technologies... If you can call Excel a database technology... So powerful.
- mabbo 7y agoA decade ago as an intern at Microsoft, I attended a talk by <distinguished engineer whose name I forget> about data systems. The thing I remember from it was: "In terms of total data stored, what data system do you think is the biggest in the world today? ... Probably Excel. Probably Excel by a lot." Excel has a simple mental model combined with powerful tooling. It's the most beautiful means to get non-technical people to start to think like a programmer. An acquaintance of mine tells a great story of how Excel and VBA got him into software: https://news.ycombinator.com/item?id=7950736 https://news.ycombinator.com/item?id=7950736.
- TacoToni 7y agoThis is amazing. I also found a love for programming after i learned some spaghetti VBA to create automated sales reporting at my finance job. Finally starting up CS degree in Jan 2020.
- agumonkey 7y agoExcel is an hybrid ball of things already. Reactive dataflow is one of them. So Join is not that much more to add.
- mikorym 7y agoExcel is to me basically a sequel database broken in a few key ways. And some people (a lot of...?) like it that way.
- EForEndeavour 7y agoAs an aside, this is the very first time I've ever seen "SQL" written out as "sequel."
- mikorym 7y agoNot deliberate; I just write things out as I say them and didn't review.
- OzCrimson 7y agoFor a lot of individuals and small businesses true databases have a tough learning curve. I commend the Excel developers for recognizing this and including things like Power Query and Power Pivot. They aren't there to completely replace databases, but they are a decent middle-ground for meeting people where they are.