I'm trying with Algo-trading. so I have WebSocket which has market data, I'm trying to store in the database. other modules read this stored database and make the buy/sell decisions.
- what should be the best database option here considering it should be faster to insert the data and required concurrent reading.
- how do I handle the WebSocket data, it contains a lot of data to store, without losing the data.
?