AngularJS integration with a large existing relational database?

6,221 views
Skip to first unread message

James Daily

unread,
Feb 27, 2013, 4:40:40 PM2/27/13
to ang...@googlegroups.com
Does anyone have any experiences to share regarding AngularJS on top of a large existing relational database? (eg. oracle, mysql, etc.)

I'm used to very detailed control over my data model, and I'm curious to know how well AngularJS plays with others...

-James

Daniel Nelson

unread,
Feb 27, 2013, 4:44:31 PM2/27/13
to ang...@googlegroups.com
Check out http://docs.angularjs.org/api/ngResource.$resource. If you
have restful resources defined on the back end, then AngularJS
$resource plays quite elegantly with them.

- Daniel

Joshua Miller

unread,
Feb 27, 2013, 4:51:32 PM2/27/13
to angular
Hello!

AngularJS doesn't define *any* data model for you to use, so it is entirely up to you! As Daniel hinted, you define your server API however makes sense for your purposes with your database and then you design your AngularJS app to connect onto that in a way that makes sense in your use case. In short, I don't think AngularJS cares what database you use on the backend.

Do you have a specific concern or an experience with another library that caused issues?

Josh


--
You received this message because you are subscribed to the Google Groups "AngularJS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to angular+u...@googlegroups.com.
To post to this group, send email to ang...@googlegroups.com.
Visit this group at http://groups.google.com/group/angular?hl=en-US.
For more options, visit https://groups.google.com/groups/opt_out.



James Daily

unread,
Feb 27, 2013, 5:07:58 PM2/27/13
to ang...@googlegroups.com
No; my current experience is:
 - form-heavy html (css/basic js) front end
 - which submits forms to a somewhat black box proprietary app server - which I'm quite unfamiliar with
 - which ultimately calls pl/sql (oracle) stored procedures to perform CRUD and other operations
 - the results of which come back through the black box into php-like templates to generate new pages

I have a clear understanding of all the workings described except that black box app server, which is perhaps why I'm asking the wrong(?) questions about Angular...

From what I described above, where would AngularJS sit? What could/should it replace? What can/should it not replace?

Thanks!

-James

Daniel Nelson

unread,
Feb 27, 2013, 5:26:23 PM2/27/13
to ang...@googlegroups.com
> - form-heavy html (css/basic js) front end

AngularJS here, making asynchronous JSON requests to the back end (it
could make XML requests instead, though I don't know how easily
configurable Angular is for that use case).

> - the results of which come back through the black box into php-like
> templates to generate new pages

No data templates. The server would return JSON (or XML see above)
representations of the data models.

-Daniel

Brad McAlister

unread,
Feb 27, 2013, 6:08:06 PM2/27/13
to ang...@googlegroups.com
I get all my data through JSON requests. Everything's coming from a C#.NET/MsSQL back-end. As long as you're getting JSON back you'll be OK. However, since you mentioned the work "form" if you're trying to put AngularJS inside existing WebForms apps be prepared for anger and irritation. That combination like to break things like using buttons and forms of any kind. I've had to resort to making a tags look like buttons and strip out any form tags other than the one the entire page is wrapped in. So if you can start fresh and just make the JSON requests that'll make your life much easier.

E_lexy

unread,
Feb 28, 2013, 5:11:12 AM2/28/13
to ang...@googlegroups.com
Hi James,

Maybe Breeze JS is something that could help structure the interaction with the backen d for you a bit.
I have no experience with your backend type, but BreezeJS seems to add some nice help to the mix.

Alex
Reply all
Reply to author
Forward
0 new messages