Hi Guys, So many people ask the same question time and again that I felt odd at first to start the discussion on it, but thought it will help others as well who will be in the same dilemma as me with so many options available So here are the options first- SQL (Relational Database) - SQL Server - PostGresSql - MySql
NoSql - Redis - MongoDb - Cassandra
FlatFiles - CSV - TeaFiles
TimeSeries Database - KDB+ - InfluxDb
This is what i m looking for- 1. Storing live streaming data to a database 2. Running a script that converts Tick data to OHLC and save the OHLC in same Database 3. Running one more script or coding in same script above to create one more type of Chart Pattern (Renko) and saving it in same database 4. Running one last script that will fetch data from same Database and trade using Zerodha trading API
Note- I will be using Python programming . So whichever database you suggest should have a python library Most Important- Database should be free and opensource
Latency- Doesnot matter much as it will be a Medium Frequency model ( 5 min- 1 hour) Scalability- Database should be able to handle tickdata for atleast 200 Equity Scrip or more
All suggestion on topic with reasonable explanations are Welcome. Any one who already is in the role and/or associated with any prop trading firm and wants to suggest something off topic is also Welcome.