[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