To enable SQL to query infinite data streams, Amalgamated extended it in two ways, adding a windowing capability to restrict the amount of data it would be exposed to in any instant and adding some "syntactic sugar" to define event patterns you might want to inspect. The "continuous analysis" engine is adaptive, Franklin says, meaning you can add or remove queries on the fly.

Amalgamated sees the decision to embed the core processing engine in Postgres not only as key to advancing the development effort, but also as a key differentiator in the marketplace. Franklin notes that it gave the solution complete SQL, JDBC and ODBC interfaces, internationalization, and all of the extensibility of Postgres right out of the box.

As Boyd Pierce, the company's president and CEO, points out, Postgres lets users of Amalgamated's engine to write SQL that joins tables and streams, provides subqueries and views, and does all the magic that SQL can do. Programmers already know how to code in it.

"We got all that based on having Postgres," Pierce notes. "But the other thing we've found in dealing with customers in our application space is that if you don't have a relational database that speaks full SQL and lets people program, you're hugely disadvantaged in terms of doing what the customer needs."

Noting that Postgres allowed Amalgamated "to jump in front of a 10-year database systems development curve," Franklin sees a larger lesson in building on the open-source database.

"We really hit upon what I think is the future of enterprise software development," he concludes. "If you start from scratch today, if you're building anything complex, you're crazy. That's just not going to be a viable way to build enterprise software in the future. You're going to have to leverage open source and other available tools that are out there."