Projects vs Databases

[Ruslan Zasukhin]

On 2/1/09 2:28 AM, "Lynn Fredricks" <lfredricks at proactive-intl.com> wrote:

Hi Lynn,

> Hi Ruslan,
> 
> I think we need to get information on the site about projects. Projects can
> contain reports, but can they also contain databases, or do they just
> reference external databases?

This is some facts about VProject


Valentina Project File

* Starting with 4.0 Valentina Studio Pro is able create and manage Valentina
Project Files ( *.vsp )

* This file actually is Valentina database with special tables to keep
required information.

* Valentina Project is similar in use to Valentina Database

SQL:
    CREATE DATABASE                 CREATE PROJECT
    DROP DATABASE                   DROP PROJECT
    REGISTER DATABASE               REGISTER PROJECT
    UNREGISTER DATABASE             UNREGISTER PROJECT
    SHOW DATABASES                  SHOW PROJECTS
    GRANT                           GRANT

So we have extend Valentina SQL to support work with projects


* Since Valentina Project IS a database, this allow us manage it UNDER
Valentina Server.

    This means that you can create/open Vproject under remote vserver, and
develop it from Valentina Studio Pro. Yes this means that it is possible
multi-user development of project! Although we need yet improve things in
this are.


* API

Into Valentina ADKs was added new classes and methods to work with Projects
and its contents, reports in particular.

    class VProject
    class VReport


* When Vstudio PRO works with Vporject locally, on each SAVE it crate its
copy as .bak


* Valentina Project can contains:
    
    * Datasources -- this is reference on external Valentina db
    * Named SQL Queries -- SQL query with a give name.
    * Reports      
    * Pictures
       
* You can create inside of project hierarchy of folders to organize items of
project.

* 



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]