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…
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.
We have made two new x64 products on request of Valentina developers:
* VSDK x64 WIN
* VServer Embedded x64 Linux
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.
We introduce OS X Preference Pane “ValentinaServers”.
Continue reading [NEW] ValentinaServers OS X Preference Pane
Today one of user have asked if Valentina supports partial index. Answer is YES OF COURSE, you can easy create a partial index using Table Methods.
We introduce a new utility method Valentina.CopyCursorToNewTable(), which is able to save you hundreds of lines of advanced code in your ADK-based applications. This method added into major Valentina ADKs.
You can read detailed description of this new method here.
Index fragmentation can cause problems with query performance. Indexes therefore need to be occasionally rebuilt. Read the full article in the “Valentina Performance Guide” document.
PROBLEM IS:
Up to now (v4.7), a VServer on start searches for INI file in the own directory. Algorithm expects that only one INI file exists in the folder. And if few INI files present, then the first by alphabet is used.
Continue reading VServer now uses the name of executable as primary instead of ini file
There is a new property – LogFilesLocation for both server and local.
It defines a folder where the logs should be placed in.
Default folder is “./vlogs”
Now you should not synch vClient API calls – vClient do it self and you are free to access and operates with vClient’s remote objects from different threads similiangly.
In particular, vStudio operates with remote connections via multiple threads and it was a source of some glitches and unexpected errors especially with a long queries. Now there are no more errors like “EOF reached…” or “Broken packet received…” which were result of incorrect thread synch.
We have added to SQL Editor of Valentina Studio great new feature: now you can get much more rich output from an SQL command. And this output is separated into 4 tab panels at bottom of Editor.
Continue reading NEW Tab-Panels in SQL Editor to Display Logs/Output/Warnings/Tune