Kdb+ Tutorials
- Kdb Keyword Reference - by functional area
- QStudio IDE allows connecting to kdb+
Beginner Guides
- What is a kdb Database - a column-oriented database specialised for timeseries analysis
- Getting Started with Kdb
- Video Tutorial for those wanting to learn Kdb/q - Who uses kdb+? - What companies and banks use kdb+ for tick data etc.
- History of Kdb - kdb k4 q kdb what's the difference and who is Arthur?
- Setting up a Kdb Development Environment - installation, linux/windows tools.
- Debugging in Kdb - breakpoints, suspending on client errors, debug outputting.
- Inter-Process Communication - client/server, (a)synchronous, message handlers.
- Creating Live kdb database charts
- kdb+ Functions
Advanced
- Qsql Joins - ij inner join, lj left join, uj union join
- Asof Time-series Joins - aj wj
- Functional Queries - kdb's solution to dynamic sql queries
- Memory Management - buddy memory system, reference counting, version differences
- Kdb Tick Data Store - Tickerplants, RDB's, HDB's.
- Parallel Processing - peach and .Q.fc
- q Programming Style Guidelines - coding standards for effective maintainability
- Kdb database limits and errors - Kdb has its limits.
- Table Attributes - `s# sorted, `p# parted, `u# unique, `g# grouped.
- QUnit - unit testing framework for kdb.
- Strings, Symbols, Enumeration - What symbols are, When to use them. Enumerated symbol types.
- Bitcoin Trading System - using kdb+ tick for market data storage.
- Building our tick hdb - Loading csv data into our historical database
- Software Development (kdb+) Essentials
- Scaling kdb+ - From 5 to 5000 Users
- Kdb+ Interview Questions
References
- Kdb Printable Cheat Sheet - One page reference listing data types, q-sql, joins...
- kdb Math Functions - sin, tan, cos, max, min...
- kdb .z Functions - Getting current date / time etc.
- kdb .Q Functions
- kdb String Functions - Concatenating, changing case, like comparisons.
- kdb IO Functions - kdb Functions that allow writing and reading files
- kdb system commands - Commands available using system "foo bar"
- kdb Database Errors - Exceptions thrown by the q language
- kdb ! Bang - Internal Functions
API
- Java API - querying, subscribing, feedhandler.
- Compile C DLL - in windows and then load into kdb.
- C API - querying, subscribing, feedhandler.
- All Python kdb+ APIs.
- Kola Kdb Python API.
Blog Tutorials
- The Future of kdb+ - Will it expand outside finance?
- 10 Years of kdb+
- Kdb qSQL vs standard SQL queries
- RSI Relative Strength Index in Kdb
- Running q language code within the java runtime
- Exponential Moving Average EMA in Kdb
- Probability of a 12 when you roll two Dice
- kdb+ Twitter Feed Handler
- Timing a kdb Query
- Optimizing a kdb Query
- Kdb Visualization Tools
- JQ Online q Language Runner
Misc.
- Persisting End Users Data - An elegant system for persisting user data.
- q Quirks - compared to standard SQL and string handling.
- Interesting external Kdb links.
- Bitcoin Tickerplant Video
kdb+™ is a registered trademark of Kx Systems, Inc.
