So I am planning to start develop a site similar to moneycontrol, which basically pull data from stock exchange and show them in realtime. I am thinking about using RethinkDB as it is what came to close to relationalDB while pushing data to front-end instead of us polling for data.
Since I never used it, I have no idea how good it is. The application may not have much user(expecting hardly 100-500 users at max). What do you guys suggest? Will I go with RethinkDB+Java or go traditional and use websockets to poll for data. If I've made any wrong assumptions, please let me know.
Bill O'Neil
Websockets are bidirectional you can push data over them also. What you could do is as you pull the stock market data broadcast changes over the websockets before or after you write to the db (any db). Websockets can be a little difficult to scale but if you are talking 500 users it should be fine.