Reactive Programming for Databases


Slashdot has an interesting article by Val Huber.  Espresso Logic web site provides more detail on Reactive Service for SQL Data, which primarily creates REST API’s over databases, with the REST API injected into the path to the database, and thus offering the reactive layer.  No surprise to find JavaScript as the language of choice for the business logic (reactive layer).  Architecture overview available here.

Expose your enterprise data as RESTful APIs to customers and partners with complete row and field-level security – no programming

~ by mdavey on December 9, 2013.

3 Responses to “Reactive Programming for Databases”

  1. […] Reactive Programming for Databases (Matt Davey) […]

  2. This is very compelling technology. Full disclosure, I am the VP of BD at Espresso, and the writer of the article is our CTO. A common misconception is that reactive when used with databases is the same as triggers in a database. Not the case. Reactive expressions a purely declaratvie and straightforward to define – not the case with triggers, which are imperative, differ from DB to DB and much more difficult to code.

    A related aspect is performance. A well written reactive system for databases minimizes the impact of processing on middle tier and the database. In the case of Espresso, we minimize SQL quieries to the absolute minimum. For example, when applying updates to the database from related rows, rather than doing a select sum of child rows, we calculate the delta fron a transaction and post a single row update. in other cases, we prune the SQL to only the affected obects.

    In a prior version of this software, customers were running applications with many thousands of concurrent users, tables that numbered well over 500 tables on the J2EE platform – WAS and BEA. More papers on reactive at this location, http://www.espressologic.com/reactive-programming-resources/.

  3. Still, I am a bit apprehensive about the use of JavaScript without (to my knowledge) any alternatives.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: