Re: [personal kdb+] qStudio an IDE for kdb

Community Support
1

Is it possible to sign that exe file by any chance? For some, company policies won’t allow running unsigned binaries downloaded from the web.

2

This is great. A related question. How do I narrow the result set from the server without getting everything.

e.g. from q command line, there is .Q.ind that restricts result set. In the browser view, it implements similar logic. How do I achieve this in kdbstudio?

3

Hi Sam,

As far as I know in kdb Studio you can’t restrict the result set.

FYI in qStudio you can customize it, using settings->preferences, where you can set a result size limit and a rows shown limit.

""

You can also browse the existing tables by “page” in qStudio by:

  1. Just clicking them in the server tree
  2. Looking at them in the result pane
  3. Use the arrows to move forward/back/end

""

Regards,
Ryan

On 1/28/2013 12:46 AM, Sam wrote:

This is great. A related question. How do I narrow the result set from the server without getting everything.
e.g. from q command line, there is .Q.ind that restricts result set. In the browser view, it implements similar logic. How do I achieve this in kdbstudio?

On Thursday, January 24, 2013 9:38:50 AM UTC-5, ry…@timestored.com wrote:

Hi,

Just released for download: qStudio an IDE for kdb:http://www.timestored.com/qStudio/It has:

  • Charting Straight from Kdb queries (bar / line / candlestick…)
  • Autocomplete of functions/variables
  • Graphical server browsing
  • q syntax highlighting

I hope you find it useful and we are always happy to receive feedback or feature requests so that we can continue to improve it.

  • Ryan Hamilton

–
You received this message because you are subscribed to the Google Groups “Kdb+ Personal Developers” group.
To post to this group, send email to personal-kdbplus@googlegroups.com.
To unsubscribe from this group, send email to personal-kdbplus+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/personal-kdbplus?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--

TimeStored.com - KDB+ Software, Training, Consulting

4

Thx

5

Thanks Ash.

Excel export is supported in the latest version 1.25.
Right click on “Result table”->export table. Allows saving the file.
or “copy table”-> you can paste straight into excel.

I might add a toolbar shortcut in the next release.

""

Feel free to contact me directly with any feature requests or suggestions. Currently working on integrating qStudio GUI with q profiler and unit testing.

  • Ryan

On 3/6/2013 6:59 PM, Ash wrote:

this simply great specially after using StudioForKdb for years.  any plan to support export to excel feature like StudioForKdb.  Thanks again for such a great work - Ash

On Thursday, January 24, 2013 9:38:50 AM UTC-5, Ryan Hamilton wrote:

Hi,

Just released for download: qStudio an IDE for kdb:http://www.timestored.com/qStudio/It has:

  • Charting Straight from Kdb queries (bar / line / candlestick…)
  • Autocomplete of functions/variables
  • Graphical server browsing
  • q syntax highlighting

I hope you find it useful and we are always happy to receive feedback or feature requests so that we can continue to improve it.

  • Ryan Hamilton

–
You received this message because you are subscribed to the Google Groups “Kdb+ Personal Developers” group.
To unsubscribe from this group and stop receiving emails from it, send an email to personal-kdbplus+unsubscribe@googlegroups.com.
To post to this group, send email to personal-kdbplus@googlegroups.com.
Visit this group at http://groups.google.com/group/personal-kdbplus?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--

TimeStored.com - KDB+ Training, Consulting, Software

6

charset=us-ascii
Message-Id:
Cc: “personal-kdbplus@googlegroups.com”
X-Mailer: iPad Mail (10B141)
From: Bharani <bharani.movva>
Subject: Updating partitioned database
Date: Fri, 29 Mar 2013 22:09:19 -0400
To: “personal-kdbplus@googlegroups.com”

Hi,
Can some please let me know how to update a column value in a petitioned dat=
abase?

Thanks,
Bharani=

</bharani.movva>

7

Hi Bharani,

I’d suggest that you read this section of Kdb+ for Mortals;
http://code.kx.com/wiki/JB:KdbplusForMortals/partitioned_tables#1.3.5.2_Modifying_Data_in_a_Partition

Regards,

Paul

8

Hi Old?ich,

Thanks for the request, we listen to user feedback and recently  added the most commonly requested  features  (file browser, easier server importing, unit testing) and fixed many bugs.
http://www.timestored.com/b/qstudio-for-kdb-1-26-released/  

This timespan issue was in fact raised a few weeks ago but unfortunately ranked low on our to-do list as we estimated it would take 2-3 weeks to implement a non-perfect fix. Our discussions around this included:

  • not many people are using timespan
  • the labels are going to be extremely long to show nanosecond, so long they may be useless.
  • In cases where people actually care about nanoseconds how do we show events that happened at the exact same nanosecond.
  • We thought anyone actually looking at the events at the nanosecond scale would not actually care that it was 4 hours 3 minutes … 10 nanoseconds, just about relative movements within the graph, therefore treating as an integer would suffice.

I’ll send you another mail directly so we can see what type of graph you would expect, however I have replied to the entire google group as if anyone else is using timespan and would like this feature, please could you send an email to let me know and we will increase it’s priority:  ryan@timestored.com

Any other feedback or suggestions are welcome and we do use them to decide which areas to develop further. Currently next on our road map is  permitting bars/lines on the same chart, allowing chart customization and improving the unit-testing / profiling functionality.

Regards,
Ryan

On 3/30/2013 1:39 AM, Old?ich Šmejkal wrote:

Hi,

it will be good to show properly values fo timespan data type. In current version it is displayed as integer number, and it is really uncomfortable when every your time is actually timespan..

Thanks

Oldrich Smejkal

Dne ?tvrtek, 24. ledna 2013 15:38:50 UTC+1 Ryan Hamilton napsal(a):

Hi,

Just released for download: qStudio an IDE for kdb:http://www.timestored.com/qStudio/It has:

  • Charting Straight from Kdb queries (bar / line / candlestick…)
  • Autocomplete of functions/variables
  • Graphical server browsing
  • q syntax highlighting

I hope you find it useful and we are always happy to receive feedback or feature requests so that we can continue to improve it.

  • Ryan Hamilton

–
You received this message because you are subscribed to the Google Groups “Kdb+ Personal Developers” group.
To unsubscribe from this group and stop receiving emails from it, send an email to personal-kdbplus+unsubscribe@googlegroups.com.
To post to this group, send email to personal-kdbplus@googlegroups.com.
Visit this group at http://groups.google.com/group/personal-kdbplus?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--

TimeStored.com - KDB+ Training, Consulting, Software

9

Hi Ryan,

When copying the table into Excel, it only pastes the data, but not the headers. And when I exported it and saved it in Excel, it showed up in a weird file format. Any chance someone has run into this before?

Thanks,
Jeremy

10

Hi Jeremy,

Thanks very much for this feedback it helps us improve qStudio.

Your now the second person to mention the headers and when I think about it.With headers would be better so that will be changed.

The export format is .csv I guess since it doesn’t show the suffix that’s not obvious. Do you think automatically saving it to a temporary random file name and opening it in excel automatically would be more useful? Or should we just show the .csv ?

Thanks again,

Ryan