Latest Publications

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?
(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…)