Spreadsheets are the most popular declarative (or zero order functional) languages in the world. There were even talks about spreadsheets on the International Conference on Functional Programming 2009.
Re:The story BCG offered me $16,000 not to tell
by ramchip on Sunday April 11, 2010 @11:58PM
(#1258372)
You can now do stuff like that in a lot of languages, but it's relatively recent
Saying "Lisp had it X years ago" sounds perhaps a little weenish, but... that sounds a lot like the Cells library, and the even older Garnet KR. Granted, they're quite a lot less accessible than spreadsheet programs.
FRP seems to be modern take on it. It's being very actively researched in the Haskell community.
Re:The story BCG offered me $16,000 not to tell
by gjm11 on Monday April 12, 2010 @12:08PM
(#1259480)
Visicalc: 1979. Excel: 1985. Garnet: early 1990s. Cells: 2000 or so.
On the other hand ... Sketchpad: 1963. (Constraint satisfaction, but not embedded in a general-purpose programming system.) Prolog: 1972. And Guy L Steele wrote a nice general-purpose constraint system in 1978. ("Constraints", MIT AI Memo 502.)
Re:The story BCG offered me $16,000 not to tell
by CWuestefeld on Monday April 12, 2010 @01:44PM
(#1259826)
Twenty-plus years ago I wrote a complete blackjack game in a spreadsheet, all using 1-2-3 "slash" macro commands (not VBA or anything like that). It even did insurance and doubling-down. I was part of the team testing the product, and each of us on the test team built a different casino game -- one guy did craps, and found a bug in the random number generator.
Once you get your brain around the paradigm, it can be a powerful tool.
Not necessarily a good idea, but somehow it caught on. One possible reason is that it was one of the earlier widely available pieces of software for doing declarative, dependency-based modeling that auto-propagates updates: if box A and box B are linked by a "B = 2*A", then B auto-updates whenever A changes, without you manually writing a propagate-updates loop. You can now do stuff like that in a lot of languages, but it's relatively recent (e.g., it's one of the new features JavaFX variables have).