Valentina Database News

Paradigma Software Valentina Studio 2.3.1 Released

DATABASE MANAGEMENT TOOL GAINS OVER 60 IMPROVEMENTS, UNIVERSAL BINARY FORMAT SUPPORT

April 28, 2006. Beaverton, Oregon. Leading multi-platform database vendor Paradigma Software, Inc announces the release of Valentina Studio, Admin Edition 2.3.1. The product lets developers and administrators create, query, modify and administrate local Valentina 2.x databases and Valentina Office Server. (more…)

Valentina for Cocoa is ready for public beta testing. Its downloadable here.

Valentina for Cocoa is based on the Valentina 2.x architecture. That is, its a robust, extremely fast database system for creating desktop and true server applications (with  Valentina Embedded Server). If you program with Cocoa and want fast and flexible, Valentina for Cocoa is for you.

A few notes on this release:

• If you aware of our class design for Valentina for REALbasic, you will find some similarities to how its structured in Valentina for Cocoa.
• Valentina for Cocoa is for use with Objective-C, programming in xCode on the Mac
• The API is ready for use with Apple’s binding mechanism
• Sorry, there is only one code example with this release
• V4CC is in Universal Binary Format! Valentina for Cocoa joins out Valentina C++ ADK and Valentina Studio products.

We invite everybody with an interest in Cocoa framework programming to give this a try. Quite a few developers who develop with REALbasic on the Mac seem to either be picking up Cocoa development or migrating there. We’ve tried to make migration as easy as possible.

BREAKTHROUGH SPEED ON JOINS; NEW SQL COMMANDS

Leading multi-platform database vendor Paradigma Software, Inc, makers of the ultra-fast Valentina 2 Office Server, announce the shipping of Valentina 2.3.

Valentina 2’s next generation, object-relational database model builds on the traditional relational database model much like C++ builds on top of the C language. All that you know from working with traditional database systems from IBM, Oracle and Microsoft also apply to Valentina-based development. This robust technology excels at ultra fast management of millions of records. Valentina is not another in-memory database but a true disk based DBMS.

Valentina 2.3 includes a dramatic leap forward in speed for database JOINS (including data from two or more database tables) with a new breakthrough algorithm. In a comparative analysis in base configurations between Valentina and MS SQL Server 2000 on Windows, on joins of 5,000,000 and 20,000,000 record test databases, Valentina was between 2-6 times faster than MS SQL Server. Based on file structural differences of even larger databases, Valentina 2.3 can be 50-100 times faster or more (MS Server, mySQL, PostGre, SQLite and Oracle have the same file based limitations), depending on the record size of a table. (more…)

Do you know that you must pay mySQL for any commercial or non-open source use of mySQL drivers or mySQL Server?
When it comes to licensing, Valentina gets compared with both non-network (local runtime only) and network (includes a server component) databases. This is fair and reasonable since Valentina database runtimes come in two varieties: Application Developer Kits (local runtime only, but includes a client) and Embedded Server, a part of Valentina Developer Network. There are some serious gotchas with mySQL commercial licensing in particular - gotchas we resolved in licensing Valentina. (more…)

During the month of April, 2006, every upgrade or new order of Valentina 2.x for REALbasic ADK, Professional Edition will also include a five connection version of Valentina Office Server.

Valentina Office Server is the business ready database server for MacOS X or Windows, suitable for internal network use or driving websites. Based on the ultra-fast Valentina 2.x database engine, Valentina Office Server is one of the fastest, most robust developer friendly databases available.

You can utilize the Vclient component from the Valentina ADKs to connect to Valentina Office Server from these development environments or components - at no additional cost: COM (VB 6), Director,.NET (C#, VB.net), REALbasic, Revolution and C++ (MS Visual Studio and a Universal Binary Vclient for xCode). Also includes VPHP for Apache (with PEAR and AdoDB), enabling PHP 4+ scripting for Valentina Office Server.

Valentina ADK for REALbasic allows connectivity to Valentina databases using REALbasic Standard or Pro, and includes modern conventions such as encryption, XML, Valentina SQL and Unicode UTF 16. It also provides a “classes” method of sub-classing databases using the REALbasic methodology.

Valentina 2.2 ADK for REAL Software’s REALbasic also introduced support for Mach-O, three new array handling functions, three new bit handling functions, and four new record navigation functions. Performance improvements for conversion from Valentina 1.x to 2.x format were also included.

Direct Universal Binary support will be added to Valentina for REALbasic ADK when native support is available in REALbasic.

Valentina ADK Pro for REALbasic costs $299 (upgrades are $149.50) and includes both MacOS X and Windows runtimes and Valentina Studio, a tool for setting up, browsing and administering Valentina databases. The MacOS version of Valentina Studio is a Universal Binary version.

We have moved the following documentation sections to the Valentina Database wiki:

• VSDK Example Guide Introduction - contains an introduction to different types of example projects available and associated notes included in the Valentina C++ ADK and Valentina Developer network.

• Common Examples - contains code examples that show features and techniques common between both the Valentina SQL and Valentina API methods. These are the common examples available in all Valentina ADKs and VDN, not only for C++.

• SQL Style Examples - contains examples that show how to work with Valentina databases using SQL. These are the common examples available in all Valentina ADKs and VDN, not only for C++.

• API Style Examples- contains examples that show how to work with Valentina databases using native Valentina API methods.These are the common examples available in all Valentina ADKs and VDN, not only for C++.