CODEWITHSUNDEEP
mysqlangularjswebsocket
celsomtrindade
celsomtrindade

Reputation: 4671

AngularJs real time app with mysql server

Is it possible to build a realtime app using AngularJs with a mysql database?

I've been reading thousands of tutorials, but they are all focused on express, nodejs, etc.. didn't found any documentation on wheter it's possible or not. I tried to take a look at the socket.io docs, but still didn't found anything relevant to this question.

I didn't tried anything yet because of this. I use a webApp based on AngularJs on a apache server (local).

I need to do this real time because it involves product orders, call center, ticket system, etc.. So everytime there is a new ticket is opened/changed, new order arrives, etc.. I need to make the user aware of this, without the need to refresh the page.

Or if someone could give me a further explanation of this concept and how to get started, it will be great.

Upvotes: 3

Views: 8997

Answers (3)

iwein
iwein

Reputation: 26161

You can run angular on top of any backend, although most examples push towards REST. If you want your app to feel like a real time application, using WebSockets is a likely improvement.

WebSockets play nice with Angular, look at https://github.com/wilk/ng-websocket for example. A back-end in Node will work, but many other backend techs will do equally well.

Here is a decent tutorial using MySQL, NodeJS, and Angular: https://codeforgeek.com/2015/03/real-time-app-socket-io/

I recommend that you keep using a webserver like Apache (my personal preference is Nginx). You can proxy API and socket requests to Node, and serve static resources for the app from a folder.

Check out https://httpd.apache.org/docs/2.4/mod/mod_proxy_wstunnel.html if you stay with Apache. Check out http://nginx.org/en/docs/http/websocket.html is you go for nginx.

Without a webserver, you'll have to either:

  • serve your static resources with Node (polluting your server project with client code), or
  • work with different ports, risking the app becomes unusable in client environments, or
  • work with different domains, giving you a CORS head-ache.

Upvotes: 1

Sajib Acharya
Sajib Acharya

Reputation: 1733

Yes, it is possible to create a software with AngularJS in the front end and any other server side language that speaks to MySQL. Few months back I worked on a software with Java Spring Framework in the backend with MySQL database and AngularJS with bootstrap in the front end. You could start by following the MVC pattern, where your views can be served as AngularJS and your Controller can be in any server side code, with MySQL database.

Upvotes: 0

Ron Brogan
Ron Brogan

Reputation: 901

Although I don't have much experience with Node, MySQL with Node.js should help you out a bit.

You'll want to move away from Apache if you want to do websocket stuff with Socket.io

Upvotes: 0

Related Questions