At the moment we are using a SA16 database with around 450 tables and lots of stored procedures. For mobile devolpment we developed webservices that returns JSON to the devices. Now we like to a step further and develop a single page application (SPA) on the web.

Therefor we looked to several Javascript frameworks, like AngularJS en EmberJS. These frameworks work with MVC (very nice) and use models that extract there data from webservices. SQL Anywhere seems to be able to work in that way (per table a model, with webservices for CRUD operations).

Questions:

  • has anbodoy experince with these frameworks? AngularJS or EmberJS.
  • how doe you sync changes in the db to the model that are done in a SP that inserts/update a lot of tables?
  • do you advice other frameworks or libraries?

Tia Hans

asked 11 Jan '16, 02:38

HansTSD's gravatar image

HansTSD
220131521
accept rate: 20%

I have a simple question: do you want to use dynamic pages with the server-side code (Java/ASP.NET/PHP/Node.JS), or you prefer JavaScript pages and host everything on SA (using it as a server)?

(11 Jan '16, 05:24) Vlad
Replies hidden

We prefer hosting everthing in SA.

(11 Jan '16, 05:26) HansTSD

I've done a couple of projects using AnguarJS, using PHP middleware on the server and SA as the backend database.

  1. AngularJS is a great tool - am able to build very responsive applications
  2. my applications have 'manual' synching wherein the user hits a 'sync' button to update
  3. I have experimented with using HiveMQ (www.hivemq.com) to notify the clients when they should initiate a sync operation. I haven't used it in a production situation yet, but I think it would work fine. If you don't want the middleware component, you could one of SA's 'External Environments' to write the notification code.
permanent link

answered 12 Jan '16, 13:08

Terry%20Wilkinson's gravatar image

Terry Wilkinson
746303548
accept rate: 25%

edited 12 Jan '16, 13:10

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×62
×2

question asked: 11 Jan '16, 02:38

question was seen: 1,669 times

last updated: 12 Jan '16, 13:10