Yandex WebSQL release notes: 2024

NovemberNovember

ImprovementsImprovements

1. Added an icon to the list of connections to indicate the connection control type, automatic or manual .

2. Now you can use WebSQL even if you were unable to export clusters of a certain database type. The successfully exported clusters will be available.

3. Reduced the time for getting the PostgreSQL cluster structure.

4. In ClickHouse®, supported autocompletion of the GRANT and REVOKE commands and improved autocompletion of the SELECT, CREATE, DELETE, ALTER, and INSERT commands.

Fixed issuesFixed issues

1. Fixed an issue when working with tables whose names begin with a capital letter in PostgreSQL.

2. Fixed an issue with displaying numeric data types as strings in ClickHouse®.

3. Fixed the duplication of Valkey™ in the Database type list when creating an external connection.

OctoberOctober

1. You can now share the result right after the query was executed.

2. Reduced processing time for fast queries.

SeptemberSeptember

New featuresNew features

1. Now you can connect to unsharded Valkey™ clusters.

2. Added the websql.auditor, websql.executedQueries.auditor, and websql.savedQueries.auditor roles to view query metadata and related access permissions.

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

The backend query timeout was set to 25 seconds.

AugustAugust

ImprovementsImprovements

1. Added access permission management interfaces for completed and saved queries.

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 statistics for completed queries.

Fixed issuesFixed issues

Fixed the filter workflow on the completed queries page.

JulyJuly

ImprovementsImprovements

1. The query history displays authors of completed 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.