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.
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.
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.
We have redesign a little preference panel “Valentina Servers”.
Removed controls about auto-refresh. Now panel refreshes the state each 2 seconds.
Instead of 3 buttons start/stop/restart we have now a single button that changes state.
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.
Few years ago we have added into Valentina Server HTTP port, so it have:
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:
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.
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.
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.
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.
Got questions about the free Valentina Server /5 product? We have a growing set of frequently asked questions that are being added to the Paradigma Software wiki, that are specific FAQ for Valentina Server /5. Our support system has recently been flooded with questions – this is the place to look first.
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.
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.
Continue reading VCLIENT now Caches ServerSide Cursors. Speed Increased a lots…