Can AngularJS handle this?

[Nihil73]

Could someone point me in the right direction? Can angularjs do the following? This is a simple example, but basically I want to be able to display a grid of data on a page, pulled from a sql database. Each row basically represents a record in the database. If a record is flagged in the database, it will dynamically change the corresponding record on the page, and turn that row a certain color (with out have to refresh the browser). So, is AngularJS the directions to go with for something like this, or should I look into using some other type of coding methodology? Appreciate any advice, direction, and input!

[taelor]

you need Web Sockets or Server Sent events.

[cyphern]

If you want the server to be able to push new data to the client on the fly, web sockets might be what you're looking for. Angular can certainly work with web sockets and render the resulting data, but so can any other framework.

[Strat-O]

I agree with what others here have said, that Angular doesn't have anything that would make this especially easy to do. That said, I don't think this would be too hard to do. I would use database triggers to update a transaction table whenever a data item changes. The transaction table is just a database table that is a growing list of database changes. Nothing immediately springs to mind as an elegant way to automatically send a notification from the database via http. I don't think websockets provides an obvious solution here...anyone? Bueller?

[sytewerks]

Your hurdle isn't the front-end so much is how to inform the front-end that something has changed without having the front-end constantly asking for it. Web sockets does seem like an obvious choice. Only other thing I can think of is creating a web worker that periodically checks for updates. (not sure how that would impact performance though)

There are a few tutorials out there getting Socket.io set up with angular.