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.
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 Tags: Major
Tags: API, Libraries, Application Frameworks, SQL, sql editor, non-SQL, object-oriented database
Original news: http://freecode.com/projects/valentina