Valentina DB, Valentina Reports for Revolution 4.7 Released

Lynn Fredricks lfredricks at proactive-intl.com
Tue Jul 20 13:03:40 EDT 2010


Hi Bob,

> I seem to remember that you were working on a feature that 
> would allow Valentina Reports to work with MySQL databases. 
> Is this in this release? 

Right now we are working on a feature that will allow more databases to work
with various Valentina frameworks. This would appear first in Valentina
Studio (and reports). The first we will offer is SQLite, but others will
follow.

We've made it relatively easy to port MySQL/PHP solutions to Valentina
because you can do a simple search-replace on the text to change your calls.

We've made significant investments in development tools that don't always
need to be tethered to our own DB, and doing this will make it a lot easier
anyway to port to Valentina DB. A lot of folks who are relatively new to
database tech don't always see how advanced Valentina is or the advantages.
It is a lot easier to simply let them use engines they like at first and
once they dig in, they see just how really powerful a Valentina DB based
solution is compared to what they have.

It sort of reminds me of the "storage" revolutions we've had in the past -
Floppies -> CDROM -> DVDROM -> Viable Online Storage. Wow, how can you
possibly use more the 1.44 MB? Likewise, what possible advantage is there
for shrinking hours or minutes into seconds on database queries?

Ive had several conversations with people recently (esp Rev users) who
haven't quite understood the Valentina DB value proposition. Valentina DB is
a columnar database. As a columnar database, it has two huge advantages over
traditional relational databases -

- The way joins work is quite different. With Vlinks, the overhead is
microscopic with Valentina. We've seen relational dbs lose a significant
amount of weight when ported over as a result

- The 'columnar' way is really, really fast - blazingly fast. Sometimes its
just twice as fast. Sometimes it is 100+ times as fast. The more complex
your queries are, and the more records you have, the more you notice this.
That's why we have customers in the financial services market who have set
up dumps from Oracle into Valentina for use with their custom apps.

On top of this, we have the Paradigma way - which is to support very broad
connectivity:

- cross platform dbs that work on Mac, Windows and Linux
- connect from many app platforms - Rev yes, but also the likes of a pure
Cocoa solution, .net, COM, Vclient for iPhone and lots, lots more
- support a more advanced, modern API as well as standards like SQL

The component system has two parts -

A Client
The DB Runtime (local storage)

Clients simply interface with DB Runtimes, acting as a sort of gateway for
communication. So while there isn't a local storage DB Runtime on iPhone,
for example, you can query and "pull" data from Valentina databases into
your iPhone app. The same sort of system applies to the "client" for PHP on
the server, or the "client" that is included with Valentina for Revolution.

Best regards,

Lynn Fredricks
President
Paradigma Software
http://www.paradigmasoft.com

Valentina SQL Server: The Ultra-fast, Royalty Free Database Server 




More information about the use-livecode mailing list