We have add support of VIEWs into QueryBuilder.
On the left side now you can see one more tab-panel to see the list of existed views. You can drag and drop a VIEW exactly as Tables, then specify a link(s) between this view and other tables/views as usually. Note that a view have grey color.
So far this app has been the best GUI I’ve seen for dealing with PostgreSQL on OS X or Ubuntu.
by Morganwilde – Version 5.1.1 – May 22, 2013
Ottima app , gratuita e funzionante , intuitiva e anche carina esteticamente. Complimenti agli sviluppatori.
cavoli!!! ★★★★★ Missy0376 – Version 5.1 – Mar 24, 2013 Mac App Store.
This is an amazing product, that is now alongside XCode in my suite. Being able to communicate with MySQL, PostgreSQL and SQLite right out of the box, working on the first try is an impressive thing. The consoidation of the tools access these multiple systems into one tool is a very very nice thing to have. PGAdmin, MySQLWorkbench, and sqlite command line tools are now demoted. I like it so much, I am going to have to try the Valentina DB.
Brilliant Tool ★★★★★ by DM3333 – Version 5.1 – Mar 24, 2013. Mac App Store.
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.
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.
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.
In 5.0 Diagrams was a PRO feature, so was available in free version only in the demo mode: you could create and edit diagram, but you was not able save it for future use.
Working on submitting of Valentina Studio into Apple’s App Store, we was asked to remove from free version any such demo-features. We have decide instead remove it completely, open half of its functionality to free edition of VStudio. In 5.1 build of Valentina Studio you will be able
Disabled will be just forward-engineering, i.e. generation of SQL scripts to produce new schema objects and change existed.
Interesting to note, that a competing product in AppStore, asks in-app purchase 70$ for reverse-engineering. Valentina Studio 5.1 will give this for free. Enjoy 🙂
5.0b60 includes significant improve of LOG files panel of Server Admin tool.
1) Now in the list of log files of a VSERVER you can see two sections. The first is named TAIL and contains only active log files. If you choose one of them, you will see tail (end) of this file with automatic refresh. This is analog of terminal tail command.
2) We have improve protocol between VSERVER and VStudio to exclude from vserver log file commands that send VStudio itself to collect information.
3) We have extend set of SNMP commands that VSERVER supports to increase performance of talk between VSERVER and VStudio. Besides, VSERVER is able proceed these commands absolutely parallel to its main job.