Re: Why Not MySQL?

At 06:28 PM 5/2/00 -0400, Mitch Vincent wrote:

>So, could you guys suggest some other backends I might look into? I know
>it's an odd place for me to ask but the flat truth is that I think *I* am to
>blame for my Postgres troubles and even taking all of the problems into
>account I think PG is the best damn free RDBMS out there. It's functionality
>is superior to everyone else's, it's developers are no less than amazing and
>well -- I trust you guys to give me some honest opinions.. The functionality
>I need is basically what PG has.. Transactions are a must as well as some
>sort of sequence -- stability over performance but performance is very
>important too. It also needs to run native on FreeBSD..

First, have you been having the same problems with PG 7.0? I recall that
you had it up on a test system but nothing more.

It's a pity that you've reached this point, because PG is so much better
than it was 18 months ago (and before, of course, I mention that timeframe
because that's roughly when I first investigated its suitability for
the web toolkit project) and the trajectory is definitely in the right
direction.

It's also a loss to the development effort, as people with bugs in many
ways are more useful than people who have no problems (though of course
having no bugs for users to stumble across is the best situation!)

Still, I understand the need to solve your problems today, not tomorrow.

Interbase is a possible solution. They have a pretty good reputation,
and their "super server" (threaded with connections sharing a buffer
cache) should scale well. My rough estimate is that they're at about
the place PG will be when 7.1 comes out. I don't know if they support
FreeBSD, though. Any reason you can't just put up a box with Linux?

There's an older version of Sybase available at no charge, again
only for Linux, though.

- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.