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 principle 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 massive queries and turn out to be sluggish after lengthy durations of time. To resolve a number of the issues, we changed the parser used within the question editor and eliminated some pointless rerenders. Finally 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 online. (Shoutout to the maintainers for creating such an awesome 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 a whole rewrite of the Rockset question editor, so we took the chance to make some further design and usefulness enhancements.
Usability Enhancements
These are a number of the options of the brand new question editor!
For a walkthrough of the modifications, please take a look at this video:
Embedded content material: https://youtu.be/cHUvAG-5lMY
We hope you take pleasure in the brand new question editor! Please tell us when you have any feedback or questions within the Rockset Group.