Creating SQL queries is a necessary a part of the Rockset product expertise. We’re excited to announce the discharge of a brand new question editor within the Rockset Console with improved efficiency and an up to date design.

Upgraded Efficiency

The primary motivation for the brand new question editor expertise was to resolve the efficiency problems with our outdated question editor. Whereas it was typically usable, typing within the outdated question editor would lag when engaged on giant queries and turn out to be sluggish after lengthy intervals of time. To resolve a few of the issues, we changed the parser used within the question editor and eliminated some pointless rerenders. In the end although, the efficiency most dramatically improved by altering the libraries that again the question editor. The Rockset question editor is constructed on CodeMirror, an open supply code editor library for the net. (Shoutout to the maintainers for creating such an ideal library!) In June 2022, the brand new CodeMirror 6 model was launched. CodeMirror 6 is a from-scratch implementation of CodeMirror based mostly on the learnings of the earlier variations with main extensibility and efficiency enhancements. Upgrading to CodeMirror 6 required an entire rewrite of the Rockset question editor, so we took the chance to make some extra design and usefulness enhancements.

Usability Enhancements

These are a few of the options of the brand new question editor!

For a walkthrough of the adjustments, please try this video:

Embedded content material: https://youtu.be/cHUvAG-5lMY

We hope you get pleasure from the brand new question editor! Please tell us when you’ve got any feedback or questions within the Rockset Group.