Version 3.3 of Valentina Database

Avatar

Release Notes: SELECT queries can use SQL binding, which may make things about 20 times faster. STORED PROCEDURES can return the last cursor. STATISTIC features. SHOW STATUS [OF SERVER|DATABASE|TABLE|FIELD|LINK]. Valentina Studio introduces DIAGRAM EDITOR for visual management of database schema. The SQL editor has a list of favorite queries.

Other releases

  •  24 Aug 2013 10:01
Avatar

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.

  •  26 Jun 2013 21:17
Avatar

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.

  •  03 Jun 2013 22:01
Avatar

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.

  •  30 Apr 2013 04:19
Avatar

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.

  •  19 Mar 2013 12:50
Avatar

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.

Screenshot

Project Spotlight

Octopussy

A Perl/XML log analyzer, alerter, and reporter.

Screenshot

Project Spotlight

Chaotic Rage

A multiplatform 3D zombie shooter.