Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 2 Jul 2013 00:20:02 +0000 (UTC)
From:      Walter Hurry <walterhurry@gmail.com>
To:        freebsd-questions@freebsd.org
Subject:   Re: sleepycat db VS MySQL or postgres
Message-ID:  <kqt6bi$3m0$1@ger.gmane.org>
References:  <51D1E68B.5050508@paz.bz>

next in thread | previous in thread | raw e-mail | index | archive | help
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.




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?kqt6bi$3m0$1>