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
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.
The Valentina team is happy to announce that Valentina Studio supports MariaDB, the drop-in replacement for MySQL from Michael “Monty” Widenius, the creator of MySQL.
Valentina Studio 5.1 is now available for free through Mac App Store. Valentina Studio 5.1 was recently released with support for SSH, making it your best choice for working with virtual hosting services and the databases you may have stored there.
Valentina Studio on the Mac App Store also has in-app upgrading to Valentina Studio Pro for your convenience.
We have discover that ODBC driver of FileMaker 12 have major bug. While it claims that can return the number of rows in recordset, driver just crashes on such request.
Workaround is not found so far …
A user have contact us with problem that Valentina Studio hangs on connect to his Pervasive database via ODBC.
We have found that Pervasive do not understand “WHERE false” construction. It works fine with e.g. “WHERE 1 = 0”.
So we fixing our code to avoid this “WHERE false”.
Usually mySQL servers are closed to access from external IPs. Instead mySQL users are used to connect to remote host using SSH tunnel and then connect to mySQL server like from localhost.
We have add into Valentina Studio support of SSH connects to remote hosts. It is clear that it can be used for any remote DB server: Valentina Server, mySQL or PostgreSQL.
Also we have to push SSH parameters into the connection string of Valentina Reports, so now reports can connect to e.g. remote mySQL server by SSH tunnel also. Read in WIKI.
After 5.0 release we have made the first attempt to submit Valentina Studio into Apple’s Mac App Store. As expected, it was reject with a couple of fair issues and one advice to hide all PRO features in the free edition of VStudio.
Step by step we have come to a new design. On the picture you can see how start page will looks for 5.1 version of Valentina Studio (MAS).
Since we was need to remove “Projects” section anyway, we have decide to put “in-app store” of Valentina Studio on the start page instead of section “Projects”.
If a user will do in-app purchase then PRO features will be enabled and become visible. The section “Projects” will be visible again on the start page.