Installing kdb+ on Ubuntu at DigitalOcean
You access and control the droplet via SSH and Bash.
Your droplet is identified by an IP address.
For this tutorial we suppose you have listed the droplet’s IP address in your local hosts file as
(If not, in the following replace
droplet.dev with the IP address.)
Only commercial and 32-bit kdb+ are licensed for use on cloud servers.
This tutorial supposes you
- run Bash on your local machine
- install 32-bit kdb+ on a 32-bit Ubuntu droplet, e.g.
- intend on the server to run one or more scripts, rather than interactive sessions
To run 32-bit kdb+ on a 64-bit server, see the install notes.
Download 32-bit kdb+ to your local machine and unzip it.
You will want the
Change directory to the parent of the folder
Your unzipped files look like this:
$ tree . ├── q │ ├── l32 │ │ └── q │ ├── q.k $
Upload the kdb+ files to your droplet.
Here we suppose you followed recommended practice and created a non-root user with superuser privileges.
We suppose you named this user
and that the kdb+ files will be stored at
/home/boss/q and run by user
$ scp -r . firstname.lastname@example.org:/home/boss/q Enter passphrase for key '/Users/me/.ssh/id_rsa': q.k 100% 22KB 116.1KB/s 00:00 q 100% 642KB 638.2KB/s 00:01 q.k 100% 22KB 78.9KB/s 00:00 q
Define q alias
SSH from your local machine to your droplet. Edit the Bash profile for non-login (i.e. non-interactive) sessions.
$ ssh email@example.com Enter passphrase for key '/Users/me/.ssh/id_rsa': Welcome to Ubuntu 16.04.5 LTS (GNU/Linux 4.4.0-131-generic i686) … boss@droplet:~$ nano ~/.bashrc
Append the following line to the file.
alias q='QHOME=~/q ~/q/l32/q'
The Bash profile
.bashrc sets the environment used for non-login sessions, for example, any script that you set up as a daemon under Systemctl.
Confirm successful installation
.bashrc now for your current (login) session.
boss@droplet:~$ source .bashrc
Confirm kdb+ runs.
boss@droplet:~$ q KDB+ 3.6 2018.07.30 Copyright (C) 1993-2018 Kx Systems l32/ 2()core 4041MB boss install-test 127.0.1.1 NONEXPIRE q)til 6 0 1 2 3 4 5 q)\\ boss@droplet:~$
Interactive kdb+ sessions under Linux use Rlwrap to recall lines from the keyboard buffer. This is less useful for the non-interactive sessions you run on your droplet.
Just as well, because it does not appear possible to install Rlwrap on these droplets.
boss@droplet:~$ rlwrap -r q The program 'rlwrap' is currently not installed. You can install it by typing: sudo apt install rlwrap boss@droplet:~$ sudo apt install rlwrap [sudo] password for boss: Reading package lists... Done Building dependency tree Reading state information... Done E: Unable to locate package rlwrap boss@droplet:~$
Set up a script to run as a service on your droplet: