dbi services Blog
Welcome to the dbi services Blog! This blog focuses on IT infrastructure - featuring news, troubleshooting, and tips & tricks. It covers database, middleware, and OS technologies such as Oracle, Microsoft SQL Server, Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on the postings!
Oracle Open World 2013: Day three - WebSocket and Apex
This is my third day at San Francisco and the Oracle Open World. In this posting, I will focus on an Oracle application express WebSocket session. I also wanted to share a nice lunch at the Yerba Buena Gardens with you - have a look at the pictures.
And the concert:
Let's come back to the OOW sessions.
The plan for my third day was as follows:
- Hardware and software, Engineered to Work Together
- Oracle Application Express WebSocket (or When Push Comes to Shove)
- Enhanced Availability Options in Oracle Coherence
- Cloud Keynote (Larry Ellison presentation was cancelled - The Oracle Team fighting to get the America's cup and he was by their side to support)
- Oracle Database 12c Application Continuity and Transaction Guard
As you will see, this blog post will be very short. I will just cover the Oracle application express WebSocket session because it surprised me.
During the session, John Scott from Apex Evangelist explained the concept of WebSocket. This new web feature has emerged since the arrival of HTML5 and was standardized by W3C. WebSocket is a bi-directional and full duplex communication channel over a single TCP connection. To make it short, a server can push information to all web browsers that are connected.
I was able to get a new vision of the web possibilities.
I will now go deeper into the explanation of this new feature. I will only explain what the speaker demonstrated during his session.
To me, the most interesting demonstration was "Report notification received when other users change report information".
Report notification received when other users change report information
When a user changes a record on a form that impacts some reports (a list must be maintained) it's possible to refresh the report through WebSocket and notify the connected user directly that the report content has been changed by other users.
All connected users have the most accurate data directly. It is interesting to have real time data at the stock exchange.
- Other WebSocket sample usages
- Real time analytic graphic reload on data change
- Broadcasting message (maintenance was scheduled, you have 5 minutes to save your change. In other case data will be lost)
Another interesting demonstration that surprised me: Via his iPhone, the speaker made a rotatation and was able to rotate the application screens of all connected users. Very impressive.
For this demonstration, an application was installed on the iPhone to be able to send the rotation information to the connected applications.
In my mind, WebSocket is a revolution coming with HTML5 for web development.
Another day in the Oracle "Open World" with lots of interesting information acquired!