[leahs]

Super content Luke!

Thanks for sharing in so much detail

[leahs]

Such a great post – so interesting!

Thanks for sharing @SJT 

[leahs]

Hello @yuwu10112358

Thanks for sharing with the KX Community.

Reverting with some feedback for you:

There are a few options here:

1. Server side caching solution is recommended.

2. Use a virtual query. If several components are using the same datasource, then there can be one q query and link each of the components to a virtual datasource

3. In the query, return the table as a dictionary and use the query mapper to map the table to a viewstate

Hope this helps.

Thanks, 

Leah

 

[leahs]

Super content here @simon_watson_sj

Thanks for sharing with our fellow community members!

Happy Coding ,

Leah

[leahs]

Hello @renbright,

Thank you for your question!

I’m not familiar with an out-of-package kdb+ WORM function as described above – perhaps someone can contradict this?

At a permissions level, read/write permissions can be set at a file level on disk. Permissions can also be either granted or restricted on selected entities within user groups at the KX Control level.

I welcome engagement from fellow kdb+ Engineers and community contributors to specifically discuss the WORM function in question.

Kind regards, 

Leah

 

[leahs]

Hello Anna,

Firstly, I’m delighted to welcome you to the KX Community.

It’s great to hear of your start-up and your interest in a kdb+ solution. When new to the world of kdb+, useful resources as a starting point can be found here: Code KX – An introduction to kdb+ and Code KX – Architecture of a kdb+ system

I welcome engagement from fellow kdb+ Engineers and feedback from our community contributors to discuss the specific comparative questions posed above.

Kind regards, 

Leah

[leahs]

Hello all,

Thanks very much for presenting your findings.

After discussing, we are reverting with some feedback:

The latter solution presented by @nfrishling appears to be the most suitable approach and should work given the evidence provided – until this functionality is officially released by the KX core platform team. Based on the changes made, this solution in question seems solid.

One caveat to highlight is that that function may be updated by our core platform team in a future release and therefore, our advice would be to do a comparison on every occasion that you attempt an upgrade of your KX platform, until of course this functionality is added by the KX core team. This comparative check is encouraged in order to ensure that you don’t overwrite any critical additions to the function, whilst maintaining your custom code.

Thanks to @gdickson for analysing this thread and providing such feedback.

We hope this information helps.

Kind regards,

Leah

[leahs]

Hello @naraink,

Reverting with feedback provided by our core team:

This is currently not possible. However, it will be presented internally for consideration in a future release.

Thanks very much for sharing with us!

Kind regards, 

Leah 

[leahs]

Hello @cyhuang,

Reverting with feedback provided by one of our engineers:

-To run Developer, you need q on your local machine.

-The only alternative if you wanted to run it from AWS would be to install Developer on the remote instance and open a firewall rule to the HTTP port for Developer. Then, you could go to your browser at the IP of the instance at the given port and access it.

Hope this helps!

Thanks,

Leah

[leahs]

Hello @cj

Thanks for reaching out to the community with your question.

Sharing feedback provided by one of our engineers below –

You could try the following:

• make sure each item to be reopened has a reopen transition in the action tracker definition  https://code.kx.com/platform/stream/actiontracker/#reopen
• I think links will be persisted even for closed items so you can use dxATGetLinks in your reopen custom transition analytic to get all the linked items https://code.kx.com/platform/stream/actiontracker/#apis
• In your reopen custom transition analytic use dxATTransitionItem to transition each linked item from it’s closed queue to an open queue via the reopen transition you have defined
• To see the parameters for dxATTranstionItem transition an item from the UI and look at .pm.querylog on the action tracker process.

We hope this helps!

Happy Coding, 

Leah

[leahs]

Hello,

Thank you for sharing with the community – All questions welcome, no need to worry about that.

Interested to hear feedback from fellow contributors.

Kind regards,

Leah

[leahs]

Thank you for updating the above with the resolution to your problem @NickSansone

Highlighting your fix here for fellow community contributors:

 I ended up resolving this problem, it was a very easy fix.  Rather than loading each table individually into the remote process (what I did), the database simply needs to be reloaded through the connection handle using “l .”  Ensure that you are loading into the correct file path (I had to change directory down to the “f1” folder).  Hope this helps anyone else who ran into the same issue.

Great collateral for others

Happy Coding,

Leah

[leahs]

Hello @chan_chenyanj,

As we discussed previously regarding ‘1’, including ‘each’ here will return a rank error given that ‘iasc’ accepts a list as its argument and `3Y`5Y is a simple symbol list.

To elaborate on ‘2’, I believe you want to query an updated table created after running ‘1’, i.e., assign ‘1’ (without each)

‘2’ logic is erroneous. `@ needs to be replaced with ‘@. To explain the logic, it is determining whether or not the new columns have a null symbol, and if it does, then delete from the table.

 

Happy Coding,

Leah

[leahs]

Hello,

The KX IPC documentation found here

highlights the role that the .z namespace plays in IPC and specifically here presents .z.W

.z.W returns a dictionary where you can see how many messages and their size that are queued on a handle.

Hope this helps,

Leah

[leahs]

Great questions here! Thank you for sharing with the KX Community.

In order to provide appropriate answers, is it correct to say that you are working with Dashboards Direct here?

Kind regards,

Leah