Other type communication, data sent/get - [tcp/ip]

Community Support
1

I have some incubation in my head and questions..

I reading about
http://code.kx.com/wiki/Reference/ipcprotocol
..and see some changes in new version of kdb 3.x

  1. I have some simple case where I need one advanced select and I can do this by http for get one variables to my dedicated aplication what using dedicated language

    x y

    a 1
    b 2
    c 3
    d 4
    e 6

http://127.0.0.1:5000/? select y from t [0]

<pre>y| 1
</pre>

- ok, I can decode "y| 1 " coz I need only this int as 1
If I guessing I can manipulate this result in q.k to disable "y| " ? Or not?
What if I selected cols and we have titles for them with "href" (----) - Can I disable this?
It's sense to do this? Or looks lamer work. In fact is very easy and cheap for my app : )
Of course matrix in kdb+ is big but result is small var.

  1. Can we connect to kdb+ by Putty, Win hyperTerminal ?

  2. Nr 2# is corelated with tcp what I using in my app and have implementation from http://zeromq.org - planed to connect in this case.

  • I missed here some limitations?
2

there is a C interface, a Java and JDBC interface, a python interface(search on code.kx.com)> http://127.0.0.1:5000/? select y from t [0]>>

y| 1>

you can get csv or xml results from the kdb+ servereg. if you have a table, t with a column x, you can runjack@tp ~$ wget ‘http://localhost:5001/xml?select y from t’ -q -O -012jack@tp ~$ wget ‘http://localhost:5001/xml?select x,y from t’ -q -O -001122> 2. Can we connect to kdb+ by Putty, Win hyperTerminal ?if the host has q or a q client built on Java, Python, C, etc, thisclient can connect to a kdb+ server.eg, through putty, you can type the wget commands above. if you have built your own kdb+ client, you can run that over ssh, too.ta, jackOn 16 November 2013 08:10, reptile <my.reptile> wrote:> I have some incubation in my head and questions..>> I reading about> http://code.kx.com/wiki/Reference/ipcprotocol&gt; ..and see some changes in new version of kdb 3.x>> 1. I have some simple case where I need one advanced select and I can do> this by http for get one variables to my dedicated aplication what using> dedicated language>> x y> —> a 1> b 2> c 3> d 4> e 6>>> http://127.0.0.1:5000/? select y from t [0]>> 

y| 1>
>> - ok, I can decode "y| 1 " coz I need only this int as 1> If I guessing I can manipulate this result in q.k to disable "y| " ? Or not?> What if I selected cols and we have titles for them with “href” (----) - Can> I disable this?> It’s sense to do this? Or looks lamer work. In fact is very easy and cheap> for my app : )> Of course matrix in kdb+ is big but result is small var.>>> 2. Can we connect to kdb+ by Putty, Win hyperTerminal ?>> 3. Nr 2# is corelated with tcp what I using in my app and have> implementation from http://zeromq.org - planed to connect in this case.> - I missed here some limitations?>> –>

Submitted via Google Groups</my.reptile>

3

ok testing 1# looks ok on this moment. Using wininet.dll
query with insert etc. is ok
want check result / error as response:

* standard query http://127.0.0.1:5000/?`table insert //insert ok
standard result is ::

<html><head><style>a{text-decoration:none}a:link{color:024C7E}a:visited{color:024C7E}a:active{color:958600}body{font:10pt verdana;text-align:justify}</style></head><body><pre>::
</pre></body></html>

 - but want miss html to get pure string if is posible

* my query http://127.0.0.1:5000/txt?`table insert //insert ok
my result is 'rank and no html.
This is probalby bad way?

4

you can try csv:$ wget ‘http://localhost:5001/csv?select x from t’ -q -O -x012$ wget ‘http://localhost:5001/csv?select x,y from t’ -q -O -x,y0,01,12,2ta, jack.On 17 November 2013 01:16, reptile <my.reptile> wrote:> ok testing 1# looks ok on this moment. Using wininet.dll> query with insert etc. is ok> want check result / error as response:>> * standard query http://127.0.0.1:5000/?`table insert //insert ok> standard result is ::>> a{text-decoration:none}a:link{color:024C7E}a:visited{color:024C7E}a:active{color:958600}body{font:10pt> verdana;text-align:justify}

::>
>>> - but want miss html to get pure string if is posible>> * my query http://127.0.0.1:5000/txt?`table insert //insert ok> my result is 'rank and no html.> This is probalby bad way?>> -->

Submitted via Google Groups</my.reptile>