Databases: "Folders" Mode#

Viewing Databases in "Folders" Mode is an alternative display mode for the "Databases" section, where databases are presented as cards grouped by folders. It allows organizing databases into folders, assigning tags, filtering the list by status, and performing key actions with each database directly from the card.

Location: Access the mode through the left navigation panel, under "Databases", by toggling the "Folders" switch in the top panel.

Available Actions:

• Switch between table and folder views
• Create a new database through the add button
• Select all visible cards simultaneously using the "Databases" checkbox
• Filter the list by status: selected, deleted, or all
• Change the order of cards through the sorting menu
• Open a database by clicking on the open icon
• Mark a database as favorite using the heart icon
• Assign tags and perform SQL import or export from the card
• Perform additional actions through the three-dot menu on the card

"Folders" Switch#

The "Folders" Switch is used to change the page display mode from table to folder view. It is located in the top panel of the "Databases" section and allows switching to a card view where databases are grouped by folders.

After clicking Folders, the page is rebuilt: instead of table rows, database cards organized in corresponding folders are displayed.

Add Database Button#

The Add Database Button is used to create a new database directly from the folders mode. It is located in the top panel of the page and opens the "Create Database" dialog.

How to create a database:

1. Click + Add Database in the top panel.
2. Enter the name of the new database in the "Create Database" dialog.
3. Click Confirm.

After confirmation, the new database appears on the page as a card in the current folder view.

"Databases" Checkbox#

The "Databases" Checkbox is used to select all visible cards on the page simultaneously. It is located in the top panel next to the add button and allows quickly creating a set for group operations.

After activating the checkbox, all cards displayed on the page receive a selection mark. This allows applying group actions - for example, assigning tags or pinning to a folder - to all visible databases at once.

"Filters" Panel#

The "Filters" Panel is used to narrow down the card list by their current status. It is located in the right part of the top panel and contains three display options.

How to apply a filter:

1. Click Filters in the top panel.
2. Choose one of the options:
   • Show Selected Only - displays only databases marked as selected.
   • Show Deleted Only - displays only deleted databases.
   • Show All - returns the full list without filtering.

After selection, the page refreshes and shows only the cards that match the chosen status.

"Sort By" Menu#

The "Sort By" Menu is used to change the order of displaying database cards on the page. It is located in the top panel next to the filters panel and allows selecting a sorting rule for the current viewing mode.

After choosing a rule, the cards are rearranged according to the selected criterion - for example, alphabetically or by date.

Database Card#

The Database Card is the main element of the folders mode, displaying an individual database with its name, tags, and available actions. The card includes a selection checkbox, action icons, and a three-dot menu.

The card allows performing all key operations with the database without switching to other sections: open, mark as favorite, assign tags, import or export, and access an extended action menu.

Open Icon#

The Open Icon is used to directly navigate to the working window of the database. It is located on the database card and is the primary way to open a database in the folders mode.

After clicking open icon on the card, the transition to the working window of the corresponding database occurs.

Heart Icon#

The Heart Icon is used to mark a database as favorite. It is located on the database card and allows quickly flagging important databases for further filtering through "Show Selected Only".

After clicking heart icon, the database receives the favorite status, and the icon changes appearance. Clicking again removes the mark.

Tags on Card#

Tags on Card are used for quickly assigning or viewing database tags directly in the folders mode. Tags are displayed directly on the card and allow visually classifying databases without accessing settings.

How to assign a tag:

1. Click on the tags area on the database card.
2. Select the desired tag from the list in the "Tags" window.
3. Click Assign.

After assigning the tag, it is displayed on the database card and becomes available for filtering.

SQL Import and Export Icons#

The SQL Import and Export Icons are used for quickly initiating import or export operations of database data directly from the card in the folders mode. They are located on the database card next to other action icons.

Clicking on the import icon opens a file selection dialog for data upload to the database. Clicking on the Export Database icon initiates the data export process with the corresponding parameters.

Three-Dot Menu#

The Three-Dot Menu is used to access a full set of actions with the database on the card. It opens by clicking on the ⋯ icon in the top right corner of the card and includes commands for editing, restoring, deleting, pinning to a folder, and managing tags.

How to perform an action through the menu:

1. Click ⋮ on the relevant database card.
2. Choose the desired action:
   • Edit Database - opens the "Edit Database" dialog for changing the name or parameters.
   • Pin to Folder - opens the dialog to assign the database to a folder.
   • Set Tags - opens the "Tags" window to update database tags.
   • Restore Database - restores a deleted database to the active list.
   • Delete Permanently - permanently deletes the database without the possibility of recovery.
   • Delete Database - moves the database to deleted items.
3. Confirm the action in the respective dialog if it appears.

After performing the action, the card refreshes or disappears from the page depending on the selected operation.

Workflow Scenario#