VCLIENT now Caches ServerSide Cursors. Speed Increased a lots…

Valentina CLIENT library provides not only read-only client-side cursor as do e.g. mySQL or PostgreSQL, but server-side cursor also, which can be in NoLocks, ReadOnly and ReadWrite modes.

While client-side cursor loads all result records into client computer RAM at single step, a server-side cursor loads one record only. This allows to use server-side cursors for huge SELECT results. But … if to make on such cursor a GUI grid table to display records, speed of display was not best, because each time GUI asks for other record to draw, server-side cursor have jump to VServer to load it.

Now we have cache for VCLIENT server-side cursors.

  • Speed increased dramatically.
  • VServer gets less job to do.
  • Network traffic goes down

Continue reading VCLIENT now Caches ServerSide Cursors. Speed Increased a lots…

Converting FileMaker Pro Databases into LiveCode Applications

David Simpson has written an excellent article over on Omegabundle.com called Converting FileMaker Pro Databases into LiveCode Applications. dot com Solutions makes a powerful utility product called FmPro Migrator Platinum Edition that is a part of the latest Omegabundle for LiveCode 4.2011 offering.  More than a utility, its really a one of a kind solution for porting Apple FileMaker Pro and Microsoft Access databases into full LiveCode applications, which in turn makes it possible to port the data store over to Valentina DB.

Valentina Reports get ODBC-datasource!

Valentina Reports now support ODBC datasource!

This is great, because now Valentina Reports can work with data stored practically in any database format (MS Access, MS SQL, Oracle, Postgre SQL, mySQL, … ) and even XML.

In Valentina Studio improved datasource dialog to support ODBC.

In a Valentina ADK code, you should specify connection string in the VProject.MakeNewReport( inDataSource ), as the following: odbc://dsn=access,user=name,pass=123

Will be available in the 4.9b5 build or newer.

Index search warnings

There are many find-like methods which are able to employ indexes to speed up the searching (FindLike, FindRegEx, FindContains, and so on). Of course, the field must be  indexed and search preference is set to kPreferIndexed.

But currently there are two issues when index search may bring a wrong result:

1.Index keeps only first 256 symbols of the value – so rest of the symbols are just ignored in such a search.

2. Index-By-Words index and multi-word searching pattern.

Some of the methods like FindRegEx don’t use an index-search but scan the table instead if any of the above occurred. The rest of the methods are less strict choosing the searching algorithm. Now you will get the warning in such cases and you can switch algorithm to not-index search (kPreferNotIndexed) if it is relevant (less speedy but more accurate). Also you should consider to change index type of such a lengthly fields to the index-by-words.
Warning examples:
“Index search in the first 256 symbols only : FindContains t1:f1”
“Index-By-Words search : FindContains t1:f1”

Free DB Oriented Icons for Omegabundle 2011 Customers

The OmegaBundle 2011 has been an overwhelming success. It’s still time for you until 14th February 2011 to order your copy. And as a bonus to new and existing bundle customers, we have an extra Icon set and three articles to read. We’d also like your feedback on the products. There is a very, very short survey we would like you to complete. We estimate it will take less than 5 minutes to complete. This survey is only by invitation and only open to purchasers of this bundle. Continue reading Free DB Oriented Icons for Omegabundle 2011 Customers

Omegabundle 2011 for REAL Studio Developers Extended to 2.14.2011

A group of developer tool makers that support REAL Studio have put together a fantastic bundle of $3200 of pro tools for only $399 – the Omegabundle. This offer lasts only through 2.14.2011 – ie Valentine’s Day. Continue reading Omegabundle 2011 for REAL Studio Developers Extended to 2.14.2011

[VReports][NEW] Improved HTML, Picture Controls

On users request we have made the next major improvements in Valentina Reports:

  • HTML Control now can get HTML text/content from:
    • TEXT typed directly in the control
    • FIELD of cursor
    • by URL from a FIELD of cursor
    • URL (local or remote)
  • Picture Control now can get a picture from:
    • FIELD of cursor
    • URL from a field of cursor
    • URL (local or remote)
  • HTML text can contain a macro $() to, for example, refer another field

You can see details on the following pictures.

Continue reading [VReports][NEW] Improved HTML, Picture Controls

10 Hottest Features of Valentina Office Server

As a part of the Omegabundle 2011 for REAL Studio campaign, I have published the article 10 Hottest Features of Valentina Office Server – which just like it sounds, lists the top 10 features I think are particularly of interest to businesses which need a high performance database and business reports server at the center of their business. This covers a number of advantages you gain based on the underlying technology of Valentina DB, plus also the inclusion of the business reports engine that is also included with Valentina Office Server.

Partner Monkeybread Ships MBS Complete; Included in Omegabundle 2011

As mentioned elsewhere, Paradigma Software partner Monkeybread Software shipped MBS 11, an update to their incredible collection of essential plugins for REALbasic / REAL Studio. This release is version 11, which coincides with how many years the product has been available for the REALbasic platform.

Omegabundle 2011 for REAL Studio purchasers will be happy to know that these new additions and updates are included with the bundle. Omegabundle 2011 for REAL Studio includes over $3200 of add-ons and extensions to REAL Software’s REAL Studio development product – for only $399 – an 81% savings. See the announcement on the Omegabundle 2011 for REAL Studio website.