Category: English

Posts in English

[Imp][VStudio] SQL Dump/Load now can work with 220 encodings

Up to now Valentina Studio was able to work only with UTF8/UTF16 dump files.

We have realize that we can easy plug ICU library into Valentina Studio itself, because Valentina engine and SQLite plugin already use ICU. In result, SQL Dump/Load dialogs now are able to work with dump files using any of supported by ICU encodings. This is about 220 encodings of the world.

Available in Valentina Studio v5.3

[NEW][VStudio] QueryBuilder and Diagrams now do Smart Prompting of related Tables/Links

One more absolutely innovative feature! You will not find such in any other GUI DB Manager! 🙂

When you adding existing tables to:

  • a diagram  (i.e. you doing reverse engineering), or
  • a diagram of Query Builder

usually it is hard remember, which Tables are related to just added table. Especially this is hard if you try understand not your own database schema.

Now Valentina Studio is able to help you with this problem. When you select one or even more tables on diagram, the list of tables shows immediately on the top tables related to selected.

Look on the following example. We have drag the first table ‘film’, and now on the left side you can see tables Related to: film.

vs_qb_related_to_1

 

Let’s drag the second table ‘film_actor’ and you see list of tables Related to: film_actor. Only one table in this list.

Very easy, yes?  🙂

Continue reading [NEW][VStudio] QueryBuilder and Diagrams now do Smart Prompting of related Tables/Links

[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