kdb+ and q
Q+A on all things kdb+ database and the q language
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Pub/sub in Kdb+

With Kdb+(not kdb+tick) is it possible to Pub/Sub?Here is my what I am struggling to understand. If I do a normal upsert .Can I simple subscribe to it and receive the upserted data?Any piece of reference code?

soum_guli by New Contributor
  • 910 Views
  • 2 replies
  • 0 kudos

query for a list in a table

Hello all,I'm learning Q and KDB, started few days ago.I checked several sources, but I am not able to search for a list in a table.I have this table: ctable:([]v:((0.0 0.0);(1.0 0.0);(0.0 1.0)))then if I try something like this select from ctable wh...

can views/aliases be seen as materialized and hence be used to

Extreme qubie question incoming: I'm reading about aliases and table views (which are aliases). Considering I have a lot of queries that always follow the same pattern in the sense that they always have a group over a subset of properties A,B,C. Thes...

gbrits by New Contributor
  • 577 Views
  • 1 replies
  • 0 kudos

what's the use of 'resolving a foreign key'? (from enum to

Hi guys, working my way through through Q for Mortals, and have a question on http://code.kx.com/q4m3/8_Tables/#851-definition-of-foreign-key. Followed along and setup a foreign key from `tdetails` pointing to `kt`then following the tutorial: When yo...

gbrits by New Contributor
  • 683 Views
  • 1 replies
  • 0 kudos

does kdb+ support aggregation on non-time fields?

Hi guys,Looking to find some info if KDB+ supports aggregation/roll-up/group-by on non-time fields? My use case: historic price data, which needs to be compared. Most queries should happen on the last known price-point of a particular 'product' and t...

gbrits by New Contributor
  • 2237 Views
  • 7 replies
  • 0 kudos