Command Line Kdb+ Charts »

Command Line Kdb+ Charts

September 8th, 2014 by admin

sqlDashboards are included as a bundle with qStudio, part of that package is a command line utility called sqlChart that allows generating customized sql charts from the command line.

Checkout the video to see how you can create a chart based on data from a kdb+ database in 2 minutes:

The sqlChart page has all the documentation you need, Download the qstudio.zip to try it now.

The q Code

C:\temp\ch\qstudio>sqlchart -s kdb -P 5000 -e "([] dt:2013.01.01+til 21; cosineWave:cos a; sineWave:sin a:0.6*til 21)" -c timeseries -W 600 -t  dark
C:\temp\ch\qstudio\out.png

Help Screen

C:\temp\ch\qstudio>sqlchart
Option (* = required)             Description
---------------------             -----------
-?, --help                        Display a help message and exit.
-D, --database <db_name>          The database to use.
-H, --height <output_height>      Set the height of the chart output
                                    (default: 300)
-P, --port <port_num>             The TCP/IP port number to use for the
                                    SQL Server connection.
-W, --width <output_width>        Set the width of the chart output
                                    (default: 400)
-c, --chart <chart_type>          Set the selected chart type. Options
                                    available: timeseries, areachart,
                                    barchart, bubblechart, candlestick,
                                    datatable, heatmap, histogram,
                                    linechart, noredraw, piechart,
                                    scatterplot (default: barchart)
-e, --execute <sql_statement>     Execute the selected sql statement.
-h, --host <host_name>            SQL server host that will be queried.
                                    (default: localhost)
-o, --out <file_name>             The name of the destination image
                                    file. (default: out.png)
-p, --password <password>         Password used to connect to SQL server.
* -s, --servertype <server_type>  The type of sql server being queried.
                                    Valid values include:kdb,mysql,
                                    postgres,mssql,h2.
-t, --theme <color_theme>         Set the color theme for the chart.
                                    Options available: light,dark,pastel
                                    (default: light)
-u, --user <user_name>            Username used to connect to SQL server.

Tags: kdb chart, kdb+, qstudio, timeseries.

No Comments