From owner-freebsd-questions@FreeBSD.ORG Mon Jul 1 20:51:41 2013 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) by hub.freebsd.org (Postfix) with ESMTP id 9DC1AE06 for ; Mon, 1 Jul 2013 20:51:41 +0000 (UTC) (envelope-from fquest@paz.bz) Received: from mail.qcislands.net (mail.qcislands.net [207.34.147.83]) by mx1.freebsd.org (Postfix) with ESMTP id 83A1B1138 for ; Mon, 1 Jul 2013 20:51:41 +0000 (UTC) Received: from 100-236-53-209.qcislands.net ([209.53.236.100] helo=[192.168.1.6]) by mail.qcislands.net with esmtp (Exim 4.80) (envelope-from ) id 1Utkij-000ANu-6G; Mon, 01 Jul 2013 13:29:09 -0700 Message-ID: <51D1E68B.5050508@paz.bz> Date: Mon, 01 Jul 2013 13:28:59 -0700 From: Jim Pazarena User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130620 Thunderbird/17.0.7 MIME-Version: 1.0 To: freebsd-questions@freebsd.org Subject: sleepycat db VS MySQL or postgres Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-local_scan: locally submitted (100) X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 01 Jul 2013 20:51:41 -0000 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. -- Jim Pazarena fquest@paz.bz