Let you want todo reverse engineering, i.e. visualize some existed tables and links on a new diagram. Let you want to expose on a diagram some family of linked tables. You add the first table and meet problem. You usually don’t know/remember which other tables are linked.
Now you have great help on this step. In the contextual menu of Table, in the model find command “Add Linked Tables …”.
It will show you dialog where you can select all or some linked tables, click OK and see linked tables.
We have made final switch from Drizzle to MariaDB client library for mySQL plugin and mySQL datasource in Valentina Reports.
Thank to this step we have got C client library with totally same API as native mySQL client library and therefore:
a) Implement support of few results of few commands executed at once.
b) Resolve trouble of some users which have passwords in old format.
In v5.2 of Valentina Studio we have added JSON format of dumps of Database and Table. In SQL Editor’s result pane you can choose Export -> JSON also.
Now you can execute in the SQL Editor few SELECT commands at once, separated by ’;’ and you will get few result TAB-panels opened automatically. One panel for each result.
This feature works for mySQL, PostgreSQL and SQLite starting with v5.2 of Valentina Studio
This is for working with native Valentina databases.
Read this article in the Valentina WIKI about how to work with objects Database -> Tables -> Fields that have hierarchy of Collation Settings.