If you have database with a lots of tables, you will like this search field to easy locate required table and then drag it to a diagram of the Query Builder.

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 replaced modal dialog to not modal panel, which appears at the top by CMD+F.  You can find all related commands and shortcuts in the menu Edit.

Also Find-panel added into the result of SQL query. In the search menu for result you can select which columns should be searched.

Now you can open dialog for favorite queries where you can

• rename 
• change order of queries in menu
• correct text of a query

Valentina Studio usually uses the most fresh SQLite engine available. Additionally we compile it using few popular extensions. We have expose these built-in extensions in the dialog “Extensions” of a SQLite database. Note, that you can add more if you needed with the help of this dialog.

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.

Hi friends,

all these three products now are ready for download from App Store:

• VStudio – [link]
• iValentina for iPhone – [link]
• iValentina for iPad - [link]