HTML5 Follow on thought ... and how it applies to Notes SQL

April 20 2010

So after I showed the amazing HTML 5 Presentation to Nathan Freeman, he said the following to me:

6:34:02 PM hrmm
6:34:08 PM I wonder...
6:34:15 PM the JS SQL API...
6:34:25 PM can you write a driver for the SQL backend?
6:34:36 PM John D Head im not sure
6:34:49 PM wouldn't that be interesting?
6:34:53 PM John D Head of course
6:35:00 PM cause then you could use SQL as a declarative syntax
6:35:06 PM would be a reason to revive NotesSQL

Nathan of course was talking about Slide 8 - JS APIs : Web SQL Database. Go play with that slide. And then, assuming you are using Chrome, go look at what it did. Here is a screen shot:

Image:HTML5 Follow on thought ... and how it applies to Notes SQL

So we now have a local database in the browser that takes SQL commands. It seems to be installed by default with Google Chrome (not sure of other browsers, will need to check). What if we had a modern day Notes SQL driver that allowed a web app to talk to Domino via SQL. What if IBM Project Vulcan's web client could merge data in an NSF and data in a local database into a single UI presentation? Is this just limited to client browser apps or does this have implications of what could become the next DB2NSF?

Now, none of this discussion comes from any private knowledge of IBM Project Vulcan. As far as I know, there has been zero discussion about anything beyond 8.5.2 with the Design Partner crowd. This is just me and Nathan talking out loud. But from where I sit, it does seem that using the core functionality of Xpages with HTML5 and CSS3 functionality (that IBM would add), this becomes the future client platform for IBM Lotus. No matter if it inside a managed client like Notes or from a browser or a mobile device.

It also says that allowing for external data sources to be surfaced into an Xpage should be a feature high on IBM's to-do list (pretty please). And just as Nathan wonders, I wonder if anyone inside IBM is working on Notes SQL Next. Only time will answer that :-) I think we also need to answer Nathan's question of "Can you write a driver for the SQL back end?" - because if you can, wow that is powerful.

5 Responses to “HTML5 Follow on thought ... and how it applies to Notes SQL”

  1. 1) Mark Hughes says:

    8.5.2 also offers another HTML 5 feature you would want to use for offline data, the cache manifest, you can now set this on the xpage properties

  2. 2) Mark Hughes says:

    One problem with trying to take an xpage offline is that the local browser can not render an xpage. Correct?

  3. 3) Dwight Wilbanks says:

    I have not looked at all into what your talking about, but after reading, my initial thought was, if its coming from google chrome, my guess is that its http based, I don't know how its setup, but, also my guess is that you have a URL for defining your database, then a URL for parsing a request & a syntax for responding to requests.

    Now that my assumptions are defined, my thought is: could an OpenAgent do anything for you?

  4. 4) John Head says:

    Mark - not sure if the 8.5.2 feature is a true implementation of HTML cache manifest. I think IBM needs to implement Webkit into the server and let Xpages take advantage of that first. But I personally believe that is a first step in the IBM Vulcan Process, as it will give them HTML5 and CSS3 support pretty quickly. And no, I do not think you can take an Xpage offline with Gears or HTML5 yet.

  5. 5) John Head says:

    Dwight - its not a URL, there is javascript that does this. Such as "tx.executeSql" and more. Combine that with the local storage and you get a fairly powerful yet lightweight storage system. Now, IE and FF don't seem to have that storage part yet, but I am sure it will get there. Just thinking out loud about some of the cool stuff happening and the direction IBM could take.

Leave a Reply