Yandex WebSQL release notes: 2024
October
-
You can now share the result right after the query was executed.
-
Reduced processing time for fast queries.
September
New features
-
Now you can connect to unsharded Redis clusters.
-
Added the
websql.auditor
,websql.executedQueries.auditor
, andwebsql.savedQueries.auditor
roles to view query metadata and related access permissions.
Improvements
-
Added the experiment of displaying connections as database users.
-
PostgreSQL tables are now displayed as database objects even if the user does not have access to these tables.
-
Added the display of empty PostgreSQL schemas to the list of database objects.
Fixed issues
The backend query timeout was set to 25 seconds.
August
Improvements
-
Added access permission management interfaces for completed and saved queries.
-
Integrated cloud-based time settings.
-
Added the modal window interface for contacting technical support.
-
Now only the tables the user has access to are displayed in PostgreSQL databases.
-
Added statistics for completed queries.
Fixed issues
Fixed the filter workflow on the completed queries page.
July
Improvements
-
The query history displays authors of completed queries.
-
Enabled running queries without exporting the connection structure.
-
Added support for long-running database queries.
-
Added information about databases and certificates to the connection card.
Fixed issues
-
Fixed the error when running all DML queries in a ClickHouse® cluster.
-
Fixed the query editor issue for Safari version 15.
June
New features
-
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.
-
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.
-
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.
-
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 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.
May
Improvements
Updated the service favicon
Fixed issues
Fixed the error occurring on connection to a database in which no tables or schemas (for PostgreSQL) were created.
April
Fixed issues
Fixed a bug that caused the interface to become unavailable when selecting a high-contrast theme in the management console.
March
New features
-
Added viewing sequence information in PostgreSQL database schemas.
-
In the query editor, added role tips for PostgreSQL
databases.
February
New features
-
New improved autocompletion feature for SQL queries in the query editor.
-
If the table has indexes or triggers, information about them will appear in separate table information sections.
-
The autocompletion feature provides information about indexes and triggers.
Fixed issues
Fixed the incorrect display of variables when opening saved queries.
January
New features
-
Grouping by date in the query history.
-
Managing the transfer of the WebSQL SSL certificate upon connection.
-
Support for views in the database structure.
-
Grouping by connection type: external, demo, and Yandex Cloud connections.
-
Simplified modal window for reconnecting.