Valentina Database News

ADDS NEW SQL COMMANDS AND UNIVERSAL BINARY VERSION FOR REALBASIC

Beaverton, Oregon-based Paradigma Software, Inc announces the immediate availability of Valentina Technology Release 2.4.3 for all developer and business products. The release provides numerous minor productivity improvements in addition to new, advanced SQL features and Universal Binary support for REAL Software’s REALbasic development system.

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 business products include Valentina Office Server for Windows and MacOS X (PPC and Intel) and Valentina Studio, a fast and easy to use visual tool for creating, browsing, querying and administering both local and server-side Valentina databases. Valentina developer products are the Valentina 2 Application Developer Kits that allow for royalty free incorporation into desktop applications. Valentina Developer Network allows royalty free distribution of Valentina Embedded Database Server. Developer solutions are available for every major development system on MacOS X and Windows: Apple xCode (C++, Cocoa), MS Visual Studio (.net and COM), REALbasic, Revolution, Delphi and more.

Valentina technology includes support for Valentina XML import/export, Valentina SQL (SQL 92 + extensions), native Unicode UTF-16 support, simultaneous data exchange, transparent file formats, and more. Highly optimized and unique technology allows Valentina database solutions to operate hundreds to thousands of times faster than competing database technologies.

General features in all Valentina 2.4.3 ADKS and Valentina Office Server:

COMPACT RECORDS PROTOCOL. A new network protocol to compress transmitted records by an average of 50%.

PACKET VERSIONING PROTOCOL. Packets can transmit versioning information allowing improved communication with older/newer versions of the Valentina client and Valentina Server components.

SQL: DROP TABLE [IF EXISTS]. If a table exists, it is automatically dropped without an error message; this speeds rapid modification of table structure without interactive feedback.

SQL: CREATE TABLE [IF NOT EXISTS]. If a table doesn’t already exist, then it is automatically created without generating an error message.

SQL: CREATE [TEMPORARY] TABLE AS SELECT. This feature allows a new table to be created with a select statement, allowing very complex behaviors to be executed on the newly created table. An example is to automatically CLONE an existing table into a new table.

Features in Valentina Special Releases:

VALENTINA FOR REALBASIC Universal Binary Version. The best selling local and client-server database solution for REAL Software’s REALbasic is now Universal Binary on MacOS X 10.4 Intel. During the month of October, 2006, new users and upgrades to Valentina for REALbasic ADK Pro will also receive a free copy of Valentina Office Server 5-Connections, a $299 value! Valentina Office Server Universal Binary version was released in spring 2006.

VALENTINA STUDIO ENHANCED. The visual database creation, browsing and administration tool includes over 20 fixes and productivity improvements.

Valentina 2.4.3 is a free upgrade for current users of Valentina 2.x products. All new features have been documented on the company wiki. Valentina 2.4.3 ADKs start at $199. Valentina Developer Network, which allows royalty free distribution of Valentina Embedded Server, starts at $499.

For more information, visit the Paradigma Software website at http://www.paradigmasoft.com.

BROAD VALENTINA TECHNOLOGY IMPROVEMENTS AND NEW VISUAL SQL QUERY BUILDER

Beaverton, Oregon-based Paradigma Software, Inc announces the immediate availability of Valentina Technology Release 2.4.2 for all developer and business products, and Valentina Studio 2.4.2, now with visual SQL Query Builder. Read the rest of this entry »

Paradigma Software Releases Valentina 2.4

NEW COMMUNICATION PROTOCOL, UNIVERAL BINARY SERVER

Beaverton, Oregon-based Paradigma Software, Inc announces the immediate availability of Valentina Technology Release 2.4, including Valentina Office Server for MacOS X Universal Binary edition and all developer tools for MacOS X and Windows. Read the rest of this entry »

Paradigma Software Releases Valentina 2.4 for Revolution

NEW COMMUNICATION PROTOCOL, UNIVERAL BINARY SERVER

Beaverton, Oregon-based Paradigma Software, Inc announces the immediate availability of Valentina 2.4, including Valentina Office Server for MacOS X Universal Binary edition and all developer tools for MacOS X and Windows, including Valentina 2.4 for Revolution - which incorporates a universal binary version for the Mac-on-Intel platform.
Read the rest of this entry »

Paradigma Software Releases Valentina 2.4 for REALbasic

NEW COMMUNICATION PROTOCOL, UNIVERAL BINARY SERVER

Beaverton, Oregon-based Paradigma Software, Inc announces the immediate availability of Valentina 2.4, including Valentina Office Server for MacOS X Universal Binary edition and all developer tools for MacOS X and Windows, including Valentina 2.4 for REALbasic. The release allows REALbasic developers to take some advantage of native universal binary versions of the Valentina database kernel.
Read the rest of this entry »

Paradigma Software Releases Valentina 2.4 for Adobe Director

NEW COMMUNICATION PROTOCOL, UNIVERAL BINARY SERVER

Beaverton, Oregon-based Paradigma Software, Inc announces the immediate availability of Valentina 2.4, including Valentina Office Server for MacOS X Universal Binary edition and all developer tools for MacOS X and Windows, including Valentina for Adobe Director. The release allows Adobe Director developers to take some advantage of native universal binary versions of the Valentina database kernel.
Read the rest of this entry »

Our engineers have developed  new REINDEXing algorithms for Valentina that could increase reindexing speed by over a multiple of 100.

On a G 5 Dual Processor, 2 Ghz Mac, a five million record reindexing takes over 10 minutes. With the new algorithms, the same reindexing takes between 6-9 seconds.

A secondary benefit is that the size of the index file is reduced in half. A reduced index size means not only making better use of available space on read only media (CDROM, DVDROM) but also an increase in indexing speed since the kernel has to spend less time working with the index file.

An example - a customer database with tables that have 10 and 20 million records each. For ULONG fields:

10M records table

• old index = 240MB
• new index = 120MB

20M records table

• old index = 480MB
• new index = 240MB

The advancements can be demonstrated on numeric fields <=4 bytes. i.e. Byte, Short, Ushort, Medium, Medium, Long, ULong, Float, Date, Time.

The Paradigma R&D team is researching the creation of a similar algorithm for string fields. You can test the new reindexing algorithms in the next beta release of Valentina 2.4.

VInstaller 1.0 is a helper utility to simplify the creation of Mach-O applications for Mac OS X that use Valentina 2.x or later. When you create a Mach-O application with REALbasic, you need to insert the VComponents libraries into the application package after the build is complete. VInstaller makes this a one step process.

Installing the VComponents folder is a very easy thing to do manually, but becomes a pain in the rear end since it is tedious to open up the application package and navigate to the “Contents” folder and then copy the VComponents folder to that location. Also, if you infrequently build a final application for distribution or testing, it is easy to accidently install the wrong VComponents folder (i.e., the one for carbon builds) and spend time trying to figure out why your application is crashing. VInstaller turns this into a one step “no brainer” operation.

System Requirements:

Mac OS X 10.2 or later

VInstaller is free from True North Software.

Paradigma Software is updating Valentina for Revolution to increase compatibility with Revolution 2.x. This release includes the following features:

• Support for RevDB. Now it is possible to use RevDB exactly like any other supported database (such as Valentina XCMD 1.11)
• Installer for Revolution Stack. A new stack that eases installing Valentina 2.x. This removes the tedium of having to manually set up the external.
• Test Project.  A new test project which automates testing each feature of Valentina 2.x for Revolution.
• RevDB API Bridge. Use the RevDB API yet still have access to direct calls to Valentina (to access the many advanced features of Valentina that cannot otherwise be exposed through query builder).
• Explain Feature. A new kernel feature can optionally allow each SQL query to be written to a log to help diagnose your database solution.

Several other new features are in the works.

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. Read the rest of this entry »