SingleStore DB

SingleStore DB Studio Release Notes

Maintenance Release Changelog

2021-09-21 Version 4.0.0

  • Removes support for SingleStore DB 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 DB 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. We recommend saving it so you can manually restore it.

  • Adds support for historical Activity Resource Usage with SingleStore DB Monitoring.

  • 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 SingleStore Managed Service clusters. This has no impact for on-premises users of MemSQL/SingleStore DB 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 SingleStore DB 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 SingleStore DB 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

Bug fixes
  • Fixes a bug where the Stock Trade Database tutorial would error while starting a pipeline

  • Fixes a bug where Studio could potentially send too many repeated connections to the cluster

  • Stops warning users about an incorrect replication type on replica partitions for databases marked as replicas

  • Fixes a bug where the Sample Data tab in the Databases page would crash if a user back-navigates

  • Fixes pipeline icons for MemSQL clusters above version 7

Performance improvements
  • Reduces the bundle size of the Studio web application by 3x, decreasing the time it takes for the UI to initially load

UX improvements
  • Improves number formatting of byte-type values to better display large numbers

  • Improves time formatting to show seconds rather than fractions of a minute

  • Adds support for hours in the resource usage counter

  • [On-premise] - Improves error message when Studio is unable to connect a cluster

  • [On-premise] - Improves message when removing cluster from Studio

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 SingleStore DB 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 SingleStore DB 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 SingleStore DB Studio’s version and commit hash

  • Adds SingleStore DB 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 DB Studio.