SingleStoreDB Studio Release Notes

Fixes a bug in the Help menu

Fixes some code samples in the Tutorials that were not working on Windows

Fixes a bug where the dashboard was not being populated due to a timeout error

The Message Logs tab in the SQL Editor now remains open when clicked, even while new queries are run

Minor styling fixes

Fixes a bug where the Console was not displaying results

Fixes a bug where the Activity Resource Usage page would not display if one or more activities did not have a MemSQL ID

Adds a warning message when a query is executed for the first time in Visual Explain

Fixes a bug where dates were not being displayed in ISO format

Adds the ability to use Profile Execution time from a JSON file in SingleStoreDB v7.0 or higher

Adds the ability to paste a JSON file into Visual Explain

Fixes some code samples in the Tutorials that were not working on Windows

Fixes a bug where the PROFILE SQL statement was running with a row limit

Adds Total Network Traffic metric to the Visual Explain sidebar

Adds a confirmation modal when changing pages during a tutorial

Sorts activities in Activity Resource Usage by CPU usage by default

Minor styling fixes

Fixes a bug where the automatic SQL Editor reconnection could fail.

Fixes a bug where a tutorial was incorrectly marked as completed

Styling changes to allow for a more compact UI

Minor styling fixes

Adds warning when the profile of a query includes its compile time

Adds ability to configure TLS version and TLS cipher suite for Studio

Adds banner to highlight cluster monitoring feature

Minor styling fixes

Fixes a bug where external links were not working

Adds pipeline and database name validation to the tutorials

Fixes timezone issue in the Activity Resource Usage page

Minor styling fixes

Adds quick start tutorial to the tutorial homepage

Adds interactive tutorials for loading data

Fixes a bug that caused the AdTech tutorial to not load

Fixes a bug where running certain queries in the SQL Editor would error with “Multiple statements detected in a single query”

Fixes icon for Prometheus pipelines in the Pipelines page

Fixes a bug where the selected database in the SQL Editor page would not be saved between page reloads

Breaking change: SQL Editor content stored in your browser’s session buffer will be lost when upgrading to this version. We recommend saving it so you can manually restore it.

Adds support for historical Activity Resource Usage via SingleStoreDB Studio.

Various Tutorial UI fixes and improvements

Removes support for MemSQL 6.7.x versions

Fixes a bug in the SQL Editor where queries that took more than a certain amount of time would never return results

Adds checkable sections to the tutorials in the Tutorial UI that allow users to keep track of their progress throughout the guides

Adds new data (Elapsed Time and Lock Time) to the Activity Resource Usage table

Fixes a bug where the Tutorial UI would be displayed over the Run button in the SQL Editor

Removes information about Sync Durability from the database page which was causing the page to crash when connected to MemSQL clusters running versions earlier than 7.0

Adds database filter to the Activity Resource Usage page

Fixes a bug where SQL Editor content would scroll down when the page loads

Adds a minimize button to the Tutorial UI

Adds SQL previews to the Tutorial UI

(Preview) Adds support for exposing MemSQL’s SAML authentication via the UI

Fixes a bug where certain special characters in a cluster’s description would cause Studio to crash on load

Adds information about Sync Durability to the database page

Truncates the query text in a query error when it exceeds a certain length

Adds total disk available and total memory available to the Dashboard page

Rebrands the UI as “SingleStore Studio”

Fixes a bug where studio.memsql.com could not connect to SingleStoreDBclusters. This has no impact for self-managed users of Studio.

Improves the performance of the “Databases” page

Changes the result columns of the SQL Editor to automatically adjust the width to match the content

Adds “About” page link to the Help menu

Adds a progress indicator to the minimized tutorial button

Fixes a bug where the tutorial UI would close unexpectedly when a user clicked outside of it

Fixes a bug where the monitoring charts in the “Nodes” and “Hosts” pages would not be displayed

Fixes errors related to preloading static assets

Adds Prometheus /api/metrics endpoint to the singlestoredb-studio server

Fixes a bug where Studio wouldn’t function on earlier versions of Firefox

Updates the the sidebar to auto-collapse when the SQL Editor is opened

Improves the UI on the “Databases” page for visualizing the SQL statements for tables and views

Adds a notification when copying code from the tutorial UI

Changes the “Activity Resource Usage” page to allow browsing all activity types in addition to queries

Removes support for MemSQL 6.5.x versions

Incorporates visual improvements to the Help menu

Improves the the SQL Editor functionality where a new tab is now opened when a new query is run

Adds a new “Message Logs” tab in the SQL Editor that contains information about each query that’s been run during the session

SQL Editor scroll and cursor position are now saved across pages and sessions

SQL functions and keywords now appear as autocomplete suggestions in the SQL Editor

Fixes a bug when parsing zero-width characters in the SQL Editor

Allows MemSQL users that have been configured with Kerberos/GSSAPI to sign in

Adds new columns to the “Partitions” page for each database

Adds support for serving the Studio front end under a specific URL prefix

Improves the performance of the “Databases” page in clusters where querying INFORMATION_SCHEMA.COLUMN_STATISTICS would typically take an extended time to return

Fixes a bug where loading the same file in the SQL Editor more than once in the same session would not work

Adds a Settings modal with an option for configuring the number of rows returned for queries run in the SQL Editor

Adds a new tutorial to the Tutorial side panel

Improves the SQL Editor to persist the selected database in the SQL Editor across sessions

Adds tooltips that help explain Compression Ratio

Improves the sidebar to persist its width across sessions

Adds support for directly connecting to MemSQL clusters via WebSocket

Adds a banner notification to alert users when a new version of MemSQL is available

Adds support for serving the User Interface with HTTPS (via TLS)

Fixes a bug in the sorting of the “Partition Instance Status“ column in the “Nodes“ table

Fixes a bug in the sorting of dates in the “Events“ and “Pipelines“ tables

Fixes a bug where the “SQL_MODE“ was not being properly configured when issuing queries to MemSQL

Adds support for invalid cluster profiles in the Studio configuration file

Adds “Disk Usage“ information to columnstore secondary indexes

Adds “rows read per second” and “rows written per second” to the dashboard

Adds a new Projections section to the Visual Explain sidebar

Modifies the Visual Explain feature to display the query text from the plan text file

Adds “table compression” to the table page in the Schema Explorer

Fixes a bug where dates would be incorrectly formatted in the Sample Data tab in the Schema Explorer

Adds support for visualizing query output for those queries that return multiple tables in the Console

Adds the ability to copy the query column to the clipboard in the Active Processes page

Fixes a bug in the SQL Editor that prevented the cursor from selecting the results table scrollbar

Fixes a bug where data would stop loading when changing pages due to the lack of available connections

Displays an error on the console and in the SQL Editor if the connection is dropped while a query is being run

Adds warnings to the Databases page if the databases appear to be offline due to insufficient permissions

Adds various warnings to Visual Explain

Fixes a bug where node CPU usage was calculated incorrectly

On the Databases page, shows how many nodes a database occupies

Adds two tutorials to help users load data into a cluster

Adds support for PAM authentication

Fixes a bug where live monitoring would show perpetual loading bars for CPU Usage

Updates definition for “Disk Read” column on Resource Usage page

Adds a tutorial to the user interface. The tutorial helps users load data into a cluster

Fixes a bug where the “Save as CSV” button in the SQL Editor would disappear from the user interface

Fixes a bug where closing the Studio upgrade notification would cause the UI to crash the next time Studio loads

Visual refactor to the help links on the Sidebar

Adds result tabs to the SQL Editor’s output pane

Disables the bottom panel from appearing when queries fail in the SQL Editor

Visual refactor to the table page in the Schema Explorer

Fixes a bug where tables with a date column would crash the Sample Data tab on the table page

Adds new Active Processes page where queries currently running in MemSQL can be explored

Improves the load time of the Studio application by a factor of four by compressing static assets with gzip

Improves the performance of the Databases page for MemSQL clusters running MemSQL 6.7.11 or higher

Fixes a bug where the Pipelines page would not load on some MemSQL clusters

Adds more information to the query error dialog box in the SQL Editor

Separates the SQL Editor Results user interface into two tabs (one for logs and one for query results)

Changes the placement of the “Save as CSV” button to make it closer to the query results in the SQL Editor

Removes the pagination of SQL Editor results

Fixes a bug where some tabs would not be properly marked as active/inactive

General improvements to the checkbox component style

Updates look to match the new MemSQL brand

Fixes a bug where the Visual Explain tree would not be visible when loading it from the SQL Editor

Fixes a bug where drag handles would be visible on top of modals

Adds Physical Monitoring metrics to clusters running on versions of MemSQL 6.8.6 or higher

Adds support for double clicking column header edges to auto-resize them

Adds a database selector dropdown to the SQL Editor

Adds support for resizing the results pane and the Schema Tree pane in the SQL Editor

Adds support for searching in the SQL Editor Schema Tree

Improves performance of table rendering across all pages

Adds support for disabling current sort state on a table’s column

Fixes some small visual bugs

Fixes a bug where the SQL Editor would disappear on very recent versions of Google Chrome

Improves the Studio browser logs to be more detailed when errors occur

Fixes the calculation of total time in Visual Explain nodes to include network time and CPU time

Displays CPU time as its own metric in Visual Explain nodes

Adds new dashboard design with a focus on the health status of various logical components of the cluster

Persists the selected database in the SQL Editor and the Bottom Panel console across reconnects in the same session

Implements a notification system that informs users about new Studio versions

Adds more information to nodes, databases, and partitions in their respective pages

Replaces the topology URL with nodes

Fixes a bug where the query results would be incorrect for queries that return more than one column with the same name

Fixes a visual bug where resizing table columns would affect other columns

Fixes a visual bug where the schema tree on the SQL Editor would be cut off vertically

Fixes a visual bug with long cluster titles in the clusters list page

Fixes a visual bug where enabling columns in the Resource Usage page would break some columns’ widths

Fixes visual bug with long cluster titles on the sidebar

Adds hosts page with host-level information

Adds partition and partition instance data to the Schema Explorer

Improves the performance of the Schema Explorer by not blocking on columnar segments data

Adds support for deleting clusters from the Studio UI

Adds a refresh button to the schema tree in the SQL Editor

Various visual updates and styling improvements to the sidebar

Adds Studio version card to the About page

Fixes a visual bug in the cluster switcher dropdown

Various visual improvements to the Schema Explorer pages (e.g., new tab styling, new circle indicator styling)

Fixes a bug where users without read permissions on all databases could not view any schema data

Fixes a bug where Stored Procedures would not show up on clusters running versions 6.7.11 or higher

Fixes a bug where the query editor buffer would not be saved on some connections

Fixes a bug in auto-connect

Fixes a bug where the Dashboard would crash when the High Availabilty query failed

Fixes a visual alignment issue in the connect to cluster page

Adds support for unit licensing

Fixes how long cluster names are displayed on the sidebar

Cluster creation via the UI can be disabled via the disableClusterMutations flag in the config

Fixes bug with long hostnames in the UI

Broken release - skip to 1.5.5

If you have trouble upgrading to 1.5.5 from 1.5.4, remove the line allowClusterMutations from the Studio config file.

Adds support for resizing columns in all of the tables in the UI

Fixes a bug where older browsers would not be able to load Studio

Fixes a bug where the SQL Editor content would not be persisted across sessions after logging out from a cluster

Fixes a bug where the “Leave Site” alert would not be disabled in the connect pages after logging out from a cluster

Fixes a few memory leaks in older versions of Chrome and Firefox

Fixes a bug where double clicking table cells would select more than one cell

Fixes a bug where the singlestoredb-studio server would not immediately error when it fails to bind the desired port

Adds support for importing version 3 plan files in Visual Explain

Fixes extra bottom padding at the bottom of the SQL Editor page on Firefox

Fixes a bug where the global SQL MODE on some clusters could break queries that Studio runs

Fixes page load crash on older browsers

Correctly shows the Unsupported Browser page on unsupported browsers

Fixes a bug where the Resource Usage page would incorrectly label some partitions

Fixes how large numbers are rounded and displayed across the application (Visual Explain, Schema Explorer)

Adds a menu item to the SQL Editor for exporting query results as CSV

Improves the performance of the SQL Editor

Revamps the infrastructure of the SQL Editor and adds Find/Replace

Fixes the display of the SHOW CREATE buttons in the Schema Explorer to only show while hovered

New feedback dialog box integrated with the SingleStore Forums

Adds information about Stored Procedures, UDFs, UDAFs and Pipelines to the Schema Explorer

Adds the ability to see the SHOW CREATE statement of any Pipeline

Adds new data from query plans in the Visual Explain sidebar

Fixes a bug where JSON-type columns were incorrectly displayed in the Schema Tree

Updates Visual Explain executor icons

Fixes a bug where switching to the Connection tab in the bottom panel would reload certain pages

Fixes a bug where the bottom panel’s console was not focused when opened

Fixes a bug where the Schema Explorer would not work if there were any UDAFs in the cluster

Fixes a bug where the Visual Explain sibling order was not correct for certain plans

Fixes a bug where the Schema Explorer would crash on clusters with particular schemas

Fixes a bug where reloading the “Nodes Status” page would reset the sorting order of the table

Fixes binary data conversions

Added support for displaying free licenses

Fixes input not being focused when opening console in bottom panel

Fixes error when rendering the Sample Tab for a table with a blob type column

Adds default order by role in “Nodes Status” page

Fixes /var/lib/memsql-studio being incorrectly owned by the root user in RPM installs

Fixes error when connecting to a new cluster as a user with a password

Adds a Sample Data tab to tables and views in the Schema Explorer

The SQL Editor’s buffer is now persisted between page reloads

Fixes a bug where the SQL Editor and console connections would not restore after the connection to the MemSQL cluster is dropped

Fixes the error codes shown to users in the SQL Editor and the console to match MemSQL’s error codes

Shows an error message instead of “No Databases” if fetching schema tree database information fails

Fixes various small visual inconsistencies in the icons and text of Visual Explain

Adds support for clicking on the entire top bar of the bottom panel to resize it

Adds CPU Usage as a default column in Resource Usage

Adds support for MemSQL 6.7 clusters

Adds support for both EXPLAIN and PROFILE plans generated by MemSQL 6.7

Updates Visual Explain icons

Fixes bug with parsing subselects in query plans

Modals can now be closed by clicking outside them

Adds support for reading long cluster titles in the sidebar

Clicking on the MemSQL icon now goes to the Dashboard

Clicking on the cluster name in the sidebar now opens the Cluster Switcher dropdown

Increases the number of results shown per page in the SQL editor to 30

Adds Visual Explain — a new feature which allows users to visually analyze query plans (either PROFILE or EXPLAIN outputs)

Adds ability to load and save SQL files into the SQL Editor

Fixes a bug where users could submit the Add New Cluster form before it was filled in

Fixes the calculation of some metrics in Schema Explorer

Adds commands to the CLI that return the Studio’s version and commit hash

Adds Studio’s commit hash to the UI

Fixes the default config file to be valid HCL

Fixes small styling issues across all pages

Fixes small bugs across all pages

Initial release of SingleStoreDB Studio.