What so special about PostgreSQL and other RDBMS?

[NorwoodThree]

Re: What so special about PostgreSQL and other RDBMS?

> This isn't about the subject of this thread, but it got me curious.[color=blue]
>
> Are you suggesting that outsourcing to India means reduction in quality.
> I am asking this because what is believed is the other way, that is,
> outsourcing to India means better quality work. There was an article
> in eweek "time to debunk myth that indian programmers are better".
> I will post the link later. Don't have it now.[/color]

I am going to go out on a limb and say worse quality work because I
can't understand them when I talk to them on the phone.

[Ken]

Re: What so special about PostgreSQL and other RDBMS?

"Sarah Tanembaum" <sarah.tanembau m@yahoo.com> wrote in message news:<c78jfi$vo mj$1@ID-205437.news.uni-berlin.de>...[color=blue]
> Beside its an opensource and supported by community, what's the fundamental
> differences between PostgreSQL and those high-price commercial database (and
> some are bloated such as Oracle) from software giant such as Microsoft SQL
> Server, Oracle, and Sybase?
>
> Is PostgreSQL reliable enough to be used for high-end commercial
> application? Thanks[/color]

Depends.

How much is your data worth?
How much will downtime cost?
How much will a commercial database cost?

PostgreSQL is a really nice little database, and has a lot going for
it:
- easy to install, admin, and use
- easy to port databases between PostgreSQL and other commercial
databases
- very high-quality implementation

However, on the other side of the coin:
- missing many of the high-end features needed in large data volumes
like partitioning, clustering, parallelism, materialized views, query
rewrite, etc.
- missing many of the high-availabity features
- missing lots of the various stuff: replication, etc

Personally, when I've got a lot of value in my database I typically
opt for a commercial offering. But there are those exceptional
situations - like:
- no budget
- just want to prototype
- it's read-only data and you can create a dozen small databases
- the data isn't super-valuable
Then in these cases - PostgreSQL is a nice little product, and I
wouldn't hesitate to use it. Much better, btw than its primary
competitor - MySQL with its limited, non-ansi sql, and amazing
exception handling irregularities.


kenfar

[Joel Garry]

Re: What so special about PostgreSQL and other RDBMS?

"rkusenet" <rkusenet@sympa tico.ca> wrote in message news:<c78quu$13 6n3$1@ID-75254.news.uni-berlin.de>...[color=blue]
> "Daniel Morgan" <damorgan@x.was hington.edu> wrote
>[color=green][color=darkred]
> > > Beside its an opensource and supported by community, what's the fundamental
> > > differences between PostgreSQL and those high-price commercial database (and
> > > some are bloated such as Oracle) from software giant such as Microsoft SQL
> > > Server, Oracle, and Sybase?
> > >
> > > Is PostgreSQL reliable enough to be used for high-end commercial
> > > application? Thanks[/color]
> >
> > PostgreSQL is highly overrated and not suitable for any environment
> > where little things like crash recovery and security are a priority.[/color]
>
> Why postgresSQL?? Why don't u say that all RDBMS except Oracle is
> highly overrated. This way u don't have to fear about ur job for any
> foreseeable future.
>
> Your attitude reminds me of the attitude Americans had towards outsourcing
> some 4/5 yrs ago. At that time all they could do is to arrogantly dismiss
> outsourcing as unsustainable model. We all know what happened to them today.
>
> I see lot of similarity between movement towards outsourcing few yrs
> ago and now movement towards open source database. US companies, after
> achieving cost savings thru outsourcing will next turn their attention
> to money guzzling enterprise software like RDBMS. How long do you think
> it will take them to realize that most of them don't deserve the price
> tag they pay.
>
> See ya after 3 yrs in Bangalore :-)[/color]

There is a backlash against outsourcing now. Some parts are
sustainable and some are not. Anyone can do bad java code. For
administrative purposes, the database (well, not really, it's the
managers) requires someone local. And the definition of
administration is broadening.

I had come to this conclusion myself, then saw a talk on
administration futures by Guy Harrison where he said it, then a
solicited commercial email from Mike Ault where he said it, too.

Deserving has nothing to do with it. It's the useful application that
gets the money.

And the drudge development that can be outsourced? Bangalore is
losing it to China and Eastern Europe.

jg
--
@home.com is bogus.

http://www.time.com/time/archive/preview/from_search/0,10987,1101040419-610085,00.html