Softpedia >Linux >Database >Database APIs >Valentina Database >  Changelog

Valentina Database Changelog

What's new in Valentina Database 5.4

Aug 24, 2013
  • 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.

New in Valentina Database 5.3 (Jun 27, 2013)

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

New in Valentina Database 5.2.4 (Jun 4, 2013)

  • This version 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.

New in Valentina Database 5.2 (Apr 30, 2013)

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

New in Valentina Database 5.1 (Mar 19, 2013)

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

New in Valentina Database 5.1 Beta 2 (Mar 16, 2013)

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

New in Valentina Database 5.0 (Feb 18, 2013)

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

New in Valentina Database 4.9.1 (Aug 18, 2011)

  • This version 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.

New in Valentina Database 4.9 (Jul 8, 2011)

  • This release 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.

New in Valentina Database 4.7 (Aug 14, 2010)

  • This version 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.

New in Valentina Database 4.0 (Feb 21, 2009)

  • This version introduces Valentina Reports, which let you design reports visually in the Valentina Studio Pro.
  • You can now keep a project with reports on a remote Valentina Server, which now a report server as well as a DB server.
  • You can access a local or remote project from any supported language to produce reports in formats such as PDF, picture, LaTeX, and HTML.
  • Reports can also be printed or saved or shown in a browser.
  • Dozens of improvements were made in the Valentina engine.
  • Major improvements were made in SQL and stored procedures.
  • Support for the iPhone was introduced.