Valentina is cross-platform SQL and non-SQL columnar database that allows development of client-server [Web] solutions and applications with an embedded local database using the same sources. Valentina DB provides an Object-Relational model, but you can also mix Relational and Extended Navigational. It introduces a revolutionary model abstraction "Link" that greatly simplifies db schema, and therefore simplifies SQL queries. It supports disk and in-memory databases, and field types including Bit, BLOB, Pictures, and Enum. It provides advanced features such as triggers, views, stored procedures, regular expressions, XML, full-text search, and calculated fields. It exists as Valentina Server, Valentina Studio, and a set of Valentina ADKs for all major programming languages.
|Tags||API Libraries Application Frameworks SQL sql editor non-SQL object-oriented database|
|Operating Systems||Mac OS X Windows POSIX Linux iPhone OS|
|Implementation||C# C++ PHP REALbasic SQL com .NET Ruby LiveCode vb6 VB7|
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.