From owner-freebsd-questions@FreeBSD.ORG Tue Jul 2 02:05:26 2013 Return-Path: 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 A8856EA3 for ; Tue, 2 Jul 2013 02:05:26 +0000 (UTC) (envelope-from m.e.sanliturk@gmail.com) Received: from mail-vc0-x233.google.com (mail-vc0-x233.google.com [IPv6:2607:f8b0:400c:c03::233]) by mx1.freebsd.org (Postfix) with ESMTP id 6DB7E1DA9 for ; Tue, 2 Jul 2013 02:05:26 +0000 (UTC) Received: by mail-vc0-f179.google.com with SMTP id hz11so2445823vcb.10 for ; Mon, 01 Jul 2013 19:05:26 -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=tJHYefXS5AMVvH57D1xqF1dJWBUPLepN/F0t1KhxAlY=; b=V7fqiDi9xreFx7zXdKpN/RdybDYIjnbF8LTWDht5CTTACOkAfRO2z3nIpidLtclaFm +xaO8t1tLT2WQo2j8Kg8we6HwmgNhupgHljBGAZH5W+1XJQ2VtuwE+mkpL2QqTTIX0zq FmGOwUpKzN1RYIFLdCGto237jmKpcdK5OSbHIXCGBa2/2ZCbZubDx64OW/wRYkgxAmJw miQctIoMcx117DbAosW/CbWV3suu7/dfuTK5I6JjnDCv4EV6F1oODIrPfU6tM/l4Kflv QG6dVmJJ8zFdwW0fcmm5awRMahQqSbWGJwVFD8dUZpbLvbgXn6kNh8MVs8hyLdvjCw85 wKXA== MIME-Version: 1.0 X-Received: by 10.221.5.71 with SMTP id of7mr10680068vcb.39.1372730725988; Mon, 01 Jul 2013 19:05:25 -0700 (PDT) Received: by 10.59.12.232 with HTTP; Mon, 1 Jul 2013 19:05:25 -0700 (PDT) In-Reply-To: <51D1E68B.5050508@paz.bz> References: <51D1E68B.5050508@paz.bz> Date: Mon, 1 Jul 2013 22:05:25 -0400 Message-ID: Subject: Re: sleepycat db VS MySQL or postgres From: Mehmet Erol Sanliturk To: Jim Pazarena Content-Type: text/plain; charset=UTF-8 X-Content-Filtered-By: Mailman/MimeDel 2.1.14 Cc: FreeBSD Questions Mailing List 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: Tue, 02 Jul 2013 02:05:26 -0000 On Mon, Jul 1, 2013 at 4:28 PM, 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. > -- > Jim Pazarena fquest@paz.bz > The following page may be useful : http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems MySQL is dropped from some Linux distributions due to its restrictions and replaced by MariaDB : http://en.wikipedia.org/wiki/MariaDB Dropping of MySQL is continuing among Linux distributions for new releases . The PostgreSQL would be best choice : http://en.wikipedia.org/wiki/PostgreSQL I am not using any one of them , but my PhD ( in 1996 ) subject is "A Multimedia Information Management System" . Thank you very much . Mehmet Erol Sanlituk