Subject Re: [firebird-support] Firebird/ASA/Clarion
Author Martijn Tonies
Johan,

> There are more problems than hardware problems that happen in production
> environments. There are the "I had a woopsy. I shouldn't have purged all
> of those records. Can you get them back for me?"
> - The ASA answer: "Yes but it's going to cost you. I'll think of
> something."
> - The Firebird answer: "Yes, but could you help me out by going around
and
> ask everyone if it is OK to lose everything that occurred since "sometime"
> in the middle of third shift last night. Would you like me to idle our
> automotive supplier manufacturing facility and its 350 users right now for
> you? BTW, when you are finished and let me know what you want to do, tell
> GM that they're going to get an extended lunch break tomorrow at their
> Arlington Assembly plant while we airfreight parts to them."<G>

The Martijn answer:

How on earth do you get to mistakingly purge lots of records?

Do you use tools with "autocommit = true"? If so, that's pretty
dumb, isn't it?

> Currently, in my mind, Firebird cannot be positioned alongside of ASA,
since
> it would be irresponsible to deploy it in a mission-critical role, at
least
> until I was convinced of a solid logging solution.

It's also irresponsible to attemp to purge lots of records without
a way of getting them back (transactions, anyone??)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com