[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

 

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

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.

Valentina 5.5.2 Released: Introducing Valentina for Java

Technology release 5.5.2 is now available for all Valentina products, including Valentina Server, Valentina Studio and all Valentina DB and Valentina Report ADKs. Even though this is a  X.X.X release, Paradigma Software announces the availability of Valentina ADK for Java! Now you can build Java applications that can utilize the ultra fast Valentina database with Valentina DB ADK, and build rich, visual reports with Valentina Reports ADK for Java. Find Valentina 5.5.2 Release notes on the Paradigma Software wiki.

Valentina 5.5.1 Released: Updates for Studio, Server, DB & Reports ADKs

Paradigma Software announces the release of Valentina 5.5.1, an update to the recently released Valentina 5.5. This release includes multiple improvements and fixes for reported issues with Valentina 5.5.

You’ll find specific improvements to the Valentina DB engine, Valentina Server, Valentina Studio, Valentina PHP, Valentina for LiveCode and the ODBC driver for Valentina ADK. If you are a current licensee you should download and update your existing products.

See the complete release notes on the Valentina documentation wiki.

Video: How to Download and Install Valentina ADK for LiveCode on MacOS X

Mac OS X Development with DB, Reports and LiveCodeMac OS X developers can develop and deploy LiveCode applications, and Paradigma Software has both Valentina Reports ADK for LiveCode and Valentina DB ADK for LiveCode available to build powerful business applications with LiveCode. Check out how to get started with this combination of tools.

Valentina Reports ADK lets you embed cross-platform reports in your business applications with support for grids, tables, charts, graphs and more; you aren’t limited to only Valentina DB though when it comes to reports. You can use Valentina Reports with MS SQL Server, Oracle, MySQL, Postgre and more.

Continue reading Video: How to Download and Install Valentina ADK for LiveCode on MacOS X

Video: How to Download and Install Valentina ADK for LiveCode on Windows

LiveCode Database & Reports DevelopmentLiveCode developers can develop and deploy on Windows, and Paradigma Software has both Valentina Reports ADK for LiveCode and Valentina DB ADK for LiveCode available to build powerful business applications with LiveCode. Check out how to get started with this combination of tools.

Valentina Reports ADK lets you embed cross-platform reports in your business applications with support for grids, tables, charts, graphs and more; you aren’t limited to only Valentina DB though when it comes to reports. You can use Valentina Reports with MS SQL Server, Oracle, MySQL, Postgre and more.

Continue reading Video: How to Download and Install Valentina ADK for LiveCode on Windows

Video: How to Download and Install Valentina ADK for LiveCode on Linux

LiveCode, Linux and ValentinaLiveCode is an excellent tool for developing on Linux, and Paradigma Software has both Valentina Reports ADK for LiveCode and Valentina DB ADK for LiveCode available to build powerful business  applications with LiveCode. Check out how to get started with this combination of tools.

Valentina Reports ADK lets you embed cross-platform reports in your business applications with support for grids, tables, charts, graphs and more; you aren’t limited to only Valentina DB though when it comes to reports. You can use Valentina Reports with MS SQL Server, Oracle, MySQL, Postgre and more.

Continue reading Video: How to Download and Install Valentina ADK for LiveCode on Linux

[NEW] Valentina Reports adds Oracle as Datasource

We almost forgot when talking about MS SQL Server support that Valentina Reports can also use  Oracle Database Server as a datasource. You can do this on all three supported operating systems with Valentina Reports ADK 5.5, with a little help from Valentina Studio Pro. And you don’t need Java or expensive solutions like Crystal Reports, Actuate or Oracle’s BI Publisher.

Consider also that there’s a Valentina Reports ADK for every major development environment – .net, Objective-C, C++, even COM, and RAD tools like LiveCode, Xojo or even…unbelievably…Adobe Director!

Right now you can…

  • Download Valentina Studio to do the following steps…
  • Make a new Valentina Project (from File Menu) on your desktop
  • Make a new datasource — define to your Oracle server
  • Make a new Report – can be with simple query as SELECT * FROM T, do click, click, click in the wizard to get default layout of fields.
  • Click PREVIEW button on the left to see report with data from your Oracle Server.

To start use this new datasource in your application you need just to specify a corresponded string that describes datasource connection string. See details.

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

Valentina ADK for Xojo for LinuxLets take a look at how to install and set up Valentina ADKs for Xojo on the Linux platform. 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  download files include the components for 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; you aren’t limited to only Valentina DB though when it comes to reports. You can use Valentina Reports with MS SQL Server, Oracle, MySQL, Postgre and more.

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

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

Valentina ADK for Xojo for WindowsHow 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