Yandex WebSQL release notes: 2024

SeptemberSeptember

New featuresNew features

1. Now you can connect to unsharded Redis clusters.

2. Added the websql.auditor, websql.executedQueries.auditor, and websql.savedQueries.auditor roles for viewing metadata requests and permissions to access them.

ImprovementsImprovements

1. Added the experiment of displaying connections as database users.

2. PostgreSQL tables are now displayed as database objects even if the user does not have access to these tables.

3. Added the display of empty PostgreSQL schemas to the list of database objects.

Fixed issuesFixed issues

Configured the backend request timeout as 25 seconds.

AugustAugust

ImprovementsImprovements

1. Added interfaces for managing access permissions for completed and saved requests.

2. Integrated cloud-based time settings.

3. Added the modal window interface for contacting technical support.

4. Now only the tables the user has access to are displayed in PostgreSQL databases.

5. Added completed request statistics.

Fixed issuesFixed issues

Fixed the filter workflow on the completed requests page.

JulyJuly

ImprovementsImprovements

1. Query history displays users who ran the queries.

2. Enabled running queries without exporting the connection structure.

3. Added support for long-running database queries.

4. Added information about databases and certificates to the connection card.

Fixed issuesFixed issues

1. Fixed the error when running all DML queries in a ClickHouse® cluster.

2. Fixed the query editor issue for Safari version 15.

JuneJune

New featuresNew features

1. The Connections tab now displays the Yandex Cloud managed database clusters from the selected folder available to the user. This speeds up the process of creating connections to these clusters, as most of the cluster information is populated automatically. Also updates were made to the forms for creating connections.

2. WebSQL is the first service integrated with Yandex MetaData Hub. All connections are stored in Connection Manager, but you can also manage (create, delete, and edit) them from the WebSQL interface. All changes you make in WebSQL are displayed in Connection Manager and vice versa.

3. You can now publish saved and historical queries. Once published, the query will be available to all folder users. This action cannot be undone — you can only delete the query you published. Roles allow you to manage user access to a published query: you can grant permissions for viewing and editing a query or managing its access permissions.

4. The WebSQL interface now allows you to share links to various entities. For example, you can send a link to a connection, saved query you published, or page with access permissions for a published query to your colleague.

Fixed issuesFixed issues

Improved user query storage mechanism: queries are now linked to the user's account. No matter what device or browser was used to access WebSQL, the user will see all their previous queries.

MayMay

ImprovementsImprovements

Updated the service favicon .

Fixed issuesFixed issues

Fixed the error occurring on connection to a database in which no tables or schemas (for PostgreSQL) were created.

AprilApril

Fixed issuesFixed issues

Fixed a bug that caused the interface to become unavailable when selecting a high-contrast theme in the management console.

MarchMarch

New featuresNew features

1. Added viewing sequence information in PostgreSQL database schemas.

2. In the query editor, added role tips for PostgreSQL databases.

FebruaryFebruary

New featuresNew features

1. New improved autocompletion feature for SQL queries in the query editor.

2. If the table has indexes or triggers, information about them will appear in separate table information sections.

3. The autocompletion feature provides information about indexes and triggers.

Fixed issuesFixed issues

Fixed the incorrect display of variables when opening saved queries.

JanuaryJanuary

New featuresNew features

1. Grouping by date in the query history.

2. Visual settings of the editor.

3. Managing the transfer of the WebSQL SSL certificate upon connection.

4. Support for views in the database structure.

5. Grouping by connection type: external, demo, and Yandex Cloud connections.

6. Simplified modal window for reconnecting.