Release Notes: Data Editor was rewritten to work with huge tables. Significant performance improvements were achieved with MySQL servers serving many databases. The ability to set LIMIT and OFFSET was added in Query Builder. Queries can now be saved and loaded. Self recursive tables are supported in Query Builder. SSL keys generated with Putty can now be used. The speed of saving and loading dumps with MySQL and PostgreSQL was improved. PostgreSQL privileges can now be edited per User or per Schema.
Release Notes: QueryBuilder and diagrams now do Smart Prompt of tables related to a selected one. QueryBuilder works with VIEWs and supports undo/redo actions. DataEditor copies the current record into CSV/SQL format on the clipboard. This release improves SQL Dump/Load support of 220 encodings of a dump file.
Release Notes: This release enables SQL Editor to display a few results if a few commands are executed at once, provides non-modal searching in SQL Editor and Result Grid, adds JSON format support to export records of a table or SQL result, improves work with favorite queries, doubles the speed of SSH connections, switches the client library for the MySQL plugin from Drizzle to MariaDB, shows a list of built-in extensions for SQLite, improves loading of dumps, and adds some bugfixes.
Release Notes: SQL Editor now is able to show few results of a few SELECTs executed at once. JSON format is now supported for dumps of databases, tables, and SQL results. The SQLite plugin shows a list of built-in extensions. The client library for mySQL was switched from Drizzle to MariaDB. You can now sync the tree of databases with a selected database in Columns/Tree mode. Server Admin handles connection errors better. SQL Editor now has auto-completion, showing light grey predictions and more info. Favorite Queries were improved. SSH speed was improved by about 100ms for each command.
Release Notes: VStudio now supports SSH connections to remote database servers such as MySQL, PostgreSQL, and Valentina. A Data Transfer Wizard was provided for transferring records of one/few tables from one database to another. The free version is able to save diagrams and do reverse engineering (i.e. import of existing DB objects). The PRO version adds forward engineering. VENGINE supports a "MAIL" SQL command, which can be used in a Valentina Server to be called by a schedule, sending PDF/HTML reports by email generated by the "SELECT ... FOR REPORT" command, and so on. Some fixes were made to resolve issues with the ODBC driver for the Pervasive database.
Release Notes: VStudio supports SSH connections to remote database servers such as MySQL, PostgreSQL, and Valentina. It has a Data Transfer Wizard to transfer records of one/few tables from db1 to db2. The free version is able to save diagrams and do reverse engineering (i.e. import of existed DB objects). The PRO version adds forward engineering. VENGINE supports an SQL command "MAIL... FROM... TO...", which can be used in a Valentina Server to call it by schedule, to send by email reports (PDF/HTML) generated by the "SELECT ... FOR REPORT" command, and so on.
Release Notes: Valentina Studio basic edition is now free (it was $99) and is a full-featured GUI manager for SQLite, MySQL, and PostgreSQL. Valentina Studio PRO adds Report Editor, Diagram Editor, and SQL Diff features. Valentina Reports can use SQLite, MySQL, PostgreSQL, ODBC, and Valentina DB, and has been integrated into Valentina Studio, Valentina Server, and Valentina Report ADKs for all major languages.
Release Notes: This release introduces Valentina Studio for 64-bit Linux. Archives of all Valentina products for Linux are now in pairs (RPM/deb). A few SQL functions have been added that allow you to check and modify normalization of Unicode text.
Release Notes: This versions adds query statistics profiling and caching of server-side cursors on the client side (x10+ speed up). Valentina Reports has interactive live previewing while you perform steps with a wizard. Valentina reports can work with SQLite and PostgreSQL (beta) data sources in native mode, and any ODBC data source as well. The free iValentina database apps for iPad and iPhone incorporate new usability improvements, including new tab panels for quickly switching between database views and enhancements for the virtual keyboard.
Release Notes: This release introduces 64-bit versions of Mac OS X PHP, Cocoa, and C++ ADKs. Function Browser has been added to Valentina Studio. There are 64-bit versions of Valentina Office Server and Valentina Embedded Server. Recursive SQL operations are supported.