skip to Main Content

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.

  1. what should be the best database option here considering it should be faster to insert the data and required concurrent reading.
  2. how do I handle the WebSocket data, it contains a lot of data to store, without losing the data.

?

2

Answers


  1. To answer question 1:

    Several people use Redis Timeseries to store market data for analysis/display. Insert and retreival are fast.

    For question 2:

    You could run several consumers and use Redis for de-duplication so you don’t update everything twice, but it will heavily depend on your stack

    Login or Signup to reply.
  2. To answer question 1:

    You can use a memory based database such as redis.

    For question 2:
    you can use rabbitMQ or kafka.

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search