We have upload 2 new video lessons about Valentina reports:

http://valentina-db.com/dokuwiki/doku.php?id=valentina:video:vspro:vspro

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:

(more…)

This means that you should be able to use V4RB 4.5 in your cocoa applications made with REALbasic.

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!

(more…)

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)!

(more…)

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.

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/

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!

(more…)

We have write own tooltips, so now they can show even syntax highlight.

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.