Stack Overflow
Stack Overflow

Questions tagged [torq]

AquaQ's TorQ framework forms the basis of a production kdb+ system by implementing some core functionality and utilities on top of kdb+, allowing developers to concentrate on the application business logic.

AquaQ's TorQ framework forms the basis of a production kdb+ system by implementing some core functionality and utilities on top of kdb+, allowing developers to concentrate on the application business logic. https://github.com/AquaQAnalytics/TorQ

7 questions
3
votes
2 answers

Splayed table upsert leading to error: `cast

I built a data loader prototype that saves CSV into splayed tables. The workflow is as follows: Create schema the first time e.g. volatilitysurface table: volatilitysurface::([date:`datetime$(); ccypair:`symbol$()] atm_convention:`symbol$();…
SkyWalker
  • 13,729
  • 18
  • 91
  • 187
2
votes
1 answer

TorQ: How to use dataloader partitioning with separate tables that have different date ranges?

I'm trying to populate a prices and quotes database using AquaQ's TorQ. For this purpose I use the .loader.loadallfiles function. The difference being that prices is daily data and quotes is more intraday e.g. FX rates. I do the loading as follows:…
SkyWalker
  • 13,729
  • 18
  • 91
  • 187
2
votes
2 answers

TorQ: .loader.loadallfiles and referential integrity leads to `cast error

I have a table volatilitysurface and a detail table volatilitysurface_smile as part of the detail table I define a foreign key to the master table i.e. volatilitysurface::([date:`datetime$(); ccypair:`symbol$()] atm_convention:`symbol$();…
SkyWalker
  • 13,729
  • 18
  • 91
  • 187
0
votes
0 answers

How to use groups to authenticate KDB users?

I am trying to use LDAP to authenticate users for my KDB app. The ldap utility I am using https://github.com/KxSystems/ldap/blob/master/docs/reference.md The only problem is that the institution I am working for prefers using groups instead of…
user91991993
  • 705
  • 5
  • 11
0
votes
0 answers

Why isn't the shipped ldap functionality work in TorQ?

I have 2 kdb apps: a TorQ plant for a personal project some other company app that runs in dev and prod I want to use LDAP to authenticate myself in the TorQ app. I have configured it with the correct server and port (I took the configs from the…
user91991993
  • 705
  • 5
  • 11
0
votes
1 answer

TorQ: How to update disk database populated with .loader.loadallfiles?

I populate a disk database from large CSV files using TorQ's .loader.loadallfiles in a cumulative fashion and it works great. However, I now need to also append data coming from a streaming source and I'm not sure what's the best way to go. I know…
SkyWalker
  • 13,729
  • 18
  • 91
  • 187
-1
votes
1 answer

How to use TorQ framework to manage multiple kdb plants

I started using TorQ for a personal project. I have an app which has 3 plants. 1 for options 1 for equities 1 for fx (I am using some mock data I found around) For my system I will have 1 tp, 1 rdb, 2 hdbs and 1 wdb for each plant. There will be…
user91991993
  • 705
  • 5
  • 11