I agree with Jens and Ed.? I get the IB data and store it to csv
using python. Then another script reads the csv into a Pandas
dataframe and that where the fun starts.
On 10/27/20 3:07 PM, Edward wrote:
toggle quoted message
Show quoted text
I concur with Jens. For a majority of purposes
text files are sufficient. Unless you are going to perform very
heavy queries I would go with that. If you are still thinking to
use a database consider one of object databases depending on
your development practices?
Ed
Dear Hedgemoney,
we are using MariaDB for large?dataset. However,
storing the data into SQL and retrieving it back is more
complicated?than using csv-files or Google Drive.
I prefer storing the data in csv-files. Python offers
so many tools and very efficient methods to calculate
all kind of models or output. And you may visualize the
output with Dash (plotly).?
Best regards
Jens
hi
I didn't see any post that asked this directly so, I'll
ask it.
I'm trying to get time/sales of options data end of
day(EOD)?
will use tws api and python.
I think i should organize the data in a db rather than
file, excel....
I may build a front end webpage to view the data?
so which one:
leaning SQLite
i hear mySQL is popular as is PostGreSql
My thought is to use SQLite and migrate to the other if
I'll need it....
Any comments and opinions would be appreciated....
Thanks
--
Ed Gonen
