R help - Sep 2009 - Does anybody know how to connect to KDB from within R?

Please give me some pointers... Thanks a lot!

Michael wrote:
> Does anybody know how to connect to KDB from within R?
> Please give me some pointers... Thanks a lot!
>   
Michael,

KX distributes R glue code with kdb. 

http://kx.com/q/interfaces/r/

Talk to them if you need support on using it, your firm presumably paid 
enough for the license...

Also, you may wish to read Dirk's post and related posts on the list 
archives here regarding POSIXct compatibility:

http://dirk.eddelbuettel.com/blog/2009/02/03/#kdbplus_datetime_patch


Regards,

    - Brian

Cool!

I've seen the following files in that folder:

Index of /q/interfaces/r/w32

	Name	Last modified	Size	Description
	Parent Directory	 	 -
	R.dll	12-Feb-2009 18:58	2.7M
	c.o	12-Feb-2009 18:58	 23K
	k.h	12-Feb-2009 18:58	3.3K
	kdbplus.R	19-Feb-2009 03:21	420
	kdbplus.dll	12-Feb-2009 18:58	 66K
	kdbplus.o	11-Feb-2009 08:30	 14K


How do I install these files to my R-system?

Thanks!



On Thu, Sep 24, 2009 at 2:54 PM, Daniel Cegielka
<daniel.cegielka at gmail.com> wrote:
> Brian G. Peterson pisze:
>> Also, you may wish to read Dirk's post and related posts on the
list
>> archives here regarding POSIXct compatibility:
>>
>> http://dirk.eddelbuettel.com/blog/2009/02/03/#kdbplus_datetime_patch
>
>
http://groups.google.com/group/personal-kdbplus/browse_thread/thread/f3271f5cf534c67f
>
> This patch is build in kdbplus.c (line: 470-489):
>
> https://code.kx.com/trac/browser/kx/kdb%2B/interfaces/r/kdbplus.c
>
>
>> Re: [R-SIG-Finance] Does anybody know how to connect to KDB from
> within ? ?R?
>
> yes:
>
> run: ~/q/l32/q -p 5000
>
> R session:
>
> # dyn.load(file.path("/home/kdeplus/.../q","l64"))
> # con <-
>
.Call("kx_r_open_connection",list(host="localhost",as.integer(port=5000),user=NULL))
> # execute <- function(con,query) {
> ?.Call("kx_r_execute",as.integer(con),query)
> ?}
> # execute(con,"s:([] name:`A`B`C; var:10 20 30)")
> # execute(con, "select from s")
>
>
> best,
> daniel cegielka
>