Latest Publications

[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 have 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 string of any kind, following to some regular expression. We going to use this function for Test/Bench Data Generation in the near future.

* WIKI about 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 do implement it?
(more…)

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

Valentina Technology Release 5.5.3 Available

Valentina Technology Release 5.5.3Paradigma Software announces the immediate availability of Valentina Technology Release 5.5.3, following on the 5.5.2 release.  5.5.3 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.2 release also included:

  • 11 new instructional videos available on the Paradigma Software Youtube Channel
  • Documentation of the VProject.MakeNewReport() methods to have a new optional parameter bind array
  • New wiki information on the separately announced Valentina for Java
  • Added support of mySQL and postgreSQL datasources via socket file in Valentina Studio

Video: Installing Valentina ADK for Cocoa on Mac OS X

Installing Valentina ADK for CocoaIf you are developing native Cocoa applications with Apple Xcode you will want to check out how to install and get started with Valentina ADK. You can build ultra fast database applications with Valentina DB ADK for Cocoa, and embed visually stunning reports in your applications with Valentina Reports ADK for Cocoa.

This video covers the following topics:

 

 

  • Downloading the single ADK archive for both products
  • Installing the single archive from the installer image
  • Linking to the Valentina framework in Apple Xcode
  • Importing the main Valentina header
  • Adding a new button to initiate / shut down Valentina Client
  • Adding code to connect to a remote Valentina Server
  • Adding some SELECT code to display some records

If you are developing fast database applications for Mac OS X, you can use Valentina Reports ADK for Cocoa to display and format your data better than any other commercial reports framework.

Videos: Install and Get Started with Valentina for PHP ADK

Valentina ADK for PHPValentina DB ADK for PHP and Valentina Reports ADK for PHP are available on all three operating systems – Linux, Mac OS X and Windows. You can work with these locally, as well as utilize PHP to build powerful web applications.

Build and serve rich, visual reports with grids, graphs, images and more – directly in a browser or generate documents, such as XML enriched PDF. Serve reports from all major databases. It works with MS SQL Server, Oracle, MySQL, Postgre and more.

(more…)