Category: Valentina Server

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

[NEW] SHOW [VSERVER] LOG command

We have added a new SQL command that works with VServer only to show tail of VServer.log file. (5.0b30)

TODO Valentina Studio now have a special panel where user can easy see this log using new command.

All together this simplify a lots work with remote VServer, especially if you do not have SSH access to its file system.

[NEW] VServer + VStudio now can show NOT registered dbs

We have extend SHOW DATABASES command to show also not registered databases located in the VServer/databases folder. To implement this VServer now is able iterate this folder to see files with .vdb extension.

Valentina Studio now take this in attention and show such not registered databases with a special icon. Also you get contextual menu with command “Register database”.

Refresh button of VStudio is able issue SHOW DATABASE command to check folder for new files if needed.

VClient and VServer now can analyze network

After some benches we have discover that it is not a good idea to use ZIP compression of data if VServer is on localhost or on fast LAN.

To resolve this we have specify 3 possible steps and made the first one without changes in API. As result, now VClient and VServer automatically can do raw analyze of network and define if to use ZIP.

Future we will add even special VClient function VConnection.Tune(), which your app can call on start, and later each 30 min for example to measure and analyze network state more accurately.

[NEW] VClient now allows to control timeout using VConnection.ResponseTimeout

In 4.x version we did have VDatabase.ResponseTimeout for all ADKs, which in fact was not working. Now we have resolve this issue in the VClient.dll and move this property into VConnection class.

Problem was, that if VClient was in the state Read or Write  some command into socket, then on sudden loose of network connection VClient app did hang forever. We have redesign work with sockets for VClient.dll in the same way as it was in Valentina Server.

Valentina Office Server /5 Now Free

Valentina Office Server is a combined database and enterprise ready reports server from Beaverton, Oregon-based Paradigma Software. Almost any individual or organization can now get a free copy of it -actually, up to three copies – one for each operating system: Linux, Windows and Mac OS X.

With all the FOSS databases around, why Valentina? For one, you get an awesome reports server, and I have yet to come across a FOSS reports system to beat it. On the database end, Valentina is an extremely fast and modern columnar database. It can do so many things you won’t find in FOSS products.

The response to this release has been phenomenal. As people write in Ill be posting additional posts clarifying the program.

VCLIENT now Caches ServerSide Cursors. Speed Increased a lots…

Valentina CLIENT library provides not only read-only client-side cursor as do e.g. mySQL or PostgreSQL, but server-side cursor also, which can be in NoLocks, ReadOnly and ReadWrite modes.

While client-side cursor loads all result records into client computer RAM at single step, a server-side cursor loads one record only. This allows to use server-side cursors for huge SELECT results. But … if to make on such cursor a GUI grid table to display records, speed of display was not best, because each time GUI asks for other record to draw, server-side cursor have jump to VServer to load it.

Now we have cache for VCLIENT server-side cursors.

  • Speed increased dramatically.
  • VServer gets less job to do.
  • Network traffic goes down

Continue reading VCLIENT now Caches ServerSide Cursors. Speed Increased a lots…

Valentina Reports get ODBC-datasource!

Valentina Reports now support ODBC datasource!

This is great, because now Valentina Reports can work with data stored practically in any database format (MS Access, MS SQL, Oracle, Postgre SQL, mySQL, … ) and even XML.

In Valentina Studio improved datasource dialog to support ODBC.

In a Valentina ADK code, you should specify connection string in the VProject.MakeNewReport( inDataSource ), as the following: odbc://dsn=access,user=name,pass=123

Will be available in the 4.9b5 build or newer.

10 Hottest Features of Valentina Office Server

As a part of the Omegabundle 2011 for REAL Studio campaign, I have published the article 10 Hottest Features of Valentina Office Server – which just like it sounds, lists the top 10 features I think are particularly of interest to businesses which need a high performance database and business reports server at the center of their business. This covers a number of advantages you gain based on the underlying technology of Valentina DB, plus also the inclusion of the business reports engine that is also included with Valentina Office Server.