5.5 – Page 2 – Paradigma Software Blog

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.

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