I can't say which is the best, but I can supply the URLs you requested.
They all have either the JDBC driver linked or included.
PostgreSQL:
http://www.postgresql.org
Interbase:
http://www.interbase.com
mySQL:
http://www.mysql.com
Sybase:
http://www.sybase.com
--On Friday, October 27, 2000 2:24 PM -0700 "Duffey, Kevin"
<[EMAIL PROTECTED]> wrote:
> So of all the databases that are "free" to use, which one is best for
> load? I know of PostgreSQL, mySQL, Interbase, and Sybase 11.x. Can anyone
> maybe fill in the URLs where we can get these databases, as well as JDBC
> 2.0 compliant drivers for them?
>
> Thanks.
>
>
>> -----Original Message-----
>> From: Colin Jacobs [mailto:[EMAIL PROTECTED]]
>> Sent: Friday, October 27, 2000 1:56 PM
>> To: Orion-Interest
>> Subject: RE: Anyone using Interbase in production?
>>
>>
>> We built our prototype on InterBase. Mostly on NT but some
>> linux also.
>>
>> I had pretty mixed experiences with it. As a developer doing
>> JDBC stuff, I
>> didn't have many complaints. On paper, at least, IB6 looks
>> like a pretty
>> full-featured open-source DB. But our DB guy complained about
>> IB a lot (the
>> tools and features) - although, I think a lot of it was him
>> having been
>> "spoilt" by Oracle.
>>
>> One caveat: The IB JDBC drivers ("InterClient") connect to a
>> process called
>> interserver, then then connects to ibserver. I don't think
>> interserver is
>> very robust. I know that on NT, the interserver.exe processes
>> gradually
>> accumulate, until you start getting problems connecting. We
>> have to reboot
>> pretty regularly.
>>
>> Be advised the JDBC drivers don't support SQL dialect 3 yet. Also, the
>> relationship between the IB open source community and Inprise
>> isn't a great
>> one. I think this is slowing down the development of the JDBC
>> 2.0 drivers.
>> Plus, I believe there was a major fork in the IB source
>> within the last
>> couple of months.
>>
>> Luckily our real product is built on Oracle. I'd be a bit
>> hesitant to use IB
>> in production under any significant load. With hindsight I
>> would have looked
>> into PostgreSQL a bit more thoroughly.
>>
>> Colin
>>
>> -----Original Message-----
>> From: Jim Archer [mailto:[EMAIL PROTECTED]]
>> Sent: Friday, October 27, 2000 10:26 AM
>> To: Orion-Interest
>> Cc: Jonas Larsson
>> Subject: Anyone using Interbase in production?
>>
>>
>> Does anyone here have any experience with Interbase in a production
>> environment? We are trying to decide which database to deploy in
>> production. Since we are a very low budget operation, we are
>> looking at
>> Open Source, but somehow missed this one.
>>
>> Our most important requirements are stability, transaction
>> support, a solid
>> JDBC driver (for use with an EJB server) and online backup capability.
>>
>> Any experiences people can offer would be appreciated,
>> especially in a
>> Linux environment.
>>
>> Thanks!
>>
>> Jim
>>
>>
>>
>>
>>
>> --On Friday, October 27, 2000 11:46 AM +0200 Jonas Larsson
>> <[EMAIL PROTECTED]> wrote:
>>
>> >
>> > You could always use Interbase which now is opensource..
>> > http://www.interbase.com
>> >
>> >
>> > ----- Original Message -----
>> > From: Laufer, Michael
>> > To: Orion-Interest
>> > Sent: Friday, October 27, 2000 10:41 AM
>> > Subject: MYSQL, Orion, EJB and transactions ??
>> >
>> >
>> > Hi there,
>> >
>> > I know that the question has been discussed here before,
>> but I'm still a
>> > little confused about using MYSQL together with Orion.
>> > I've just downloaded mysql (version 3.23.22 beta) and the manual
>> > announces that mysql is now supporting transactions. If I
>> understood it
>> > correctly, that would mean, that it should be possible to
>> use mysql with
>> > entity beans. Am I right ?? What's confusing to me is the
>> fact, that I
>> > only find news in mailing-list, that mysql is not supporting
>> > transactions.
>> >
>> > So I don't really now, if I can use mysql for entity beans.
>> > If not, which database would you suggest ??
>> > It should work on NT and not be the most expensive one as I
>> use it 'only'
>> > for writing my Master's Thesis.
>> >
>> > Thanks in advance,
>> >
>> > Michel
>> >
>>
>>
>>
>>
