Truviso 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 Pearce, the company's president and CEO, points out, Postgres lets users of Truviso'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," Pearce 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 Truviso "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."