5.5 – Paradigma Software Blog

Video: Installing Valentina ADK for Cocoa on Mac OS X

If 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.

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

Mac 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 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.

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

[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 Linux Lets 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 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

Valentina Studio 5.5 Released

Free Valentina Studio 5.5 and Valentina Studio 5.5 Pro are released! The powerful cross platform database management solution for Linux, Mac OS X and Windows includes new features for administration of database servers, improved report design features and over 42 fixes and improvements.

New Valentina Studio 5.5 Features

Use Report Designer to build reports for datasource Microsoft SQL Server
Administrator: Display Log Files from MySQL and Postgre SQL Servers
Administrator: Connect to PostGre Server with a socket file on Linux/Mac OS X
Administrator: Connect to Microsoft SQL Server with a socket file on Linux/Mac OS X and named pipe on Windows

Valentina Studio is free; Valentina Studio Pro adds SQLDIFF, Report Designer and other advanced features for $199 on Mac OS X, Windows and Linux. Report Designer lets you visually design rich, business reports, including sub-reports, graphs, charts, bar codes and more, which can be used within Valentina Studio Pro, deployed for use with applications using Valentina Reports ADK or on both the free and commercial versions of Valentina Server. Valentina Studio Pro comes with 12 months of free updates.

The updates are immediately available for download on their website at http://www.valentina-db.com.

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 Reports adds MS SQL as Datasource

It isn’t often we add a new database type, but this is one we’ve had a lot of requests for – MS SQL Server.

Today this happens! Valentina Reports starting from 5.5b15 can use MS SQL server as native datasource. Notice, that this works on all 3 OS: Windows + Mac OS X + Linux.

If you use MS SQL and you want to test it, you can download it here for all OS:
http://www.valentina-db.com/download/beta/5.5b20

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 MS SQL 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 MS SQL 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.

[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