Python and kdb integration [closed]

Question

What are available tools/libraries to integrate Python with kdb?

Answer 1

The timestored website has a guide to the python apis for kdb complete with videos. http://timestored.com/kdbGuides/pythonApi

To summarize your options:

1. Dan Nugents Python Library - Still maintained API for pulling data into Python <=v2.6 from a kdb server. Faster than qpy.
2. qpy - Original API that was based on kx.com's java API. Slower than Dans but nicer formatting of tables when printed.
3. PyQ - Brings Python and Q interpreters into the same process and allows code written in either of the languages to operate on the same data. Supports Python 2.7 and 3.x and all versions of kdb+.
4. qPython - Newest API, supporting Python 2.7

Answer 2

I also found http://www.kx.com/a/k/connect/python/, along with http://bitbucket.org/halotis/qpy. I haven't used either.

Answer 3

there's also Dan Nugent's https://github.com/DannoHung/q

also note that, as with perl, sometimes the formatted export over the web socket is sufficient -- just GET http://SERVER.example:PORT/FMT?QUERY, where FMT is any of csv/txt/xml/xls (e.g. http://localhost:5050/csv?table)