Storing JSON ticks to SQL

samrvir

hey people,

I am trying to store the tick data, from websocket api in Mysql database in python.

I think, I have to do it in on_tick method, but I am confused as to how should I convert ticks to SQL Inserts.
Any help is hugely appreciated! thanks!


- Samar vir Singh

sujith

Hi @samrvir,
You need to do it inside on_tick callback.
I would suggest doing your IO operations and calculations in another thread. Never do it on the thread where you are receiving ticks.
I think people are using pandas. I hope this thread will be helpful.