Time series DB?

Discussion in 'Programming' started by sle, Dec 24, 2017.

  1. traider


    Can python hook onto kdb+ and bypass the q language? Are there any good resources out there for tutorials on kdb?
    #61     Jan 18, 2018
  2. Sure, a standard q server supports HTTP requests via a tcp port, but you could use some other programmatic interfaces too. There are also a few libraries that provide interfaces with R, ODBC, etc.

    However, you would still need to know q quite well, and not just at a simple query level, to be able to create and maintain all the kdb data repositories.

    But, after all this, if you were just trying to query/load say a whole year of raw tick data of a frequently traded instrument like the SPY or QQQ or any other option symbol into say a java or a python client to do all the data processing at that end, it would be all a waste of effort if you asked me, providing of course you did not run out of memory first.

    #62     Jan 18, 2018
  3. temnik


    Why would you want to? Do you really think you can do in pandas what is done on the server - like shift millions of rows of bid/ask by delta_t and join on itself? To do serious work you want to take advantage of how data is partitioned on the server and avoid transferring any intermediate data structure to the client.

    Common example: is it faster to first select by date then by symbol or the other way around?
    #63     Jan 18, 2018
  4. traider


    Depends on structure of database, if I were to design a fin db, I will optimize both by building indexes etc
    #64     Jan 18, 2018
  5. sle


    So far I have downloaded the 32bit version of kdb+ and was going to start playing with it in my spare time. Nothing I do at the moment really requires it, so the whole migration is going to be a slow.
    #65     Jan 18, 2018
  6. https://github.com/alpacahq/marketstore
    MarketStore is a good open source timeseries database that work well with Python Pandas/numpy ecoysystem.

    #66     Mar 5, 2018