Ruslan Zasukhin

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.

[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?
Continue reading [NEW] Generating Test/Bench Data for Data Focused Apps (Part 1)

Video: How to Download and Install Valentina ADK for Xojo/REALbasic on Windows

Valentina ADK for Xojo for Windows How about a step-by-step walk thru of installing Valentina ADK for Xojo / REALbasic ? With this step-by-step video walk thru, you will learn how to do this, as well as set up your Xojo development environment for database development with the most advanced database for Xojo development and work with remote databases on Valentina Server.

Valentina ADK for Xojo / REALbasic download files include both Valentina DB ADK and Valentina Reports ADK. Valentina DB ADK for Xojo lets you embed the ultra-fast, royalty free Valentina Database into your applications. Valentina Reports ADK lets you embed cross-platform reports in your business applications with support for grids, tables, charts, graphs and more.

Continue reading Video: How to Download and Install Valentina ADK for Xojo/REALbasic on Windows

Video: How to Install Free Valentina Server and Valentina Studio on Windows

Valentina Studio, Valentina Server and Windows How about a step-by-step walk thru of installing the FREE Valentina Server and FREE Valentina Studio on Windows? With this step-by-step video walk thru, you will learn how to do this, as well as set up a client-server test system on your local computer.

Valentina Server incorporates both the ultra-fast Valentina DB database system and Valentina Reports Server. Valentina Reports supports all major databases on the market, though in this tutorial we will be focusing on the basics of setting up a Valentina database.

Continue reading Video: How to Install Free Valentina Server and Valentina Studio on Windows

Video: How to Generate Valentina Reports from a Xojo Web Application

Get started with a step-by-step walk thru on how to set up and generate reports using Valentina Reports and the Xojo web application.

Valentina Reports ADK for Xojo lets you embed a complete reports system into your business applications made with Xojo; however more powerful than this is generating reports from Valentina Server, the ultra-fast solution from Paradigma Software, and then displaying them from a Xojo Web application. Continue reading Video: How to Generate Valentina Reports from a Xojo Web Application

Video: How to Download and Install Valentina ADK for Xojo/REALbasic on Mac OS X

How about a step-by-step walk thru of installing Valentina ADK for Xojo / REALbasic ? With this step-by-step video walk thru, you will learn how to do this, as well as set up your Xojo development environment for database development with the most advanced database for Xojo development and work with remote databases on Valentina Server.

Video: How to Install Free Valentina Server and Valentina Studio on Mac OS X

How about a step-by-step walk thru of installing the FREE Valentina Server and FREE Valentina Studio on Mac OS X? With this step-by-step video walk thru, you will learn how to do this, as well as set up a client-server test system on your local computer.

Continue reading Video: How to Install Free Valentina Server and Valentina Studio on Mac OS X

[NEW] Valentina DB engine – SELECT … FOR JSON

We made the first step in the direction to popular JSON format.

Valentina SQL already did have extentions

SELECT … FOR XML
SELECT … FOR REPORT

Now we adding one more: SELECT … FOR JSON.

We have upload 5.5b21 build where this feature is introduced. It works in same way as FOR XML. In the result you get cursor with a single record and a single TEXT field.

Example:

SQL query ‘SELECT * FROM tblCustomer FOR JSON’ returns

{
      "name": "tblCustomer",
      "fields": ["fldFirstName","fldLastName","fldCountry","fldPhone"],
      "records": [
           ["Peter","Thomas","Germany","111111"],
           ["Brian","Hill","USA","222222"],
           ["Simon","Smith","Italy","333333"],
           ["Chris","Maxwell","France","444444"],
           ["Greg","Silver","France","555555"],
           ["Jerry","Lucas","USA","666666"],
           ["Mark","Lord","Canada","777777"]
      ]
}

[NEW] Valentina Studio – Server Admin – now shows logs of mySQL and PostgreSQL

We have added ability to show log files of mySQL and PostgreSQL in Server Admin of Valentina Studio 5.5.

mySQL have two kinds of logs: as files and stored in the sys tables. File logs can be accessed by SSH connection, sys table logs can be access by SQL commands of mySQL. You can work with both these kinds of mySQL logs now.

postgreSQL also have two kinds of logs: in default format and in CSV format. Native SQL commands of postgreSQL can work with the first format. CSV format logs can be views only via SSH connections. You can work with both these kinds of postgreSQL logs now.

Note that for SSH vstudio opens one more connection to load that log files as from FTP.

See pictures:

Continue reading [NEW] Valentina Studio – Server Admin – now shows logs of mySQL and PostgreSQL

Paradigma Labs Benchmarking Valentina Report Server: 4-12 Million Reports a Day on a MacMini/i7

Just how many reports can you generate in a day with Valentina Server? Paradigma Labs ran a simple benchmark test of Valentina Server working as Report Server.

Although you can utilize Valentina Server as a powerful Valentina DB based database server, you can also utilize it as a server solution for generating business reports – as html, PDF documents or images – with grids, barcodes, charts, graphs, labels and other visual elements that make up any business report. Using Valentina Server as your Report Server does not limit you to Valentina DB as a data source – you can freely use it with MySQL (including Maria DB) and PostgreSQL.

We tested generation of both big (900+ pages) and small (1-page) PDF based reports, using the current Valentina Server 5.4.2 as well as a version of Valentina Server currently in beta that maximizes multiple cores of your CPU.

The results were more than impressive.

4-12 million 1-page reports generated in a day on MacMini/i7

Read details on Valentina WIKI.