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

**URL:** https://forum.kx.com/t/other-type-communication-data-sent-get-tcp-ip/8484
**Category:** Community Support
**Tags:** kdb-and-q
**Created:** [November 15, 2013, 9:10pm UTC](https://forum.kx.com/t/other-type-communication-data-sent-get-tcp-ip/8484 "2013-11-15T21:10:00Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![reptile1](https://avatars.discourse-cdn.com/v4/letter/r/ba9def/32.png) [@reptile1](https://forum.kx.com/u/reptile1)
#### Post date: [November 15, 2013, 9:10pm UTC](https://forum.kx.com/t/other-type-communication-data-sent-get-tcp-ip/8484/1 "2013-11-15T21:10:00Z")

</div>

I have some incubation in my head and questions..

I reading about  
[http://code.kx.com/wiki/Reference/ipcprotocol](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

[http://127.0.0.1:5000/](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](http://zeromq.org) - planed to connect in this case.

- I missed here some limitations?

---

<div class="post-metadata">

### Author: ![effbiae](https://avatars.discourse-cdn.com/v4/letter/e/ecae2f/32.png) [@effbiae](https://forum.kx.com/u/effbiae)
#### Post date: [November 16, 2013, 6:40am UTC](https://forum.kx.com/t/other-type-communication-data-sent-get-tcp-ip/8484/2 "2013-11-16T06:40:00Z")

</div>

there is a C interface, a Java and JDBC interface, a python interface(search on [code.kx.com](http://code.kx.com))\> [http://127.0.0.1:5000/](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](http://localhost:5001/xml?select) y from t’ -q -O -012jack@tp ~$ wget ‘[http://localhost:5001/xml?select](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](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/](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](http://zeromq.org) - planed to connect in this case.\> - I missed here some limitations?\>\> –\>

Submitted via Google Groups\</my.reptile\>

---

<div class="post-metadata">

### Author: ![reptile1](https://avatars.discourse-cdn.com/v4/letter/r/ba9def/32.png) [@reptile1](https://forum.kx.com/u/reptile1)
#### Post date: [November 16, 2013, 2:16pm UTC](https://forum.kx.com/t/other-type-communication-data-sent-get-tcp-ip/8484/3 "2013-11-16T14:16:00Z")

</div>

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](http://127.0.0.1:5000/?%60table) 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>

```

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

\* my query [http://127.0.0.1:5000/txt?`table](http://127.0.0.1:5000/txt?%60table) insert //insert ok  
my result is 'rank and no html.  
This is probalby bad way?

---

<div class="post-metadata">

### Author: ![effbiae](https://avatars.discourse-cdn.com/v4/letter/e/ecae2f/32.png) [@effbiae](https://forum.kx.com/u/effbiae)
#### Post date: [November 16, 2013, 11:39pm UTC](https://forum.kx.com/t/other-type-communication-data-sent-get-tcp-ip/8484/4 "2013-11-16T23:39:00Z")

</div>

you can try csv:$ wget ‘[http://localhost:5001/csv?select](http://localhost:5001/csv?select) x from t’ -q -O -x012$ wget ‘[http://localhost:5001/csv?select](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](http://127.0.0.1:5000/?%60table) 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\>
