First Espresso Logic created a way to generate APIs out of the stored procedure calls commonly used in SQL databases. Now the company is extending the same capability to NoSQL databases starting with MongoDB.
Expresso Logic today announced an update to Espresso, its tool for automatically generating RESTful APIs that can now be applied to both SQL and NoSQL databases.
Espresso Logic CEO R. Paul Singh says that in addition to being able to generate RESTful APIs for MongoDB, Espresso can also be used to perform the equivalent of a “virtual join” between two disparate instances of MongoDB. As Espresso Logic extends support to other NoSQL databases, Singh says that IT organizations should be able to extend that functionality to include joins across multiple NoSQL and SQL databases.
Most uses of Espresso, says Singh, have been by developers who are trying to make structured data in a SQL database more accessible. But given all the interest in NoSQL databases, Singh says it’s only logical that developers would want to take advantage of a common mechanism for integrating both structured data and massive amounts of big data stored in a NoSQL database.
While most organizations are still trying to figure out how to generate business value from their big data investments, the one thing they don’t want to do is replicate the data they have already captured in a structured format. For that reason, SQL has emerged as the dominant programming language for both relational and NoSQL databases.
Once those investments are made, however, developers need tools that help automate the generation of RESTful APIs that those SQL calls generate. While the creation of the basic API is usually pretty simple, Singh says that in enterprise IT environments the logic associated with making sure that API is secure can be especially complex. All of that can be accomplished using Espresso Logic by writing as few as a couple of lines of code, says Singh.
The biggest problem when it comes to data access in the enterprise has always been complexity. Massive amounts of data are already stored in SQL databases that developers should be able to more easily take advantage of when building applications. Now that same issue is about to raise its head when trying to access NoSQL databases that will contain several orders of magnitude more data.