lynnfredricks.com

The Technology Tribe

Archive for the ‘Valentina’ Category

Valentina 4.7 Columnar Database, Reports and Server Released

without comments

Paradigma Software shipped Valentina 4.7, including updates to the core columnar database, Valentina Reports and server specific improvements. There were a few really annoying issues put to rest with this release, and more improvements to SQL Explain functions. For Mac OS X developers though, this also brought 64 bit versions of Valentina for Cocoa, Valentina C++ for Mac OS X and Valentina PHP (Client and Standalone) on Mac OS X. Not to be ignored, Valentina PHP Client is also available in a 64  bit version for Linux.

At its core, Valentina DB is a columnar database, but you can treat it much like a traditional relational database.  With its columnar roots, you’ll find your database operations, especially complex queries against databases with records numbering hundreds of thousands or more, far faster than a relational database – with some operations, it may be only twice as fast. With others, its hundreds or thousands of times faster. This is especially meaningful if you are pulling large data sets for analysis with your custom applications. Valentina DB is a long time favorite with financial service application providers.

Written by Lynn Fredricks

July 20th, 2010 at 7:59 am

Valentina 4.6: The Ultra Fast Database Gets Faster

without comments

Valentina DB 4.6 was released yesterday, with some very impressive speed improvements both in index searches and also something as simple as opening a database file. There are also other improvements, like being able to automatically look up functions, store comments and interactively receive log information through an integrated console in Valentina Studio. But what brings it all back to speed is that it enables applications built around Valentina DB, and Valentina Reports, to vastly improve performance, and therefore value. Speed can be your next upgrade. Read the rest of this entry »

Written by Lynn Fredricks

May 4th, 2010 at 9:03 am

Speed Up for Opening Valentina Databases with 1000 or More Tables

without comments

Ruslan Zasukhin, the key developer of Valentina DB at Paradigma Software has found a way to reduce the time it takes to open Valentina databases with more than 1000 tables. The same improvements will also improve indexing speed. If all goes well, this improvement should make it into Valentina DB release 4.5.1 or 4.6.

Written by Lynn Fredricks

April 27th, 2010 at 7:57 am

Posted in Valentina

Tagged with ,

Paradigma Software Sponsoring Portland Code Camp and SQL Saturday 2010

without comments

Paradigma Software is a truly international company, but it also has strong roots in the great Northwest – the Silicon Forest area including the greater Portland area. Paradigma Software is proud to be a sponsor for Portland Code Camp 2010. Read the rest of this entry »

Written by Lynn Fredricks

April 27th, 2010 at 7:51 am

Posted in Valentina

Tagged with ,

Valentina FindContains () Massive Indexed Search Speed Increased

without comments

Ruslan and Valentina user Kem Tekinay wanted FindContain ( ) to be a little faster. The Valentina developer team  was able to speed this up by 10 times. Indexed search on table with 7 million rows has gone down from 46 sec to 4.6 sec.

You can get this using

  • API – VField.FindContains()
  • SQL –  WHERE LOCATE( “what”, fld ) <> 0

It is hard to go more than a single .1 release without some aspect of Valentina DB being optimized for speed.

Written by Lynn Fredricks

March 15th, 2010 at 8:16 am

Posted in Valentina

Tagged with , ,

Doing Mailmerges with Valentina Studio Pro and any Valentina Database

without comments

With the release of Valentina 4, Paradigma Software also introduced Valentina Studio Pro and Valentina Reports. Valentina Studio Pro includes a huge list of improvements over the previous Valentina Studio Admin, but also incorporated a Report Designer for working with Valentina Reports. Now it is possible to set up a project in Valentina Studio Pro that generates a mail merge report based on data in any Valentina database. We’ve posted a video on how to perform mail merges with Valentina Studio Pro and Valentina Reports. Read the rest of this entry »

Written by Lynn Fredricks

March 12th, 2010 at 9:02 am

Posted in Valentina

Tagged with ,

Adding a Barcode to a Report in Valentina Reports

without comments

The Valentina DB team has posted another video showing how to insert an EAN barcode into a Valentina report. Valentina Reports is available for every major development environment for Windows, Mac OS X and Linux, including several RAD tools like Runrev and REALbasic.

Written by Lynn Fredricks

March 11th, 2010 at 2:13 am

Posted in Valentina

Tagged with , ,

Valentina DB vs National Institute of Health Genome Data

without comments

Valentina DB  senior developer Ivan Samhain has been testing Valentina against NIH human genome data to see how well Valentina performs with complex databases and specifically to the advantage of Valentina’s vertical database model over traditional relational database models. His test ran against a smaller data set of 6 GB but it is interesting.

While customers come to Valentina DB from a huge spectrum of development backgrounds and tools (from Adobe Director to C++ to Cocoa Objective C), a large number of customers across the board who work with complex data – financial services and medical data – seem to take a shine to Valentina for producing vertical market applications or services.

Written by Lynn Fredricks

March 3rd, 2010 at 9:42 am

Posted in Valentina

Tagged with ,

Cocoa Support with REALbasic and Valentina DB

without comments

Valentina Dev Log is reporting that V4RB.rbx allows integration with REALbasic for Cocoa. REALbasic is a popular cross-platform development tool (deploys for many platforms, though not as many as Runrev), but its also very significant because its about as close an experience to Visual Basic on the Mac as you can get.

Written by Lynn Fredricks

March 2nd, 2010 at 11:16 am

Posted in Valentina

Tagged with , ,

Valentina DB and Windows 7

without comments

When is no news a feature? When its Valentina DB and Windows 7. Our ongoing tests so far with Valentina DB and Windows 7 have revealed no incompatibilities so far. But that’s just us though – no matter what we do, Paradigma Software’s compliance can’t fix it if your development environment itself has a problem with Windows 7.

Well – there is one fix, and that is to change your development environment. The more you rely either on very portable, non-development specific SQL or utilize the cross-platform, cross-environment native Valentina API, the easier it is to move your front end to another development environment.

Written by Lynn Fredricks

November 2nd, 2009 at 8:49 am