Granularity of tools seems to separate different developers. Professional developers use scripting tools, Business developers visual tools. How much granularity can BizDevs stomach, we may have reach the limit already. Then, that points to Enterprise App Stores?
Ok, but how to deal with overlapping business logic and customization, back to Professional Developers…
Until very recently one of the more difficult operations to perform in SQL was a top-K query, for example, finding the five highest priced items in for every store in a retail database. But so-called window functions, which make such queries easy to express, have become part of the SQL standard and are now natively supported in Postgres.
Window functions are powerful because they provide a “split-apply” functionality, otherwise known as a map function. Combine these with SQL’s GROUP BY operations, which is a reduce function, and you have achieved – voila! – map-reduce in SQL. And as with all map functions, window operations are massively parallelizable (something that has not gone unnoticed by some commercial vendors.)
I run a small software business in central Japan. English-language reporting on the matter has been so bad that my mother is worried for my safety, so in the interests of clearing the air I thought I would write up a bit of what I know. - MicroISV on a Shoestring