All notable changes to the kdb VS Code extension are documented in this file.
- Fix for results tab flickering , improving of UX
- Fix for Issue #382
- Added the ability to add multiple labels to a single connection
- Show KDB+ process explorer item content when clicked
- Added the ability to export and import connections
- All the files in the workspace are considered when using language server features
- Show call hierarchy is implemented in language server
- Query history shows an ellipsis of the query execution text to the available line length
- Added limit option to datasource for 1.11 + versions of Insights Enterprise connections
- Fixed KDB results columns resizing back to default sizes every time a datasource was run
- Fixed KDB results for large data sets
- Now you can edit existing connections
- You can now reconnect to an edited connection (if the connection was already connected)
- Labels are now available for connections
- Now you can connect Insights servers with a self-signed SSL certificate
- Updated KDB+ process icons
- https is prefixed for unschemed Insights server urls
- Use the custom editor to open datasource when renaming or deleting
- Removed unnecessary buttons in walkthrough
- Fixed toggle parameter cache doesn't work in workbooks
- Fixed files can't be executed from entity tree
- Fixed output pane doesn't work after connection idle
- Fixed incorrect behaviour on q process startup failure
- Fixed datasource icon discrepancy between views
- Fixed axios security vulnerability
- Update Ag-Grid package to avoid prototype pollution
- Display meta data for Insights connections
- Added option to click on meta data and open the meta data in json format
- Ability to change the name of the Keycloak realm, used for authentication, from the default value of
insights. This enables the connection to a kdb Insights Enterprise Free trial instance - Improve the console log quality to "kdb" output pane
- Insights free trial instances are supported
- Added execute block command for q code
- Added hotkey to cache function parameters for q code
- Extension now recognizes which version of Insights is connected
- Extension changes scratchpad endpoints according to the Insights versions
- Allow connection information in user settings to be editable
- Allow same server address to be used in multiple connections
- Language server features works on unsaved files
- Expand Selection command is implemented
- Disconnect when q process is stopped
- Fix query execution on KDB+ connections not refreshing completion items
- Fixed delay when executing query on KDB+ connections
- Make connection names case insensitive
- Fixed GUID type displayed as number for Insights
- Fixed problem when the user closes (not hides) the Results Tab
- Fixed time zone for populate scratchpad
- Added logging framework
- Local connection listener behaviour fixed (if the connection is closed, the connection will disconnect)
- Return to show console output if results tab isn't visible in case of query execution
- Linter fixes
- Documentation fixes.
This release requires VS Code version 1.86.0 or higher.
- Multiple Connections - It is now possible to have more than one connection open simultaneously. q and Python files run against the active connection, which can be chosen from the list of open connections.
- Workbooks - We have introduced Workbook files, which can be associated with a specific connection rather than just running against the active connection. These files are identified with the extension
*.kdb.q(for q) or*.kdb.py(for Python) and are created in.kxdirectory of the current workspace folder.- A new WORKBOOK view displays the list of Workbooks per workspace.
- Data sources - Data sources can be associated with a specific connection rather than just running against the active connection. They are created in the
.kxdirectory of the current workspace folder as*.kdb.jsonfiles.- A new DATASOURCES view displays the list of data sources per workspace.
- Data Source Editor - The data source editor visual design has been improved.
- OUTLINE - A new OUTLINE view provides support for q and quke files.
- Command Grouping - All extension commands are now grouped under the KX prefix.
- Syntax Highlighting - The syntax highlighting for q and quke files has been improved.
- Connections Icons - New status sensitive icons have been implemented for connections/
- q file icon - New icon for q files.
- Inconsistent command descriptions have been fixed.
- The Execute entire file button was only working when the code editor was selected. This is resolved.
- Language server, parser and linter improvements.
- Updated dependencies.
- Corrected parser inconsistencies
- Language server support for quke files
- Improved query execution for Insights connections
- Changed the workflow of adding new connections to improve the experience of new users
- Previously when running code without an active q connection nothing took place, now an error message is displayed
- KDB Results tab now supports display the result of a scan operation
- Using the query panel to re-run the query will now show the new results
- Corrected issues with linter warnings about undeclared variables, and declared variables not being used as parameters
- Connections must now have unique names
- Unprojected function assignments are now displayed in output
- The limitation of 64 characters for the server name has been increased to 2048
- "temporality" parameter of getData API in kdb Insights has been updated
- MacOS keyboard shortcut documentation has been updated
- Issues with the colorization of comments have been fixed
- Ability to connect to Insights Enterprise in case of remote development environments such as WSL and SSH.
- Execute files from the right-click menu.
- On the Results tab, on a kdb Insights Enterprise connection, hover the mouse over a column header to see the column Q type if it exists.
- Linting enhancements:
- Implement the following rules:
- Declare after use
- Invalid Escape
- Fixed Seed
- Too many arguments - when more than 8 arguments are being passed
- Line length limits have been removed to ensure there are no warnings after a long block comment.
- Handle .z.exit correctly.
- Optionally disable linting.
- Implement the following rules:
-
Ability to switch users connected to a kdb Insights Enterprise URL. The new flow to switch users when you are already logged in is as follows:
- Disconnect from the URL.
- Log into the URL using browser and log out of environment.
- On reconnecting you are asked to enter your login details and you can chose a different user.
-
Fix to ensure you can login again if a login attempt fails.
-
Fix for an invalid "settings.json" file causing "Add Connection" to fail without error.
-
Ensure the "Execute Entire File" button works even if the cursor is not in the code editor window.
-
Fixes for the Data Sources:
- Custom APIs are no longer listed, these will be added in a future release when the execution of a Custom API is supported.
- The "Run" button will be greyed out while a Data Source is executing, to ensure there are no concurrent executions.
- To see Data Source results within the "Output" tab, ensure that the output is from "q Console Output".
-
Fixes for the tree:
- The only variables being displayed were longs.
- Connections were string queries were forbidden broke the tree
-
Fixes for KDB Results:
- incorrect display of empty tables
- not displaying results for non-tables or non-atoms.
-
Fix for incorrectly displayed types for local q and kdb Insights Enterprise connections.
-
Fix for the console occasionally displaying the results from the previous query.
-
Fix for syntax highlighting when using the @see qdoc tag
- Fixed various CVEs
- Documentation fixes
- Execution of Python code on kdb Insights Enterprise
- Rename symbol support
- Basic linting support
- kdb+/q REPL flow
- Fix auto closing quote in wrong place
- Fix confusing scratchpad wording
- Fix for datasource rename
- Fix for datasource qsql execution
- Fix flickering output tab
- Fix for activate results view on query execution
- Fix for displaying error messages from datasource execution
- Fix non-ascii character rendering for console and results view
- Removed request-promise dependency
- Implemented webview tests
- Documentation fixes
- Updated connection creation workflow
- Reduced visual noise in output pane
- Several fixes for results tab
- Fix where uppercase variables are flagged as issues
- Fix where removing connection did not disconnect first
- Fixes for highlighting and indenting
- Fix to remove option to run q in a new instance if not available
- Updated authentication service
- Improved datasource rendering
### Internal Improvements
- Documentation improvements
- Added kdb Insights Enterprise connections
- kdb Insights Enterprise Scratchpad integration; execute q commands and scripts in VS Code
- Create persisted Data Sources to execute API, SQL and qSQL against kdb Insights Enterprise connections
- Populate Scratchpads from Data Sources and interrogate on the scratchpad
- Support for TLS secured remote kdb connections
- KDB Results View - graphical tabular view of executed queries
### Internal Improvements
- Improved kdb connections tree to support embedded namespaces
- kdb connections tree is now sorted
- Autocomplete fixes for embedded namespaces
- KX Language Server improvements
-
Renamed to 'kdb'
-
Preview KX Language Server implementation
-
New context sensitive icons for tree view
-
Refresh functionality moved from context menu to icon in view title bar
-
Fix where namespaces without a prefix would have duplicate items and incorrect contexts
-
Fix to display objects in the default namespace with no prepended "."
-
Fix to only allow expanding the instance/node if a connection is active
-
Fix to filter "," namespace from views retrieval
- Added command to refresh server objects
-
Server objects can now be enumerated without a pre-script
-
Tree for non-default namespaces and variables are now filtered to ensure views are not present
-
Views tree now shows views correctly
-
Language server no longer makes duplicate suggestions
-
Fix for context menu after new server object items are added, all options now shown
- Logo improved to work with both light and dark themes
-
Added explorer tree for viewing q server objects
-
Added autocomplete and code navigation
- Fixed colors for syntax highlighting
- Added language server to support code completion and navigation
-
If no text is selected, Ctrl+Q will execute the current line
-
Results now scroll into view on execution
-
Clearer error message if empty query is executed
- QHOME path now respected for existing q installations, and local connections can be created for them
-
Queries are now wrapped with .Q.s to support displaying all possible types in results
-
Branding updates
-
Updated onboarding flow design, also improved q process management after onboarding
-
Added ability to execute a file or the current selection and display results in the Output pane
-
Added activity bar
- Fix for Mac that showed a message when single clicking the connection in connection manager
-
Updated onboarding flow to direct the user to the external KX website for new licenses.
-
Updated onboarding flow to allow users to use both the base64 encoded string or downloaded file for license.
- Removed q terminal from the extension with the decision to use the editor and output window in favor of the confusion with the terminal.
- Updated the connection manager to validate input for new connections, including alias, hostname, port, username and password.
- Updated the connection manager to allow aliases to be optional.
- Fixed issue when after establishing a connection via connection manager, and the kdb instance going down, the UI still showed connected. This update will provide the user a toast style notification about the connection failure as well as updating the connection status in the connection manager UI (tree).
-
Added the core Azure infrastructure code that will be used by subsequent releases to deploy KX Insights directly from VS Code.
-
Added internal validation code for Azure resources.
- Fixed issue with bundling with esbuild to address issues with node-fetch used by Azure resources.
- Fixed extension activation not registered for terminal (and other new commands).
-
Updated the connection manager to use aliases for connections
-
Updated the connection manager to allow auth for kdb endpoints, using the secret storage in VS Code for protection of secrets
- Fixes to global storage for server info in better to manage form.
- Initial infrastructure code for SQL queries from editor, more to come in next release.
-
Updated the q terminal to not be started by the Command Pallette and instead be started / stopped from the normal terminal controls.
-
Updated the q terminal to use the shared connection manager for kdb connections.
-
Added the walkthrough for new users.
- Updated installation logic. The extension will now check to see if QHOME is defined and if so, it will assume that the user has already installed the runtime. If there is no QHOME defined, the extension will prompt the user to install. These will use generic uris which we are still figuring out. There are really 3 profiles for users. The first would be a "managed" install, which would install the bits inside VS Code for the user. The second would be where the user wants to install q runtime outside of VS Code and use it in there, and be guided by the extension and the last is the advanced user who already has the q runtime installed.
- Updated the internal connection manager caching for better response and less connections required when using multiple inputs such as q terminal and the editor pane.
-
Add visual indicator to registered connections in the kdb servers panel. This is used to inform the user of the currently connected (active connections) kdb server.
-
Add logic to ensure only one connection can be activated at a specific time.
-
Add welcome panel when no connections are registered.
- Removed the check for q install, this is being reworked to no annoy users with local installs.