V4RB V.1 -> V.2 ? Security in valentina

[Ruslan Zasukhin]

On 5/17/04 1:03 PM, "olivier" <vidal_olivier at yahoo.fr> wrote:

>> For now hundreds developers live with this and no big problems.
>> MySQL have live without transactions 20 years.
> 
> It is true, Ruslan...
> 
> But maybe that it will be replaced these next years by postgresSQL for
> these reasons?

Never. 

Postgre is academic project IMHO, it do not have strong support companies,
Only hobbyists. No marketing and so on.

It is not true that Postgre have speed up.
Today only one developer have test Postgre and say it is MUCH MUCH slower of
mySQL. I have ask him inform about this RB list.

And od not forget, mySQL 4.x already have transactions.

 
>> You should do flush after each modification.
>> After flush() any crash is not scary.
>> 
>> You can consider flush as commit()

> It is what I made. In every modification or addition in the base, I use
> flush at once.

> But that does not resolve the problem if the computer falls at the time
> of the flush.

Oliver, a lots of Valentina developers distribute products to thousands of
clients. And corruptions are very rare. Some developers have ZERO issues
with this. You can check Valentina list archive for 5 years.

So as say my father:
    solve problems when they really come to you.
    but do not fill your brain by POSSIBLE problems.
:-)

> The data base risks strongly to be corrupted.
> 
> Without journaling, there is no means immediate and clean to get back
> the data base without corruption.

In theory yes. 

But reality not so bad.

Of course, I will NOT recommend now use Valentina for banking or ecommerce.
Because this areas really require 100% of sure.

On the other hand, one of our developer, which work in bank
say that they use Sybase, and even such mature db sometimes cannot recover
after system failure.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------