We have upload 2 new video lessons about Valentina reports:
http://valentina-db.com/dokuwiki/doku.php?id=valentina:video:vspro:vspro
Category: English
Posts in English
Working with big vDatabases
Valentina is a perfect choice to work with a big data. It employs vertical storage approach. It means – each column has own virtual file to be stored in. Most of db vendors use a horizontal storage – it stores a table data in record-by-record manner.
There are some vertical storage advantages:
V4RB.rbx plugin now contains COCOA version.
This means that you should be able to use V4RB 4.5 in your cocoa applications made with REALbasic.
VCursor Now Can UpdateRecord() of JOINs !!!
It is well known that Valentina offers to developer a very reach ADK API (about 1000 methods) in contrast to poor API of most dbs (e.g. near to 25 in mySQL).
One of nice feature is the ability to use VCursor class methods to MODIFY records of ServerSide & ReadWrite cursor. But for years we did have limit here: cursor can be ReadWrite only for single table SELECT. In the release 4.5 we remove this limitation! Now you can do UpdateRecord() and DropRecord() for cursors built over INNER JOIN of N tables!
Continue reading VCursor Now Can UpdateRecord() of JOINs !!!
Valentina Server 64-bit.
We are happy to introduce, in the release 4.5, the result of our 8 months efforts – Valentina Server 64 bit for 3 platforms (win, mac, linux)!
Deprecated Convert_1_2() feature.
Also we are dropping Convert_1_2() feature of Valentina engine from 2.0 version to allow developers convert existed v1 databases. If somebody yet need convert v1 database to 2.0 format, he should use at first v4.3 for this task.
This function is removed from all Valentina ADKs and VStudio, DLL of VDK V1 engine is removed from the vcomponents folder.
V4RB/V4MD Carbon deprecated in v4.5
We have decide to deprecated these two Carbon products in v4.5, which we have developed yet with help of CodeWarrior.
I think for REALbasic developers, this will not a problem, because few years REALbasic is a cocoa application itself, and works with xcode-made plugins.
For Director users, this means that v4.5 of V4MD mac, will not work with Director10, only with D11 and D11.5. If you still use D10, you can use v4.3 of V4MD that can be found here: http://valentina-db.com/download/prev_releases/
Valentina Reports Free in December 2009
Paradigma Software Inc announces a special holiday offer for professional database application developers. All sales of new or upgrades through Paradigma Software of ValentinaADK or Valentina Developer Network includes the associated Valentina Reports module free – up to a $1500 savings on Valentina Developer Network!
SqlEditor: Improved tooltips
We have write own tooltips, so now they can show even syntax highlight.
SqlEditor: work with history of queries is more simple and powerful.
Now SqlEditor shows history of queries not in the menu, but in the same panel of editor. This give us:
* visibility of few lines of query (and tooltip if query has more of 5 lines);
* syntax highlight;
* filter for fast search in the history;
* choice between history of the current database only or full.
SqlEditor Improvements
SqlEditor becomes better. Added
* highlight of line with error;
* logs panel works better;
* tooltips that show info about Schema Object;
* code-folding, great when you type procedure or trigger;
* autocompletion menu has icons;
* if TAB panel is not visible, then buttons to execute queries and such, are shown in the sub-panel, so we can still use them.
SqlEditor: Object Navigation
Now you can do Cmd/Ctrl + Click on the name of any Schema object in the text of query, to open new Tab-panel (or activate existed) with Schema Editor, where this object will be selected.
This feature is available from any place of VStudio, where SQL text is shown!
A Valuable Adobe Director Resource DirectorForums.com to Close
Long time community supporter Martin Schaefer announced in a public letter that he was going to shut down or transform directorforums.com. Directorforums.com and Directorforums.de provides a valuable news and community source for developers that use Adobe Director to produce standalone and web / shockwave based applications. He goes into some greater detail about his background in Director development. Continue reading A Valuable Adobe Director Resource DirectorForums.com to Close
SNMP and Valentina Server
There is a new feature in Valentina Server – SNMP agent.
Currently we support only get() and get_next() SNMP requests for the following oids:
sysDescr(“1.3.6.1.2.1.1.1.0” )
sysUpTime(“1.3.6.1.2.1.1.3.0” )
Not much info but it makes a possibility to monitor vServer over SNMP.
For now, SNMP facilities are available only for Windows.
You should specify SNMP port in the server ini-file (default port is 161, 0 means turn off SNMP agent):
…
[SNMP]
Port_SNMP=161; SNMP port to listen by VServer.
; 0 – do not use a SNMP port.
…
REALbasic, Valentina and 2010
So what is REALbasic support going to be like for Valentina in 2010? Continue reading REALbasic, Valentina and 2010