Valentina Database

Valentina is cross-platform DBMS that makes it easy to switch between a local embedded database and server using the same sources. It supports disk and in-memory databases, field types from Bit to BLOB, and both a SQL92(99) and non-SQL API.

Valentina supports Relational, Extended Navigational, and Object-Relational data models. It introduces a revolutionary model abstraction "Link". It works natively in UTF-16, can accept 270 encodings, and features advanced features such as regular expressions, XML, full-text search, pictures, functions, and calculated fields. It offers triggers, views, and stored procedures.

What is new in this release:

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

What is new in version 5.3:

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

What is new in version 5.2.4:

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

What is new in version 5.2:

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

What is new in version 5.1:

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

What is new in version 5.1 Beta 2:

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

What is new in version 5.0:

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

What is new in version 4.9.1:

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

What is new in version 4.9:

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