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. _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"
