[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] VReports few improvements

Thanks to Matthew Gardner, we have made few improvements in Valentina Reports engine:

  • Header section fixed to work with data from cursor.
  • Expression control that produce text, now respect FORMAT field, such as currency or date. For this engine try convert string into a number, and on success apply formatting.
  • System Color Dialog is used now for all places.

[NEW] VStudio + iValentina now sync bookmarks using iCloud

We have made first step to support iCloud technology from Apple.

Now Valentina Studio for MAC OS X (and only one, which is download from MacAppStore) will have iCloud prefs pane, that allows you to specify what to synch in the iCloud. For now this is bookmarks and resent connections to db servers.

Continue reading [NEW] VStudio + iValentina now sync bookmarks using iCloud

[Imp] VSQL: SHOW commands now can accept variables instead of e.g. db_name

To support our own development of admin task for vserver, we have extend SHOW commands to accept variables instead of db_name, tbl_name and so on.

When variable starts with @ or @@ symbols, engine easy can recognize this. But you can also use a local variable of Stored Procedure. Algorithm at first checks if IDENT is the name of a local variable. If no,  then consider this as db_name or tbl_name according to grammar of a SHOW command.

Example:

Some_Stored_Procedure_Text()
…
set CurrentDbName = ‘accounting’
execute ‘SHOW EVENTS FROM CurrentDbName’
…
end

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

[NEW] Youtube channel for Valentina (DB + REPORTS)

We have setup channel on Youtube for Valentina related movies http://www.youtube.com/user/paradigmasoftware

First of all here was moved existed video-tutorials about Valentina reports, and was added some new about Valentina Studio. We going now extend this channel a lots in the nearest time.

Into Valentina WIKI for v5 we have installed also plugin to show movies from youtube. So we will integrate movies into docs about Valentina products.

Valentina Studio gets redesigned Server Admin tool

This tool now can work with Valentina Server, PostgreSQL and mySQL.

This is the central place where you can:

  • manage databases: create, drop; register/unregister, …
  • manage valentina projects: create/drop, register/unregister, …
  • manage users, groups and roles
  • view server-side log files
  • view and edit ini-file parameters of a server

[NEW] Valentina Studio – Postgre plugin – now can dump/load using pg_dump engine

We was able embed into Valentina Studio plugin the pg_dump engine to dump a database into different formats of text files  and load these text files back into database.

You can access these dump/load commands from the File menu of Valentina Studio application or from the contextual menu of a database object.

Continue reading [NEW] Valentina Studio – Postgre plugin – now can dump/load using pg_dump engine

VStudio now can show warnings from operation

Valentina Engine far ago produce warnings in the ‘Warning.log’ for Import of Text operation. For example, record is not added if the primary key is not unique.

This warning.log is created near to application. And if this is a remote Valentina Server then user of Valentina Studio cannot easy see that warnings. Now this is improved. In Valentina engine, in Valentina Server and in Valentina Studio. Snapshot below demonstrate this.

VStudio – QueryBuilder make up and improvements

In 5.0b30 we have return back QueryBulder after few months.

* new – it works now for all supported engines: Valentina, PostgreSQL, mySQL, SQLite.

* new – we have simplify interface removing few visible areas, replacing them on TAB panels. Note that you can switch by main panels using such shortcuts as cmd+1 and cmd+2.

* new – you can specify expressions to be used in the SELECT clause.

* note that you can specify inner and left/right/full outer joins using right-click on a link on the diagram.

* note that if you will click SQL panel and then continue develop diagramm then you will see live changes in the generated SQL.