A wrapper of kdb and sql for convenient trade data management.
Project description
*** IMPORTANT NOTICE ***This package is not in a usable stage. It is only uploaded for convenience of developing and testing. |
Postgreslq Initialization
CREATE DATABASE trade_data;
CREATE USER tradedbadmin WITH PASSWORD 'trade_password';
GRANT ALL PRIVILEGES ON DATABASE trade_data TO tradedbadmin;
\connect trade_data;
GRANT ALL ON SCHEMA public TO tradedbadmin;
Add the following lines in the pg_hba.conf
file to allow password authentication for the tradedbadmin
role.
# trade database
host all tradedbadmin 0.0.0.0/0 scram-sha-256
host all tradedbadmin ::/0 scram-sha-256
KDB+ Initialization
get license
Request a 64-bit license from Kx Systems. Fill the form then the system will send an email with the license file and a base64 key (Either can be used to license the product).
Server side (Linux system)
- Put the executable
q
and license in desired folder, say/opt/l64
directory. - Create a folder to store the data, say
/opt/data
directory. - Set the environment variable
QLIC
to the directory where the license file is stored. AndQHOME
to the data directory. - Run the
q
executable with the following command:$ q -p 5000 -s 1 -w 100 -t 1000 -T 1000 -U /opt/l64/trade.q
-
-p 5000
: This sets the port number for the kdb+ process. In this case, the port number is 5000. -
-s 1
: This sets the number of secondary threads. In this case, it's set to 1. -
-w 100
: This sets the workspace heap size. In this case, it's set to 100 MB. -
-t 1000
: This sets the timer interval in milliseconds. In this case, it's set to 1000 milliseconds, or 1 second. -
-T 1000
: This sets the timeout in seconds for client queries. In this case, it's set to 1000 seconds. -
-U /opt/l64/trade.q
: This sets the access control list file. In this case, the file is located at/opt/l64/trade.q
. This file contains a list of usernames and passwords for clients that are allowed to connect to the kdb+ process.
-
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for trade_database_manager-0.0.1.dev4.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 94df974d5a30179b8cf1585371742127617bcee8a0bffe6a2de22b1dd42acf2b |
|
MD5 | c5ef8b3e6fb58357ab9fb5197b322c25 |
|
BLAKE2b-256 | a869ddac791b18e41fdb227194ffee612f193451059409a8d470049f7fb1167a |
Hashes for trade_database_manager-0.0.1.dev4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d197c012fda4e910f651aba18119c21d667b79316a33e17ef44ca5e2d2c25dc2 |
|
MD5 | e65e1bafd6c49297d0fdbe0a75b4f2e0 |
|
BLAKE2b-256 | 9f95511d99a4857d4170da097dbda2cd07555835f90b4521f1de07bd25beaa06 |