From owner-freebsd-questions@FreeBSD.ORG  Tue Jul  2 00:20:31 2013
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org
 [IPv6:2001:1900:2254:206a::19:1])
 by hub.freebsd.org (Postfix) with ESMTP id 5058C563
 for <freebsd-questions@freebsd.org>; Tue,  2 Jul 2013 00:20:31 +0000 (UTC)
 (envelope-from freebsd-questions@m.gmane.org)
Received: from plane.gmane.org (plane.gmane.org [80.91.229.3])
 by mx1.freebsd.org (Postfix) with ESMTP id 11F461ACF
 for <freebsd-questions@freebsd.org>; Tue,  2 Jul 2013 00:20:30 +0000 (UTC)
Received: from list by plane.gmane.org with local (Exim 4.69)
 (envelope-from <freebsd-questions@m.gmane.org>) id 1UtoKT-00044d-6g
 for freebsd-questions@freebsd.org; Tue, 02 Jul 2013 02:20:21 +0200
Received: from cpc3-walt15-2-0-cust148.13-2.cable.virginmedia.com
 ([86.21.186.149]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
 id 1AlnuQ-0007hv-00
 for <freebsd-questions@freebsd.org>; Tue, 02 Jul 2013 02:20:21 +0200
Received: from walterhurry by
 cpc3-walt15-2-0-cust148.13-2.cable.virginmedia.com with local (Gmexim 0.1
 (Debian)) id 1AlnuQ-0007hv-00
 for <freebsd-questions@freebsd.org>; Tue, 02 Jul 2013 02:20:21 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: freebsd-questions@freebsd.org
From: Walter Hurry <walterhurry@gmail.com>
Subject: Re: sleepycat db VS MySQL or postgres
Date: Tue, 2 Jul 2013 00:20:02 +0000 (UTC)
Lines: 26
Message-ID: <kqt6bi$3m0$1@ger.gmane.org>
References: <51D1E68B.5050508@paz.bz>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-Complaints-To: usenet@ger.gmane.org
X-Gmane-NNTP-Posting-Host: cpc3-walt15-2-0-cust148.13-2.cable.virginmedia.com
User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2)
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.14
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/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: Tue, 02 Jul 2013 00:20:31 -0000

On Mon, 01 Jul 2013 13:28:59 -0700, Jim Pazarena wrote:

> I have a rather extensive series of databases created and in use all
> with the very old sleepycat db3. I believe in the addage "don't fix what
> ain't broken", but in the case of db3, it IS broken and my db files get
> corrupted on occasion.
> 
> I could move to db5 or db6 OR MySQL, or even postgres.
> 
> I use simple primary key files, most entries are added from a CLI or
> termcap/curses screen. Some programatically. With about the same number
> of sequential dumps vs indexed random reads.
> 
> I have no experience with the c interface for postgres or mysql, but
> also, do not know how much the c interface has changed for sleepycat 5/6
> compared to the c interface for db3, which I understand quite well. So I
> am prepared for a learning curve irrespective of which platform I
> select. Records do not exceed much more than 10-20,000, with key sizes
> not much wider than 16 bytes (ipv4), 13 (mac), 32 (ipv6). And various
> smaller key sizes.
> 
> Suggestions would be very much appreciated.

If you have to make a change, I'd recommend switching to Postgres. Worth 
the effort in the long run, and Postgres is not at all difficult if you 
have experience with any RDB.