Category: Valentina Server

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

Video: How to Install Free Valentina Server and Valentina Studio on Windows

Valentina Studio, Valentina Server and WindowsHow 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

Valentina ADK for XojoGet 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

Valentina ADK for XojoHow 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 Mac OS X

Video: How to Install Free Valentina Server and Valentina Studio on Mac OS X

Valentina Studio + Valentina Server for Mac OS XHow 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

Valentina Studio Adds MS SQL Server SupportIt 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][VSQL] MAIL Command

We have add a new command for Valentina SQL.

The main goal is to be able use Valentina Server as generator of PDF and/or HTML reports and sending them by email directly from VSERVER’s stored procedure. Besides, this command can be called by Event Scheduler of VSERVER or by a database or table trigger.

vext_mail
 : __MAIL
   __FROM character_string_literal_or_var 
   __TO character_string_literal_or_var 
   __SUBJECT character_string_literal_or_var
   __BODY character_string_literal_or_var
  [__ATTACH vext_attach_list]
      __SMTP character_string_literal_or_var
      __PORT character_string_literal_or_var
     [__USER character_string_literal_or_var,
      __PASSWORD character_string_literal_or_var]
     [__SSL truth_value_or_var]

vext_attach_list
 : character_string_literal_or_var AS character_string_literal_or_var , ...

character_string_literal_or_var
 : character_string_literal
 | variable_name

uint_or_var
 : UINT
 | variable_name

truth_value_or_var
 : truth_value
 | variable_name

truth_value
 : TRUE
 | FALSE

Continue reading [NEW][VSQL] MAIL Command

[VStudio][Improve] Server Admin Panel – Log Files

5.0b60 includes significant improve of LOG files panel of Server Admin tool.

1) Now in the list of log files of a VSERVER you can see two sections. The first is named TAIL and contains only active log files. If you choose one of them, you will see tail (end) of this file with automatic refresh. This is analog of terminal tail command.

2) We have improve protocol between VSERVER and VStudio to exclude from vserver log file commands that send VStudio itself to collect information.

3) We have extend set of SNMP commands that VSERVER supports to increase performance of talk between VSERVER and VStudio. Besides, VSERVER is able proceed these commands absolutely parallel to its main job.

[NEW][VSERVER] Now has one more log file. From vreport.dll

We have found that if some report contains wrong SQL queries stored in the report itself, OR this queries have become invalid later, e.g. if some fields was renamed in the database, then no way to see these errors.

Solution is to add to VSERVER one more standard log file, into which will write info VREPORT.dll.

This log file can be set ON/OFF using same SQL commands as Warning.log file of the Valentina Kernel.

[NEW][MAC] VStudio.app and installer of VServer_x64 now are signed

OS X 10.8 has option “System Settings -> Security -> General -> Allow: MAS App Store and identified developers”  on default to be ON, so you cannot installed easy not signed applications and run installers. Note that 10.7 also can have this option enabled on some computers.

To resolve this issue, we have sign vstudio.app and vserver_x64.pkg installer.

Unfortunately we cannot easy sign other our installers (V4RB, V4REV, V4CC, … ) because we using third party installer.  So for now, for 5.0, we going to ship these installers not signed. To run them, OS X developer should in the Finder do CTRL + click on icon of installer and choose OPEN command in the contextual menu. In this case you will see the button ALLOW in the OS X security dialog. Click it, and continue as usual.

[NEW] VServer now is able to send crashlogs as VStudio

We have integrate into Valentina Server feature to send crash log like is able do Valentina Studio.

This feature will be available from 5.0b60 build.

To support this feature, we have add into INI file 3 new parameters. Read details here.

[CRASHREPORTER]
; 1 - Send crash reports.
; 0 - Don't send crash reports.
Crash_Reporter_Send=1

; Optional but very recommended to specify.
; Crash_Reporter_Owner_Name=

; Optional but very recommended to specify.
; Crash_Reporter_Owner_Email=

On default VServer keeps this feature ON.

Also will be great if user adds own name and email into INI file, so Paradigma Team will be able connect to you with more questions. If these fields are empty, then VServer will show warning on the top of LOG file.

[NEW] Localisable ENUM Type

Ladies and Gentlemen!  
The first time in the world!  🙂
Localizable Enum Type in DBMS!  

We already many months have working ENUM type in 5.0 branch of Valentina. Let me remind that ENUM type is not from SQL standard, so different DBs implement it in different way if at all implement. We have implemented it using CREATE TYPE command of SQL Standard. And we have implement ENUM in way similar to PostgreSQL, because it is the most correct: you just CREATE TYPE ENUM once and later using it in all places of your database.

mySQL, in contrast, defines ENUM as part of a particular Table, right in the CREATE TABLE command. This is not good of course, because then you cannot use this type in other tables or for variables of Stored Procedures.


CREATE TABLE sizes (
name ENUM('small', 'medium', 'large')
);

It is interesting that such mature database as Oracle do not have ENUM type.

All these existed implementations have one big problem from our point of view: such enum types contains string values of only one language. Below we will describe our solution.

Continue reading [NEW] Localisable ENUM Type

[new] VSERVER as HTTP Server + Admin based on Valentina Reports

Few years ago we have added into Valentina Server HTTP port, so it have:

  • normal port
  • SSL port
  • HTTP port
  • SNMP port
We added this HTTP port to be able do the next step — implementing admin built-in right into VServer. So user can access from any browser this admin by HTTP. We see  the following advantages of  this:
  • it is enough install server on you mac/win/linux computer and this admin will be available immediately, without need in Apache/PHP/else.
  • this admin will allow to manage vserver from platforms where not exists VStudio or iValentina. For example Android users will be able manage VServer.
Such admin of vserver we was going implement on C++ of course.
But some time ago we have got idea to use Valentina Reports for this, which could do HTTP generation from report. We have spend some time to make couple of prototypes of this idea. And while we did them, we have already made few improvements in our Reports to support this. The most important  are:

[Imp] VSERVER – now works with SNMP parallel

Valentina Server was improved to work with SNMP protocol using absolutely independent parallel thread(s). This means that on modern 2+ CPU computers, SNMP queries practically will not delay the main job of VServer.

Also  added 2 new SNMP params:

  • “1.3.6.1.2.1.1.8.0.0.0.1” – port for regular TCP connections
  • “1.3.6.1.2.1.1.8.0.0.0.2” – port for SSL TCP connections.