Hey Scott,
Interbase 6 is pretty nice in my opinion. Its SQL 92 compliant (if that
means anything), its completely free and is now open-source, has a type IV
jdbc driver, and it has a VERY small foot-print. It runs on most platforms I
believe, and thus far its pretty darn fast. However, I have not been able to
successfully create a database in it. I keep getting some stupid error when
I try to create a database and I can't find any information on it. I'll have
to post to the Interbase site probably..or maybe there is a newer version. I
wish there was some more detailed info on how to completely set up
Interbase. I can however connect via my java app and get connections out. I
just can't seem to create tables and what not. Anyways..I worked with
Interbase 4 and it was pretty fast, so I am sure 6 is better in many ways
(that is not always true..but I hope it is).
> -----Original Message-----
> From: Scott Stirling [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 11, 2000 3:25 PM
> To: Orion-Interest
> Subject: RE: HARDWARE FOR J2EE apps
>
>
> Why would you use mySQL over Postgresl? They're both free,
> but Postgresql has a
> JDBC driver that's XA-compliant. Also, mySQL is known to
> blow away your whole
> database if it has a bad crash, whereas Postgresql is better
> at persisting data
> through a bad crash.
>
> How does Interbase 6 compare to Postgresql? Is it free?
>
> Scott Stirling
> West Newton, MA
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of
> Duffey, Kevin
> > Sent: Wednesday, October 11, 2000 4:01 PM
> > To: Orion-Interest
> > Subject: RE: HARDWARE FOR J2EE apps
> >
> >
> > Hi,
> >
> > > sounds very nice but what about the database? how do you
> cluster that
> > > without spending an arm and a leg? our experience is, that
> > > it's not that
> > > hard to set up clustered web services with static pages and
> > > servlets but
> > > the really expensive part is, when you want that high
> > > availability for your
> > > database. it doesn't buy you much if you have highly
> > > available ejbs when
> > > the database server goes down. many people use clustered
> > > apache/jserv on
> > > linux and cheap pc-hardware for high volume transactional
> > > websites but have
> > > a large enterprise sun running oracle in the back. anyone out
> > > there running
> > > a configuration with orion that includes a database with
> > > failover that
> > > doesn't blow up the budget too much (compared to other
> components)?
> >
> > Well, to start off with there is mySQL and the one I like
> the most is
> > Interbase 6..a free powerful RDBMS. However, as far as
> clustering them..I
> > don't quite know the best way. I would think a
> load-balancer or a switch or
> > something, would be required. Nobody ever said it was
> cheap! ;) I used to
> > think $25,000 could easily set up a website from front to
> back, software,
> > hardware, etc..but not even close these days. If you are
> just starting out,
> > I would use Orion for front-end and ejb-logic tiers in a clustered
> > environment (for developing/testing), with a single server
> running mySQL or
> > Interbase for the database. Once you get some funding and
> move beyond the
> > concept phase, you should put a sizeable chunk to invest in
> co-locating your
> > site and doing the full load-balancing setup. I would
> estimate a cheap setup
> > with 2 front-end web/servlet servers failed over, 2 ejb
> servers, and a
> > database cluster will still run around $100,000, to co-lo
> it..which is
> > probably the best thing to do to make sure its up 24/7.
> >
> >
>
>
