Category: Language

Up to now there was trouble in Valentina Studio in Data Editor with huge tables working with mySQL or PostgreSQL, because DataEditor did try load all records at once via client-side cursor. For a Valentina Server database was used server-side cursor, for a local Valentina DB or SQLite also there was no troubles.

Interesting to note, that other manager tools as Navicat, Workbench, … implement own data editors, which work with some sub-set of records (e.g. 4000 records) and user must manually click buttons “Next subset”, “PrevSubset”.

In contrast, we have implement load of records subsets in absolutely transparent for user way. So there is no additional buttons and overall it looks more natural.

Available for download starting from 4.5b5: http://www.valentina-db.com/download/beta/4.5b5

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

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.

 

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

Subject says all. Now you can do cmd+Z/ctrl+Z to undo most actions in QueryBuilder: drag table, move table, select field, type something in the query grid, …

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

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

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.