From owner-freebsd-questions@FreeBSD.ORG Mon Jul 1 20:59:00 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 877BAF32 for ; Mon, 1 Jul 2013 20:59:00 +0000 (UTC) (envelope-from kevin.wilcox@gmail.com) Received: from mail-vc0-x22b.google.com (mail-vc0-x22b.google.com [IPv6:2607:f8b0:400c:c03::22b]) by mx1.freebsd.org (Postfix) with ESMTP id 4F3F21181 for ; Mon, 1 Jul 2013 20:59:00 +0000 (UTC) Received: by mail-vc0-f171.google.com with SMTP id gd11so2299946vcb.2 for ; Mon, 01 Jul 2013 13:58:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=27xrmoI8c+63gb03VHlO1Ylht+4XuuaVWsOV6mDE59M=; b=oWOGyb31l0uboJpcCOcNkYZmWB12mFrSqIbd+p33gc+jg2bFRMCzE5/E+sRLj+xe1Y 2PBIQ86fFlqvwVdF2Z4Y/NLjGTMlQRPHisOdSe6Nu8dGt7uQUMbs3IdbR89grQNVVUP2 mloGKoIr6wNTHm7A9/IGq85WKPJVFRblBBM9pG6Mf3GnU0GDNRg5ldNtXJHhWaouMVlb AdgRavclb8qKkviYZieQKgboJGEk0IF8xTnei5etZBZZ39m0OuG6SwwokygpndNYyKso UGE9eVlOnDMxHCbxhDwdcrotZDhGjpe0bJkbO7DqKoUnTq64CUj5rSqjVancIZzrUHpW zgIQ== MIME-Version: 1.0 X-Received: by 10.220.90.71 with SMTP id h7mr10288706vcm.16.1372712339812; Mon, 01 Jul 2013 13:58:59 -0700 (PDT) Received: by 10.58.135.230 with HTTP; Mon, 1 Jul 2013 13:58:59 -0700 (PDT) In-Reply-To: <51D1E68B.5050508@paz.bz> References: <51D1E68B.5050508@paz.bz> Date: Mon, 1 Jul 2013 16:58:59 -0400 Message-ID: Subject: Re: sleepycat db VS MySQL or postgres From: Kevin Wilcox To: Jim Pazarena Content-Type: text/plain; charset=UTF-8 Cc: freebsd-questions@freebsd.org 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:59:00 -0000 On 1 July 2013 16:28, Jim Pazarena wrote: > I could move to db5 or db6 OR MySQL, or even postgres. > 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 - ultimately I'd recommend deciding which of the three you WANT to learn and then use it. I know nothing about db* but I use both MySQL and PostGreSQL on a regular basis. I like them both. I prefer the licence used by PostGreSQL, I prefer the PostGreSQL replication but I use whichever suits my needs. Some people are fanatical about one or the other, I say pick whichever you're more interested in and learn how to use it. kmw