Databases: Table#

Database Table is the main representation of the Database section, where connections are displayed in a list with key attributes and actions for each row. It helps to view databases, sort them, tag them, open a database workspace, and perform bulk operations.

Location: Access the section through the left navigation panel, under "Databases".

Available actions:

• View connections to databases in a tabular format
• Switch between "Table" and "Folders" modes
• Search for specific databases in the list
• Sort records by available columns
• Perform bulk operations on selected rows
• Refresh the data list
• Open a separate database workspace
• Add tags to selected records
• Pin databases to folders
• Delete selected databases

Mode Switcher#

The "Table" / "Folders" Mode Switcher is used to change the display of connections without altering the data itself. In "Table" mode, databases are shown in a list, while in "Folders" mode, grouping in the form of cards is available.

Using this switch helps choose a convenient way of working depending on the task. Tabular view is preferable for bulk operations and sorting, while folders mode is suitable for visual grouping.

Additional Actions Menu#

The Additional Actions Menu is used for bulk operations on selected databases. It is accessed through the three-dot icon at the top of the page and contains commands for group work with the list.

Actions in the menu:

1. Select the necessary rows in the table.
2. Click Additional Actions Menu.
3. Choose Update tags for selected databases to refresh the tags.
4. Choose Pin selected databases to a folder to assign a folder.
5. Choose Delete selected databases to remove entries from the list.

After performing an action, changes apply to all previously selected rows. If the operation requires confirmation, the system opens the appropriate dialog window.

Refresh Button#

The Refresh Button is designed to reload the data in the current view. It updates the displayed states, dates, and other information that may have changed since the last page opening.

After clicking, the list synchronizes with the current state of the database. This helps quickly see new changes without reopening the section.

Table Columns#

Table Columns display the main attributes of each database connection. In tabular mode, columns like name, type, tags, update date, and selected are available.

Column names are used for data reading and list sorting. They allow quick assessment of the database type, its tags, and update relevance.

What is visible in the table:

1. Check the name of the connection for quick identification.
2. Review the type to understand the database format.
3. Look at the tags to evaluate record labeling.
4. Consider the update date to see data relevance.
5. Check the selected indicator if the record is already marked.

When a column is used for sorting, the order of rows in the table changes. This is convenient for quickly finding the newest or most active connections.

Database Row#

The Database Row contains one record from the list along with actions for that connection. In a row, you can select a database, open its workspace, add a tag, mark it as selected, or perform other available operations.

Clicking on the name opens a separate window for the selected database. If the database is empty, no records are displayed in the window, and you can return to the list after closing.

Actions in the row:

1. Click the database name to open its workspace.
2. Click the plus icon in the tags column to add a tag.
3. Click the heart icon to mark the database as selected.
4. Click the SQL import icon to choose a file and perform import.
5. Open the three-dot menu to edit the database, pin it to a folder, or delete it.

After applying an action, the state of the corresponding record is updated or a separate window opens for working with the data. If the selected operation requires confirmation, it must be completed in a modal window.

Search and Filters#

Search and Filters are used to quickly narrow down the list of databases to the required records. They help work with a large list of connections without manually reviewing all rows.

After entering a query or selecting a filter, the table shows only relevant records. This simplifies navigation when you need to find a specific database by name, type, or tag.

Table Pagination#

Table Pagination is used to manage the number of rows displayed on the page. At the bottom of the table, elements for navigating between pages and controlling the display limit are available.

After changing the number of rows or navigating between pages, the list is updated according to the selected range. This is convenient when you need to view a short list or work with a large volume of data.

Workflow Scenario#