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
> >
>
>
>
>
