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 Windows Windows POSIX Linux iPhone OS|
|Implementation||C# C++ PHP REALbasic SQL com .NET Ruby LiveCode vb6 VB7|
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.