Web-based Application in Revolution

[Andre Garzia]

Ruslan,

usually when building Revolution web aps, people use apache cgi interface,
so for each web request, apache will launch an instance of the revolution
engine. If you have two concurrent requests, you will have two instances
running. Each with their own V4REV external loaded. What happens if they
both try to access the same Valentina database.

SQLite have built in methods for locking the file if they are opened by more
than one application at the same time, so all transactions are atomic. You
still have the problem of one instance overwritting the changes of the other
instances, but you can guarantee that both accessess will happen and will go
thru without file corruption.

What I am to say is that using SQLite you can build a minimal web
application if you're clever enough to build a locking mechanism to prevent
overwritting other users changes. My SQLite will guarantee the transactions
or in other words, the multiple client access to the file.

Now, since I really like Valentina, can we do something similar with V4REV,
can more than one application access the same database file without using
Valentina Server?

Cheers

andre
Ruslan

On 10/5/07, Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
>
> On 5/10/07 9:14 PM, "Andre Garzia" <andre at andregarzia.com> wrote:
>
> Hi Andre,
>
> > Ruslan,
> > but what happens if two engine instances launched by apache try to
> access
> > the same database? Assuming the user is using V4REV external and not
> > Valentina Server.
>
> I think nothing good :-)
>
> Do you mean " launched by apache" == starting from Valentina.Init() ?
> This is bad idea I think.
>
> --
> 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]
>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>