From owner-freebsd-questions@FreeBSD.ORG  Mon Mar 24 23:48:21 2008
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 97872106564A
	for <freebsd-questions@freebsd.org>;
	Mon, 24 Mar 2008 23:48:21 +0000 (UTC)
	(envelope-from wojtek@wojtek.tensor.gdynia.pl)
Received: from wojtek.tensor.gdynia.pl (wojtek.tensor.gdynia.pl
	[IPv6:2001:4070:101:2::1])
	by mx1.freebsd.org (Postfix) with ESMTP id 458698FC27
	for <freebsd-questions@freebsd.org>;
	Mon, 24 Mar 2008 23:48:04 +0000 (UTC)
	(envelope-from wojtek@wojtek.tensor.gdynia.pl)
Received: from wojtek.tensor.gdynia.pl (localhost [IPv6:::1])
	by wojtek.tensor.gdynia.pl (8.14.2/8.13.8) with ESMTP id m2ONlqDw003575;
	Tue, 25 Mar 2008 00:47:52 +0100 (CET)
	(envelope-from wojtek@wojtek.tensor.gdynia.pl)
Received: from localhost (wojtek@localhost)
	by wojtek.tensor.gdynia.pl (8.14.2/8.13.8/Submit) with ESMTP id
	m2ONj9Dm003567; Tue, 25 Mar 2008 00:47:48 +0100 (CET)
	(envelope-from wojtek@wojtek.tensor.gdynia.pl)
Date: Tue, 25 Mar 2008 00:45:09 +0100 (CET)
From: Wojciech Puchar <wojtek@wojtek.tensor.gdynia.pl>
To: "Brian A. Seklecki" <bseklecki@collaborativefusion.com>
In-Reply-To: <1206396758.18298.73.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com>
Message-ID: <20080325003434.Q3516@wojtek.tensor.gdynia.pl>
References: <007801c88dd6$2100d6c0$f800000a@chameleon>
	<1206396758.18298.73.camel@soundwave.ws.pitbpa0.priv.collaborativefusion.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
Cc: freebsd-questions@freebsd.org
Subject: Re: fault tolerance with FreeBSD for old DOS app
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 24 Mar 2008 23:48:21 -0000

>> I want advice for old DOS app on Windows PC, that I need to make on 2 PC-s
>> fault tolerant. Any advice for working solution on FreeBSD?
>
> Yep...rewrite the database in SQL with a PHP front end.  Import the data
> from the old system.  Use a Radware/F5 Load Balancer for the web and
> Slony-I for the database replication.
>
> Welcome to 2008.
and have all "modern apps" problems and 1000 times higher hardware 
requirements to do the same. my CA-Clipper apps running under DOS 
are still in use after 15 years, because it work well. there is no
better language for such things, there are CA-Clipper ports for
unix, but not very good.

clip (ports/databases/clip) is an exception, except it's 
screen handling is quite a mess.

but will a little of work it's good, i ported few program to clip.
clip is 5-20 times faster on the same machine than CA-Clipper :)

for now - i don't know anything better to write database-processing 
programs than this. no "database engines" and other strange things -
fortunately.

it uses "ancient" technology - simply stores tables as flat files, and 
indexes as other files.

there is quite a big chance this old DOS program was written in 
CA-Clipper.