SLAG Advice solicitation needed:

[Ben Duncan]

<LAFF>, yeah, so is Appgen recovery - What a PITA. In Appgen there is ALWAYS
a 50/50 chance that you have lost at least some of your data when a file
goes corrupt. It becomes 100% when the (l)user continues to ignore the
warning signs. And being proprietary, there ain't no tools!

VBISAM and Xbase maintain their index file separate from their data
files, so you always have at least the data portion intact. Back in to OLD days,
I never saw a ISAM data side or a FoxPro data side go bad unless you had some sort
hardware failure, in which case, regardless, your screwed and it is "backups" here
we come ...

Now, I am not leaning towards a ZERO maintenance system, just one that that does
not require hiring a DBA, something that can be setup with a plethora of utilities
that the average - Intelligent - end user can do on their own. The rest will need
to have maintenance contracts <grin> .....

And, I am open to any and all suggestions and solutions, databases,etc...

Net Llama! wrote:
> On Tue, 4 Jan 2005, Ben Duncan wrote:
> 
> 

> 
> 
> If you're looking for a near-zero maintanence solution, then you
> definitely don't want a SQL DB.  Sleepycat (and its cousins) are basically
> zero maintanence, unless of course there is some kind of corruption, at
> which point you're pretty well screwed, cause recovery is non-trivial, and
> usually quite painful & time consuming.
> 
> I think this comes down to risk analysis.  Either you decide that you want
> to have a solution that is easy to recover or a solution that is easy to
> maintain.  I don't think you can get both with the options you listed
> (which are really the only FOSS that i'm aware of for this task).
> 
> 

-- 
Ben Duncan   - VersAccounting Software LLC 336 Elton Road  Jackson MS, 39212
"Never attribute to malice, that which can be adequately explained by stupidity"
        - Hanlon's Razor