Switch to: V12V11V10V9V8V7V6V5

Schema Editor - Column View

In the Column View you browse a databases schema using columns. When you select in a Nth column some object, then N+1 column at right to it displays elements of this selected object. So you can navigate in such way by database schema.

This layout is similar to MAC OS X Finder. The only significant difference is that Valentina Studio have filter menu on the top of each column. We need this because a database object (e.g. Table) can have several kinds of elements (e.g. Fields, Methods, Links, Triggers), while Finder expose only files and folders.



On the left side presents not scrollable area with groups of connections, bookmarks and recent items.

Connections

In this group you can see existed connections to database servers (Valentina Server, PostgreSQL, mySQL). Each connection has icon that indicates the type of connection and the name/IP of the server. At right side of item you can see “Eject” icon that allow you close this connection and all its databases.

Note, that local databases are grouped under “Valentina Files” and “SQLite Files” pseudo-connections that always are visible in this group.

Each connection have contextual menu with commands that you can execute for it. You can read details about each contextual menu here:

You can do the right-click on “Connections” group name to get contextual menu to manage list, e.g. clear it.

Bonjour

In this group are shown Valentina Servers that promote self via Apple Bonjour Service. Each Valentina Server can promote normal and/or SSL ports. Double click on such item automatically connects you to a such Valentina Server, you will be asked only for login/password. After connection, one more connection item is added into the group “Connections”.

Bookmarks

In this group, you can see bookmarks for quick connection to frequently used servers. Usually a bookmark saves even your username/password, so it needs just a double click to connect.

Note that, as on the start page, the bookmark icon displays the status of the server.

You can do the right-click on the “Bookmarks” group name to get contextual menu to manage list, e.g. clear it.

Recent Connections

In this group recent connections to databases servers are listed. The most recent connection is on the top. You can double click item to connect to a server. If password was not saved, then you will be asked for password only.

You can do the right-click on the “Recent Connection” group name to get contextual menu to manage list, e.g. clear it.

Recent Databases

In this group recent local databases are listed. The most recent connection is on the top. You can double click item to open that database.

You can do the right-click on the “Recent Databases” group name to get contextual menu to manage list, e.g. clear it.

Page Toolbar

The Page Toolbar or Schema Editor has:

  • Dynamic set of action-buttons, which changes depending on selected object.
  • Search Field that allows you to search child objects of a selected object by name using different patterns.

On the following picture you can see the result of search in the scope of database (because database is the select object) of all tables that “contains” literal 'Stat' in their name. Result is displayed immediately while you are typing.



Note, that on the right side of menu “Tables” is displayed icon of FILTER. If you move mouse cursor over this icon you will see tooltip, which describes applyied condition, for example: Contains 'Stat'. Right click on the filter-icon displays its contextual menu with “Remove” command.

You can go even more deep. Select one of filtered table and start type another search-string, which will filter now fields of that table. Note that now both menus “Tables” and “Fields” have filter icon.



Both these filters are independent. You can remove filter from “Tables” column, but “Fields” column still have filter. Important to note, that this is a filter for the column, not just to one table. This means that you can setup filter “Name” for column “Fields” and by arrow keys UP/DOWN easy check all tables to see, which of them have field “Name”. Watch this video to see how it works:

rlGKzrgwJaU

Also you can select few objects at once (e.g. Tables) to see their child-objects (e.g. Fields) together. You can select few objects in the column using SHIFT and CMD (ALT for win) modifiers.



Such search feature is very useful when you know e.g. the name of field, but don't know or remember in which table it is. This can happens for example, if you learn third party database and related code.

Columns

You have columns to see hierarchy of objects of database schema. The first column shows the databases itself, each next column is able to show elements of a selected object of the previous column. For example, when you select a database in the first column, then the second column can show or sub-elements of database: Table, Links, Triggers, Procedures, Indexes, … When you select a Table in the second column you will see its Fields in the third column (as well as Links, Triggers, …).

Column can show objects of the same kind only, so each column has a menu on the top that allows to choose a kind of objects to display.

Resize Columns

  • You can resize each column by draging of its right bottom icon “||”.
  • If you press and keep button ALT for Windows or Option for MAC during resize then all columns will get new the same width.

Contextual Menu

  • You can do mouse right click on the empty space of the first column to get contextual menu, which contains commands available for data sources.
  • You can do mouse right click on item to get contextual menu for that item.
  • If you close a data source item then this closes all databases opened under its scope.

Property Inspector

On the right side of Schema Editor in all three modes may present the Property Inspector. It displays properties of a selected object, so you can read them and edit.

Property Inspector can be hidden and shown from the application menu VIEW and using shortcut CMD + I.