QStudio Feature Tour kdb+

QStudio is a free SQL client with particularly strong support for kdb+ including syntax highlighting, code completion and built-in documentation. In this video we go over some of the more advanced features of QStudio.

Download QStudio

This demo is QStudio version 4.0, we release regularly and recommend updating to get the latest features.

Video Contents:

• Adding a server
• Browsing server tree.
• Running code using Keyboard shortcuts
  • Ctrl + E to query the currently highlighted text. If no text is selected, all text in the current document is sent.
  • Ctrl + Enter to query the current line where the cursor is.
• Auto-completing code and builtin-documentation.
• Charting - Generating charts directly from SQL queries.
• Changing the light/dark user theme.
• 05:55 Exporting Results to Excel
• 06:24 Pivoting Tables
• 07:25 Saving Results to a local qDuckDB database.
• 08:00 SQL Notebooks