Valentina 5.7 Delivers Access Control for Valentina Server

Valentina 5.7 Released

Valentina Technology Release 5.7 products, including Valentina Server 5.7 and Valentina Studio Pro 5.7 are now available for download from the Paradigma Software website. Continue reading Valentina 5.7 Delivers Access Control for Valentina Server

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

 

[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)

Valentina Technology Release 5.5.5 Now Available

Valentina 5.5.5Paradigma Software announces the immediate availability of Valentina Technology Release 5.5.5, 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.

Valentina Studio is a free database admin and development tool available for Mac OS X, Windows and Linux. Valentina Server, available in a free 5 connection edition and higher capacity commercial versions, provides a complete, ultra-fast business reporting platform for all major databases including MySQL, Oracle, SQL Server, PostgreSQL and more; it also includes the object-relational Valentina DB server. Valentina DB ADK lets developers embed the ultra fast Valentina DB database in standalone applications; Valentina Reports ADK embeds the complete Valentina Reports business reporting engine in applications. Both ADKs start at $199 and include royalty free deployment.

Valentina Technology Release 5.5.4 Now Available

Valentina 5.5.4 ReleaseParadigma Software announces the immediate availability of Valentina Technology Release 5.5.4, includes multiple fixes and improvements to Valentina Studio, Valentina Server and the Valentina Kernel (underlying all Valentina products).

Valentina Studio is a free database admin and development tool available for Mac OS X, Windows and Linux. Valentina Server, available in a free 5 connection edition and higher capacity commercial versions, provides a complete, ultra-fast business reporting platform for all major databases including MySQL, Oracle, SQL Server, PostgreSQL and more; it also includes the object-relational Valentina DB server. Valentina DB ADK lets developers embed the ultra fast Valentina DB database in standalone applications; Valentina Reports ADK embeds the complete Valentina Reports business reporting engine in applications. Both ADKs start at $199 and include royalty free deployment.

The 5.5.4 release also includes:

  • Improved compatibility for importing WordPress databases into Valentina Studio
  • Database Comments included when exporting from PostgreSQL 9.1
  • Interactively disabling triggers in PostgreSQL  using the Property Inspector in Valentina Studio

 

Videos: Installing Valentina ADK for Java

Valentina Reports for JavaNow that Java developers can embed Valentina DB and Valentina Reports into their applications as well as interface with the powerful Valentina Server. To get started with Valentina ADK for Java products, watch these instructions videos for:

These videos cover installing Valentina ADK for Java on their respective operating systems in preparation for working with Valentina Reports and Valentina database.

  • Downloading the single ADK archive for both products
  • Installing the single archive from the installer image
  • Linking to the Valentina framework with NetBeans
  • Defining the path the JNI Valentina Library
  • Setting up a basic UI to work with Valentina ADK
  • Adding code to connect to a remote Valentina Server
  • Adding some SELECT code to display some records

 

Valentina Reports for Java Now Available

Valentina Reports for JavaParadigma Software, the fast database and reports technology solution provider, announces the immediate availability of Valentina Reports ADK for Java 5.5.3, a platform for building business data visualization solutions.

Valentina Reports ADK for Java allows developers to generate and present visually rich reports in their applications. It also allows generation of reports from Valentina Server, the ultra-fast business intelligence server that incorporates report generation from SQL Server, MySQL, Oracle, PostgreSQL and other data sources. Valentina Server also incorporates a full object-relational, columnar database engine, Valentina DB.

Valentina Reports supports a visual toolbox including barcodes, charts, graphs, quick shapes, live html, sub-reports, page breaks and other visual elements that can be assembled into complete reports. Programmatically export your reports as XML enriched PDF documents, web pages, text or graphics. Reports are built as projects from queries within Valentina Studio Pro, the visual SQL administration tool available on Mac OS X, Linux and Windows. The same report project can be deployed transparently with over 30 development platforms. Continue reading Valentina Reports for Java Now Available