This is a quick-start guide to kdb+, aimed primarily at those learning independently. It covers system installation, the kdb+ environment, IPC, tables and typical databases, and where to find more material. After completing this you should be able to follow the Borror textbook Q for Mortals, and the Reference.
One caution: you can learn kdb+ reasonably well by independent study, but for serious deployment of the product you need the help of a consultant. This is because kdb+ is typically used for very demanding applications that require experience to set up properly. Contact KX for help with such evaluations.
The kdb+ system is both a database and a programming language.
- kdb+: the database (k database plus)
- q: a general-purpose programming language integrated with kdb+
The best resource for learning q. It includes:
- Jeff Borror’s textbook Q for Mortals
- a Reference for the built-in functions
- interfaces with other languages and processes
- The main discussion forum is the k4 Topicbox. This is available only to licensed customers – please use a work email address to apply for access.
- The Kdb+ Personal Developers forum is an open Google discussion group for users of the free system.
Install free system¶
If you do not already have access to a licensed copy, go to Get started to download and install q.
Two sets of scripts are referenced in this guide:
The free system is distributed with the following example scripts in the main directory:
sp.q– the Suppliers and Parts sample database
trade.q– a stock trades sample database
If you do not have these scripts, get them from KxSystems/kdb and save them in your
Other example files are in the KxSystems/cookbook/start directory.
startdirectory under your
q/start. For example, there should be a file:
Text editor for Windows
Since q source is in plain text files, it is worth installing a good text editor such as Notepad++ or Notepad2.
Some text editors have extensions to provide e.g. syntax highlighting for q. See the list of editor integrations
Graphical user interface¶
When q is run, it displays a console where you can enter commands and see the results. This is all you need to follow the tutorial, and if you just want to learn a little about q, then it is easiest to work in the console.