SingleStore Studio Release Notes

Maintenance Release Changelog

2024-06-04 Version 4.1.0

• Adds an advanced setting to skip time-intensive queries in the dashboard

• Hides incorrect information about memory usage on String data types

2024-02-07 Version 4.0.17

• Fixes a bug where the “Standard” subscription would be displayed as “Unknown”

2023-11-14 Version 4.0.16

• Fixes a bug where the Studio and database engine upgrade banners would not be displayed

2023-10-27 Version 4.0.15

• Fixes a bug in the configuration option that hides the user interface for adding new clusters

2023-09-19 Version 4.0.14

• Adds a new configuration option to hide the user interface for adding new clusters

2023-07-17 Version 4.0.13

• Upgraded the Golang compiler, which is used to build SingleStore Studio, to version 1.20.5.

2023-06-15 Version 4.0.12

• Adds a new “disableUITelemetry” property to the Studio configuration file to disable external requests

2022-12-15 Version 4.0.11

• Fixes a bug where the SQL Definition tab in the Databases page would not be displayed properly

• Removes support for SingleStore versions earlier than 7.1

2022-12-05 Version 4.0.10

• Fixes connection validations for SingleStore Self-Managed users.

2022-11-29 Version 4.0.9

• Fixes connection validations for SingleStore Helios users. This has no impact for self-managed users of Studio.

2022-10-06 Version 4.0.8

• Fixes a bug where some data would not be displayed on the Pipelines page

2022-06-14 Version 4.0.7

• Fixes a bug where the SQL Editor would crash when sorting query result columns

2022-06-01 Version 4.0.6

• Changes Cluster Monitoring to use the table schemas generated from SingleStore v7.8.2

• Fixes a bug in the Active Queries page where the query time would be displayed incorrectly

• Minor style fixes

2022-04-27 Version 4.0.5

• Fixes a bug where queued pipelines would display their last batch status as "Unknown"

2022-03-01 Version 4.0.4

• Fixes a bug where the Workload Monitoring page would be disabled for SingleStore clusters

• Minor style fixes

2022-01-31 Version 4.0.3

• Fixes a bug where the databases page would not load for clusters running SingleStore versions earlier than 7.5

• Fixes a bug where the Table page would crash

2022-01-26 Version 4.0.2

• Fixes a bug where clicking on some Dashboard buttons could cause an error

• Fixes a bug where the SQL Editor page would freeze when using clusters with a very large number of tables

• Fixes a bug where the Databases page would crash while loading new tables

2021-11-11 Version 4.0.1

• Fixes a bug where Historical Monitoring was not displaying any results

• Fixes a bug where the Databases page would sometimes stop working

• Fixes a bug where the cluster schema did not update based on the connected cluster

• Simplifies the Help menu and removes tutorials

• Improves Visual Explain panning

2021-09-21 Version 4.0.0

• Removes support for SingleStore versions earlier than 7.0

• Tutorial content updates

• Fixes a bug where queries would occasionally appear without any information on the Workload Monitoring page

• Fixes a bug where the license expiration date was not reported correctly

• Minor style fixes and other improvements

2021-06-30 Version 3.2.11

• Fixes a bug where the Active Queries page was not displaying all queries

2021-06-23 Version 3.2.10

• Provisioning partitions are now reported with a warning instead of an error

• Renames "Activity Resource Usage" to "Workload Monitoring"

• Renames "Active Processes" to "Active Queries"

• Fixes a bug where the "Active Queries" page would send queries to the cluster too frequently

2021-06-02 Version 3.2.9

• Adds a refresh button on Activity Resource that updates the date for the time period selected

• Adds validation to ensure that a monitoring database name is defined for monitoring clusters

• Fixes a bug where some warnings appeared without a description in the Visual Explain page

• Fixes a bug where some external links were not working

• Fixes a bug where the information_schema database would crash the Databases page

• Fixes a bug where the disk usage in the Databases page would not be displayed for empty databases

• Fixes a bug where the Help menu incorrectly displayed that it was offline

• Fixes a bug where the SQL Editor tabs could not be closed

• Minor style fixes

2021-05-18 Version 3.2.8

• Adds the ability to chat with a SingleStore team member when the Studio UI has Internet access

• Replaces tooltips with modal windows for visualizing query text

• Improves the load performance of the Databases page by changing the order in which the data is displayed

2021-04-08 Version 3.2.7

• Fixes a bug in the Help menu

2021-04-08 Version 3.2.6

• 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

2021-03-23 Version 3.2.5

• 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 SingleStore 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

2021-02-18 Version 3.2.4

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

2021-02-15 Version 3.2.3

• 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

2021-02-04 Version 3.2.2

• Adds banner to highlight cluster monitoring feature

• Minor styling fixes

• Fixes a bug where external links were not working

2021-01-20 Version 3.2.1

• 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

2021-01-08 Version 3.2.0

• 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

2021-01-06 Version 3.1.0

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

• Adds support for historical Activity Resource Usage via SingleStore Studio.

• Various Tutorial UI fixes and improvements

2020-11-19 Version 3.0.0

• 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

2020-10-27 Version 2.0.4

• 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

2020-10-26 Version 2.0.3

• 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

2020-09-23 Version 2.0.2

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

2020-09-23 Version 2.0.1

• 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

2020-08-21 Version 2.0.0

• 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

2020-08-06 Version 1.9.8

• 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

2020-07-09 Version 1.9.7

• 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

2020-05-06 Version 1.9.6

2020-01-22 Version 1.9.5

• 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

2019-12-17 Version 1.9.4

• 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

2019-11-26 Version 1.9.3

• 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

2019-11-06 Version 1.9.2

• 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

2019-10-15 Version 1.9.1

• 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

2019-09-20 Version 1.9.0

• 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

2019-09-06 Version 1.8.2

• 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

2019-09-04 Version 1.8.1

• 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

2019-08-23 Version 1.8.0

• 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

2019-08-12 Version 1.7.1

• 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

2019-08-06 Version 1.7.0

• 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

2019-06-17 Version 1.6.3

• 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

2019-05-03 Version 1.6.2

• 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

2019-05-03 Version 1.6.1

• Fixes visual bug with long cluster titles on the sidebar

2019-05-02 Version 1.6.0

• 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)

2019-03-15 Version 1.5.6

• 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

2019-02-28 Version 1.5.5

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

• Fixes bug with long hostnames in the UI

2019-02-28 Version 1.5.4

• 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.

2019-02-07 Version 1.5.3

• 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

2019-01-23 Version 1.5.2

• 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

2019-01-14 Version 1.5.1

• 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)

2019-01-09 Version 1.5.0

• 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

2018-12-04 Version 1.4.0

• 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

2018-11-20 Version 1.3.4

• 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

2018-11-06 Version 1.3.3

• Fixes binary data conversions

• Added support for displaying free licenses

2018-11-05 Version 1.3.2

• 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

2018-11-01 Version 1.3.1

• 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

2018-10-31 Version 1.3

• 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

2018-10-02 Version 1.2

• 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

2018-08-31 Version 1.1

• 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

2018-08-06 Version 1.0.1

• Initial release of SingleStore Studio.