I know SQL and don’t care to learn q. Can I still get my work done while benefiting from kdb’s speed?

Yes and no. q supports SQL out of the box. In many cases, you will see an improvement in performance compared to a similar traditional RDBMS. However, q does not optimize your queries for you, so some queries may actually take more time.

James Gosling stated that he purposely made Java syntax C-like to facilitate the adoption of the JVM platform. q’s query language was similarly designed to resemble SQL. Begin with what you know, and incrementally refine your queries using q-specific features to get the best performance possible.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

This work is licensed under a Creative Commons License.
The views and opinions expressed herein are those of the authors and do not necessarily reflect those of any other person or legal entity.
Kdb+ is the registered trademark of Kx Systems, Inc.