Category: Valentina Studio

[NEW][VStudio] Copy a Record as CSV/SQL text to clipboard

When you are in DataEditor or SQL Editor Result, you can now select a record and open contextual menu for it. Here you will see new commands

  • Copy Record as CSV
  • Copy Record as SQL

vs_records_copy_menu

Continue reading [NEW][VStudio] Copy a Record as CSV/SQL text to clipboard

[New][VStudio] QueryBuilder now supports VIEWs

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.

 

vs_qb_views

Users Say About Valentina Studio 5.1: Brilliant Tool ★★★★★

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.

[VStudio][New] Ability to add on diagram all linked tables around some table T by a single command

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 …”.

vs_schema_editor_diagram_add_linked_tables

 

 

 

 

 

 

 

It will show you dialog where you can select all or some linked tables, click OK and see linked tables.

vs_schema_editor_diagram_add_linked_tables_result

[VStudio][Imp] SQLEditor now have not-modal panel to do Find/Replace

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.

vs_sql_editor_find

 

 

 

 

 

 

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

vs_sqql_editor_result_find

[VStudio][mySQL] Client library switched from Drizzle to MariaDB

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.