Re: Challenging SQL Query Problem. Can you solve it?

DA Morgan wrote:
>
> >>Please read Chapter 1 of Tom Kyte's "Expert Oracle Database Architecture:
> >>9i and 10g Programming Techniques and Solutions" for a good discussion on
> >>the reality of your database indeependence requirement.
> >>
> >>Your desire to stay database independent is simply going to cause your
> >>customers to increase their cost. Database independence means not taking
> >>advantage of the vendor's capability, which in turn means more CPU
> >>cycles, and THAT means more CPU and therefore more licenses to do the
> >>same job.
> >
> >
> > Not unless you use PostgreSQL.
>
> You mean not if they don't want support.

I believe there are a couple of companies that do provide support for Postgres. Plus you can ask free of charge on the mailing lists which include the developers.

> You mean not if they don't want robust backup and recovery ability.

PostgreSQL does have Point in Time recovery. And it does have slony1 for replication. It supports nested transactions as well.

> You mean not if they don't care about US Federal law (SarbOx, FACTA, HIPAA)
> You mean not if they don't care about European law (Basel II)

I'm not a lawyer so I can't comment on this. But does US laws require Oracle if you are a business? I can understand in the medical profession that may be a requirement, but other instances? What about MS SQL SERVER? Isn't it based off of the same codebase of Postgres? Is SQL SERVER FACTA, HIPAA SarbOx compliant?

> You mean if they don't need to store and retrieve TB

>From the postgresql website: http://www.postgresql.org/about/

Maximum Database Size	Unlimited
Maximum Table Size	32 TB
Maximum Row Size	1.6 TB
Maximum Field Size	1 GB
Maximum Rows per Table	Unlimited
Maximum Columns per Table	250 - 1600 depending on column types
Maximum Indexes per Table	Unlimited

> You mean if they don't need messaging

You got me there, I don't

> You mean if they don't need instrumentation for tuning

I think postgres does have EXPLAIN.

> You mean if they don't need advanced security and auditing

 Since 8.1 postgresql has Roles instead of users and groups. As for logging, you can set the logging level at startup, plus postgres has WAL you can view and roll back to any point in time. As for security, Postgres supports SSL, etc.

> Those people. Do they really BUY things?

Probably not :-). Isn't that why Solaris 10 is free now? But at least they know a bit more about SQL than the mySQL people. :-) Received on Fri Dec 23 2005 - 18:32:23 CET