Skip to content

KxSystems/csharpkdb

Repository files navigation

C# KDB

Travis Coverage

The C# KDB library provides functionality for .NET applications to interface with a kdb+ process.

The library is compiled on .NET Standard 2.0 and supports running applications on

  • .NET Core 2.0 - 3.1
  • .NET Framework 4.6.1 - 4.8

See https://dotnet.microsoft.com/platform/dotnet-standard for further details

Documentation in 📂 docs

Client integration

NuGet releases

Latest release version can be downloaded from NuGet.

Client-applications can search and install "CSharpKDB" package either via

Example

PM> Find-Package CSharpKDB

Id                                  Versions                                 Description                                                                                  
--                                  --------                                 -----------                                                                                  
CSharpKDB                                                                    "Provides functionality for .NET applications to interface with a kdb+ process.               "
Time Elapsed: 00:00:00.8274076

PM> Install-Package CSharpKDB
Restoring packages for ...
Installing NuGet package CSharpKDB ....

c.cs

The main entry point for client applications is the kx.c.cs class.

Example:

  public static void Main(string[]args)
  {
    //establish connection
    c connection = null;    
    try
    {
      connection = new c("localhost", 5001);
      connection.ReceiveTimeout = 1000;
      connection.e = System.Text.Encoding.UTF8;

      Console.WriteLine("Unicode " + connection.k("`$\"c\"$0x52616e627920426ac3b6726b6c756e64204142"));
      
      //insert some data-rows
      object [] x = new object[]
      { 
        DateTime.Now.TimeOfDay,
        "xx",
        (double)93.5,
        300,
      };

      for (int i = 0; i < 1000; ++i)
      {
        connection.k("insert", "trade", x);
      }

      //read data
      Flip result = c.td(connection.k("select sum price by sym from trade"));
      
      Console.WriteLine("cols: " + c.n(result.x));
      Console.WriteLine("rows: "+ c.n(result.y[0]));
    }
    finally
    {
      //finally close connection
      connection.Close();
    }
  }

Examples

Supplied with the code is a series of code examples. The following describes each with an example of how to run from command prompt. Note minimum .NET Core SDK and Runtime should be installed.

QueryResponse demo

Instructs the remote kdb+ process to execute q code (kdb+ native language) and receives the result. The same principle can be used to execute q functions. Example of a sync request:

Prerequisite:

  • a kdb+ server running on port 5001 on your machine i.e. q -p 5001

Run commands:

REM Need to ensure nuget dependencies have been loaded
dotnet restore .\CSharpKdb.sln 

REM Build Release version of Demo application
dotnet msbuild Demos\QueryResponseDemo\QueryResponseDemo.csproj /p:Configuration="Release"

REM Run demo application
dotnet .\Demos\QueryResponseDemo\bin\Release\netcoreapp3.1\QueryResponseDemo.dll 

Serialization demo

Example of code that can be used to serialize/dezerialize a C# type (array of ints) to kdb+ format.

Prerequisite:

  • a kdb+ server running on port 5001 on your machine i.e. q -p 5001

Run commands:

REM Need to ensure nuget dependencies have been loaded
dotnet restore .\CSharpKdb.sln 

REM Build Release version of Demo application
dotnet msbuild Demos\SerializationDemo\SerializationDemo.csproj /p:Configuration="Release"

REM Run demo application
dotnet .\Demos\SerializationDemo\bin\Release\netcoreapp3.1\SerializationDemo.dll 

Feed demo

Example of creating an update function remotely (to capture table inserts), along with table creation and population of the table. Table population has an example of single row inserts (lower latency) and bulk inserts (better throughput and resource utilization).

Prerequisite:

  • a kdb+ server running on port 5001 on your machine i.e. q -p 5001.

  • as this example depends on a .u.upd function being defined and a table named mytable pre-existing, you may wish to run the following within the kdb+ server (in normal environments, these table and function definitions should be pre-created by your kdb+ admin).

q).u.upd:{[tbl;row] insert[tbl](row)}
q)mytable:([]time:`timespan$();sym:`symbol$();price:`float$();size:`long$())

Run commands:

REM Need to ensure nuget dependencies have been loaded
dotnet restore .\CSharpKdb.sln 

REM Build Release version of Demo application
dotnet msbuild Demos\FeedDemo\FeedDemo.csproj /p:Configuration="Release"

REM Run demo application
dotnet .\Demos\FeedDemo\bin\Release\netcoreapp3.1\FeedDemo.dll 

Subscriber demo

Example app that subscribes to real-time updates from a table that is maintained in kdb+.

Prerequisite:

  • a kdb+ server running on port 5001 on your machine. The instance must have the .u.sub function defined. An example of .u.sub can be found in KxSystems/kdb-tick, an example tickerplant. You can execute this tickerplant process by running q tick.q. (The default port is set to 5001.)

Run commands:

REM Need to ensure nuget dependencies have been loaded
dotnet restore .\CSharpKdb.sln 

REM Build Release version of Demo application
dotnet msbuild Demos\SubscriberDemo\SubscriberDemo.csproj /p:Configuration="Release"

REM Run demo application
dotnet .\Demos\SubscriberDemo\bin\Release\netcoreapp3.1\SubscriberDemo.dll 

Change record

  • 2020-11-16 : Issue 2# : Reformat code
  • 2017-05-23 : Identify string[] as type 11
  • 2017-04-18 : Added ssl/tls support
  • 2014-01-29 : Make method n public
  • 2013-12-19 : qn did not detect null guid
  • 2013-12-10 : Remove retry logic on authentication fail. For kdb+2.5 and prior,

Use

B = new byte[1+u.Length];
Connect(h,p);
s=this.GetStream();
J=0;w(u);
s.Write(B,0,J);
if(1!=s.Read(B,0,1))...
  • 2013.09.16 : za represents -0Wd, not 0Nd
  • 2013.08.20 : null val for TimeStamp -> nj
  • 2012.06.07 : Fixed scoping of GUID
  • 2012.05.29 : For use with kdb+v3.0, changed handshake and added Guid. boolean v6->vt tracks type capability.
  • 2012.01.26 : Refactored clamp into clampDT, for Date.DateTime()
  • 2012.01.25 : rz() clamp datetime to valid range
  • 2010.11.17 : Block sending new timetypes to version of kdb+ prior to v2.6 (use prior release of c.cs for older kdb+ versions)

Max buffer size (default 64kB) used for reading is now a parameter to the c constructor Date, Month, Minute, Second, KTimeSpan are now serializable, implement IComparable and have default constructors for xml serialization.

Added NULL(Type t)

  • 2010/08.05 : Added KException for exceptions due to server error, authentication fail and func decode
  • 2010/01.14 : Exposed static var e (Encoding) as public
  • 2010/01.12 : Added support for unicode encoding, defaults to ASCII
  • 2010/01.11 : Added null checks for qn for UDTs Date,Month,Minute,Second,KTimespan
  • 2010/01.04 : Added new time types (timespan->KTimespan,timestamp->DateTime), drop writing kdb+ datetime
  • 2009/10.19 : Limit reads to blocks of 64kB to reduce load on kernel memory
  • 2007/09.26 : 0Wz to MaxValue
  • 2006/10.05 : Truncate string at null
  • 2006/09.29 : NULL c.Date class(sync with c.java)

SSL/TLS: To use self-signed certificates add them to the Local Computer Trusted Root Certification Authorities