Archive for the ‘Language’ Category

IOEncoding usage in V4REV

Assume there is some “not-latin” text  (it could be russian or umlauts or something similar). And we have to store it to the Valentina database and then read it back.

Read the rest of this entry »

New LogFilesLocation property

There is a new property – LogFilesLocation for both server and local.
It defines a folder where the logs should be placed in.
Default folder is “./vlogs”

Read the rest of this entry »

MAC 64 bits – introducing vcomponents_x64 for ADKs/x64

Yesterday I have try to make installer of VPHP_Standalone_x64, which could be our first 64-bit ADK,  and have realize that it is not good idea keep in the same /usr/local/lib/vcomponents both 32 and 64 bit DLLs.

Read the rest of this entry »

Renew Before Expiration for Discounted Pricing

Last year, Paradigma Software announced a grace period to go along with changes to the upgrade policy. The grace period on updates will finish on July 1, 2010. Each purchase or update of a Valentina DB product includes 12 months of free updates including any fixes, improvements and new features.

Read the rest of this entry »

vClient becomes thread-safe

Now you should not synch vClient API calls  - vClient do it self and you are free to access and operates with vClient’s remote objects from different threads similiangly.
In particular, vStudio operates with remote connections via multiple threads  and it was a source of some glitches and unexpected errors especially with a long queries.  Now there [...]

Read the rest of this entry »

Altering ObjectPtr

ObjectPtr field contains RecID values of some “target” table. If you need to change ObjectPtr in order to point another table those values are not valid anymore – so default behavior is to nullify them.  But sometime it looks to be too strong. For instance - changing  field or link name or on-delete policy should not cause [...]

Read the rest of this entry »

Changes in Valentina for Cocoa API.

Erne have report bug http://www.valentina-db.com/bt/view.php?id=4885 in Valentina for Cocoa (V4CC).
Problem was that VField.value in ObjC implemented as pair of methods (in other Valentina ADKs, e.g. Valentina for REALbasic it is a true property of class). So if to override this pair in the sub-classes then always will be called overridden methods.
To resolve issue, we have decide to [...]

Read the rest of this entry »

NEW Function Added: hash MD5()

Ivan have implement today MD5() function, which can be used in EXPRESSION of Valentina SQL.
Bart have asked this function to be able produce UNIQUE INDEX for strings/texts bigger of 128 chars. This limit comes from fact that indexes of Valentina use pascal-like storage format for strings, e.g. 256 bytes maximum, 128 for UTF16.

Read the rest of this entry »

SPEED of DB Open for Database with 1000+ Tables: -20 sec

44 Seconds for that 1023 tables DB still not looks good for me, and I have continue search for ways to improve it. And after one more day of work time have go down to 34 sec from original 54.
And this new optimization is even better! It is also made on INDEX-level and affects absolutely [...]

Read the rest of this entry »

SPEED of DB Open for Database with 1000+ Tables: -10 sec

One developer have produce Valentina database with 1023 tables. And note us that it takes long time to open it. On my macbook it have take 54 sec.
After some profiling and optimization, time is now 44 sec.
Nice thing here is that optimization was made on INDEX-level for functions that return ArraySets. This [...]

Read the rest of this entry »