Valentina Release 8.3.7 Improves Chart Printing from Valentina Studio, General Updates to ValentinaDB, Valentina Server and C++ ADK

Valentina 8.3.7 ReleasedParadigma Software Valentina 8.3.7 is a general update providing fixes and improvements across most products. Continue reading Valentina Release 8.3.7 Improves Chart Printing from Valentina Studio, General Updates to ValentinaDB, Valentina Server and C++ ADK

Free Serial – Limited Time Trial for Valentina Studio PRO 6 Beta

Free Trial License of Valentina Studio Pro 6Valentina Studio Pro 6 is in beta and now you can use this serial number to trial / test the professional features of this powerful database and reports creation software. Continue reading Free Serial – Limited Time Trial for Valentina Studio PRO 6 Beta

Valentina 5.8 Released; Improvements for Kernel, PostgreSQL, Valentina Studio and Mac OS X

Valentina 5.8 ReleasedParadigma Software announces Valentina 5.8 updates are released with improvements to all products, especially on Mac OS X, PostgreSQL support, Valentina for Xojo, Valentina Studio and more. Continue reading Valentina 5.8 Released; Improvements for Kernel, PostgreSQL, Valentina Studio and Mac OS X

Buy Omegabundle for Xojo 2014 & Save on Valentina Developer Network

Omegabundle for Xojo 2014 Save 25% on VDN
Paradigma Software is offering a 25% limited time discount for Valentina Developer Network to Omegabundle for Xojo buyers. Continue reading Buy Omegabundle for Xojo 2014 & Save on Valentina Developer Network

Valentina Release 5.7.1 Improves ODBC, Upgrades SQLite Support

valentina_5.71s
Valentina Release 5.7.1 is now available. Updates to Valentina Studio and Studio Pro, Valentina C++ ADK and Valentina Server. Continue reading Valentina Release 5.7.1 Improves ODBC, Upgrades SQLite Support

More Connections for Valentina Server Sale

Valentina Server Sale
Valentina Server is both a powerful business reports server for MySQL, PostgreSQL, MS SQL Server and Valentina DB as well as its own object-relational, ultra fast database server. From now until November 1, 2014, save up to $500 on more connections capacity on this enterprise class server – that’s more connects, no added cost! Continue reading More Connections for Valentina Server Sale

v5.6 Builds Index of String/VarChar field in 10-15 times faster!

Bench Description

Prepare Steps

  • We have table T1 with field String[120] or VarChar.
  • We add 1 million records with unique values using METHOD( ‘concat( rand_string(80), RecID’ ) ) 

 So we get table with one only field, 1 millions records, values are about 80-90 chars length.

Benches

  • Build index for this field.

Continue reading v5.6 Builds Index of String/VarChar field in 10-15 times faster!

[NEW] Generating Test/Bench Data for Data Focused Apps (Part 2)

We have implement Stored Procedure ‘GenerateDataFor()’, which solves the task described in the part1 of this article.

We have added into Valentina Wiki new section, where we will keep this and future other Stored Procedures By Paradigma Software.

On this page you can find link to WIKI page, which describes GenerateDataFor() procedure and contains download link.

[NEW] SQL expression function RAND_REGEXP()

We added a new SQL function RAND_REGEXP  into v5.5.6 (available in the night_build or upcoming beta). This is very powerful function that can generate random strings of any kind, following some regular expression.

This function is useful for test and bench data generation features we will be talking more about.

Our wiki has coverage of this new function: RAND_REGEXP