English – Page 5 – Paradigma Software Blog

[VStudio][New] Query Builder now have Search field at bottom of Table list

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.

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

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

[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.

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

[VStudio] Improved work with Favorite SQL Queries in SQL Editor

Now you can open dialog for favorite queries where you can

rename
change order of queries in menu
correct text of a query

[VStudio][SQLite] Shows list of built-in extensions.

Valentina Studio usually uses the most fresh SQLite engine available. Additionally we compile it using few popular extensions. We have expose these built-in extensions in the dialog “Extensions” of a SQLite database. Note, that you can add more if you needed with the help of this dialog.

[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.

[VStudio] Added JSON format for dumps of DB, Table and SQL results

In v5.2 of Valentina Studio we have added JSON format of dumps of Database and Table. In SQL Editor’s result pane you can choose Export -> JSON also.

[VStudio] SQL Editor is able show few results at once

Now you can execute in the SQL Editor few SELECT commands at once, separated by ‘;’ and you will get few result TAB-panels opened automatically. One panel for each result.

This feature works for mySQL, PostgreSQL and SQLite starting with v5.2 of Valentina Studio

[Valentina Studio] How to Work with Hierarchy of Objects for Collation Settings

This is for working with native Valentina databases.

Read this article in the Valentina WIKI about how to work with objects Database -> Tables -> Fields that have hierarchy of Collation Settings.

VStudio 5.1.1 and iValentina (iPhone/iPad) 5.1.1 in App Store

Hi friends,

all these three products now are ready for download from App Store:

VStudio – [link]
iValentina for iPhone – [link]
iValentina for iPad – [link]

Valentina Studio Supports MariaDB

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 now will try to open read-only dbs in older format

One use of 4.9 Valentina ADK have told us that many his users have databases on DVD in 4,9 format. So if he will try change his app to Valentina 5.0, then how users will be able work with this read-only databases?

To resolve this, we have improve Valentina engine. Now it will make attempt to work with read-only databases in older format as is, without conversion.

Important to note, that this will work fine for 5.x engine opening 4.x databases.

Valentina Studio on Mac App Store

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.

[ANN] Valentina 5.1 Released

Have gone month after 5.0 release, and we ship one more release – 5.1.

New Features

This release adds three major features:

[VKernel][New] SQL command ‘MAIL’ on Valentina kernel level
[VStudio][New] SSH connections in Valentina Studio, works from reports also.
[VStudio][New] Data Transfer Wizard.

New FREE Feature in VStudio

We make one more feature to be FREE in Valentina Studio!

You can now create and SAVE diagrams in Valentina Studio (free) 5.1. Up to now you could only create them but not save, because this was PRO feature.

Besides, you can do reverse engineering – i.e. add existed database objects to diagram. Note, that Navicat Modeler from the Mac App Store, asks 70$ only for this feature.

Forward-engineering remains as feature of Valentina Studio Pro.

Fixes

Some fixes in ODBC code, to resolve issues in work with ODBC driver of Pervasive database.

Details you can read in Release Notes 5.1

[VStudio] ODBC talk to driver of FileMaker 12

We have discover that ODBC driver of FileMaker 12 have major bug. While it claims that can return the number of rows in recordset, driver just crashes on such request.

Workaround is not found so far …