Archive for the ‘Valentina’ Category
Valentina 4.7 Columnar Database, Reports and Server Released
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.
Valentina 4.6: The Ultra Fast Database Gets Faster
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 »
Speed Up for Opening Valentina Databases with 1000 or More Tables
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.
Paradigma Software Sponsoring Portland Code Camp and SQL Saturday 2010
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 »
Valentina FindContains () Massive Indexed Search Speed Increased
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.
Doing Mailmerges with Valentina Studio Pro and any Valentina Database
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 »
Adding a Barcode to a Report in Valentina Reports
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.
Valentina DB vs National Institute of Health Genome Data
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.
Cocoa Support with REALbasic and Valentina DB
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.
Valentina DB and Windows 7
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.
