Tag Archive for 'sql'

Standard SQL sucks and this is Why

Recently there was a post on SQL tips by the JOOQ guys. I love their work but I think standard SQL is not the solution to many of these problems. What we need is something new or in this case old, that is built for such queries. What do I mean, well let’s look through […]

Kdb qSQL vs standard SQL queries

Often at the start of one of our training courses I’m asked why banks use the Kdb Database for their tick data. One well known reason is that kdb is really fast at typical financial time-series queries (due to Kdbs column-oriented architecture). Another reason is that qSQL is extremely expressive and well suited for time-series […]