RO SDK - HTML5/Ajax/JS Frameworks

Remoting SDK
1

Hi there

What would interest me is what is the recommended approach in “connecting” an RO SDK backend server (not DA) with a typical HTML5/Ajax/JS Frameworks like jQuery, YUI, Ext JS, Dojo, Kendo UI, etc…

I see that RO SDK can provide data in various ways -> There is a JS library providing access througt the BIN protocol. There are also options for SOAP/XML, RPC-XML, RPC-JSON (?), etc…

How do you guys use RO SDK to connect to what HTML5/Ajax/JS frameworks?

What I see is that these frameworks do often provide some kind of data-abstraction layers (like a Delphi datasource) to help/provide databinding to their widgets.

These approaches are usually strongly oriented toward REST/JSON having on the server side some PHP backend part.

Example, Kendo UI says: “…The DataSource component is an abstraction for using local (arrays of JavaScript objects) or remote (XML, JSON, JSONP) data. It fully supports CRUD (create, read, update, delete) data operations and provides both local and server-side support for sorting, paging, filtering, grouping, and aggregates…”.

My question is how to leverage on RO SDK to provide CRUD functionality for such HTML5/Ajax/JS Frameworks. Downside, performance, etc…?

I am asking because we are stuck (at least for the next few years) with some old/traditional backend RDBMS database like Oracle that we need to web-enable (No trendy Mongo or Couch DBs !!). Business logic is already existing in Delphi and in Stored Procedures within the DB…

Thanks & cheers,
Peter

2

Peter,

in your scenario, i would suggest looking at Data Abstract for JavaScript, as that should do exactly what you need — access a traditional relational database (via a middle tier server, of course, as all data access should happen) from JS.

3

Hi Peter,

I am using RO SDK/DA (FPC Linux server) with ExtJS framework … Some considerations with IE that I reported recently (http://connect.remobjects.com/discussion/897/ro-sdk-javascript-ie9-error) but in general it is working properly (I tested basic stuff first).

Initially trying to keep things simple and go slowly improving !

Willian.

4

Thanks for the feedback.

What actually confused me was the fact that most users of these HTML5/Ajax/JS frameworks would have a REST backend logic implemented and that these frameworks would help “easily” map these backend CRUD functionalities to the framework’s widgets…

I am currently doing some testings with jQuery and the RemObjectsSDK.js resp. JSON-RPC… Looking good…

P.S: I also found the qooxdoo framework to be quiet interesting with its JSON-RPC doc… http://manual.qooxdoo.org/1.6.x/pages/communication/rpc.html

Thx & cheers,
P.

5

P,

that’s exactly what DA does. DA is data publishing, like REST/OData just better and much more flexible and powerful — and with a ready-made JS client for it already. check out http://www.remobjects.com:8099/js/pctrade.html (the styling of that page is not quite ready for consumption, once you request a table, we’re still working on the sample. but you’ll get the idea; an older version f this sample also ships with DA, add this new one will be in the upcoming release).

Of course, DA also lets you publish data using REST and OData, but then you’re left to your own devices, client side, to consume that; the beauty of DA is that it handles bot the client and the server side for you (and that it’s “native” data publishing protocol can do much more. for example, you cant run a DA SQL query via OData, and data updating via OData is also much more limited).

hth,
marc

6

Hi,

In my case I’m using DA to export tables to the JS client UI and consume in the same way I do with another desktop client in Delphi. This way, I can reuse the same logic on the server that is ready …

Something that would be useful is a seamless integration between the datatable and store ExtJS (ExtJS data model). For now I’m manually feeding the store to the table through loops in the same way that Marc did with the example of jQueryUI PCTrade.

In the future I am thinking of implementing this integration, it is something specific between the DA and the framework I am using … Or maybe RO team can do it for me … :slight_smile:

thanks,
Willian.

7
willian_cslog said: In my case I'm using DA to export tables to the JS client UI and consume in the same way I do with another desktop client in Delphi. This way, I can reuse the same logic on the server that is ready ...
exactly! ;)
willian_cslog said: Something that would be useful is a seamless integration between the datatable and store ExtJS (ExtJS data model). For now I'm manually feeding the store to the table through loops in the same way that Marc did with the example of jQueryUI PCTrade.
good idea, yes. iirc Valeriy (he gets credit for the sample, not me ;) did create a reusable mapper for the jQuery grid; i agree something like that for ExtJS and possibly other popular JS grid or UI controls would be nice.
8

I know very few about ExtJS data model, but pretty sure it differs from RO JSONDataStreamer one. If there existed some json transformation engine like XSLT it could be close to ‘seamless’ :wink: