Latest Publications

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! (more…)

Valentina 5.6 Released; New Feature Hash Indexes

Valentina 5.6 Released

Paradigma Software announces that Valentina Release 5.6 is now available for download. If your software license began after October 16, 2013, the update is free. (more…)

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.


  • Build index for this field.


New Docs Section – Valentina DB Indexes

We have re-write from scratch section about Valentina DB Indexes. You can read it here.

Valentina Studio: Best Free SQL Database Tool

Free Valentina Studio SQL DB GUI Tool

Valentina Studio SQL GUI tool is available for free on Mac OS X, Windows and Linux. Just download free and it just works. Get FREE Valentina Studio, or upgrade to Valentina Studio Pro for only $199 to enable powerful Reports Builder, Data Transfer, SQL DIFF and so much more.

Valentina Technology Release 5.5.8 Now Available

Paradigma Software announces the immediate availability of Valentina Technology Release 5.5.8, a fixes and improvements to Valentina Studio, Valentina Server and the Valentina Kernel (underlying all Valentina products).

You can find a complete list of changes in the Release Notes on the Valentina Wiki.

Sitepoint Takes a Look at Valentina Studio, DB and Reports

Taylor Ren over at Sitepoint gives Valentina Studio, Valentina DB and Valentina Reports a look over. His report primarily touches on Valentina Studio (for Linux) but also in context with MySQL. Check it out, and feel free to comment on your experiences – Taylor is very engaging with his readers.

[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


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

There are several database tools available for generating records for table T with some random data. Usually these tools can…

  • generate the test data itself;
  • format the data for replication of some bug

Yes, both very useful.  But as speed junkies and test pilots, we also want to use this feature to

  • generate data for use in benchmarks

The difference between test and bench data, is that for benchmarking today, tomorrow and months or years later, we should generate the same records into a Table. Otherwise how we can compare results of a benchmarks as computer scientists? For tests it is okay to use random values in records, but benchmarks require exactness.

We were going to add such feature into Valentina Studio, but then we started thinking about benchmarking the Valentina engine (made in C++).  It is clear then that we need such a feature right in the engine.  So how to implement it?