SEO

I recently stumbled upon the free open source PostgresSQL
(http://www.postgresql.com).

In my opinion, this is one of the most advanced, FREE/open source RBM
systems I have ever come across. It is practically easy to migrate
Oracle databases to this since it supports _practically_ everything
Oracle does. But it is also FREE. No expensive licensing costs. If you
have one cpu, you pay nothing! If you have 10 cpus, you still pay
absolutely nothing! What a novel idea!

In my opinion, if you are bent over a barrel and paying out of the wazoo
and wasting being irresponsible with company and shareholder money, read on:

Be advised that there are some here that like being bent over a barrel
and like to take it in the rears and pay through the nose for overpriced
commercial software. They will denigrate and attack this message like
they attacked early Christians. Be brave and read on:

First of all, even though it is open source, there is commercial support
for those who need it, but if you are already an Oracle DBA.. it should
be very easy.

Http://www.Enterprisedb.com will offer commercial support:

Enterprise compatibility

EnterpriseDB works in the manner your company expects of its database
management software, with world-class 24/7 support, a deep portfolio of
professional services and training, and assured reliability,
scalability, and flexibility.

Oracle® compatibility

EnterpriseDB has taken the world’s most advanced open source database -
PostgreSQL – and enhanced it so that most applications written for
Oracle will run on EnterpriseDB without modification, protecting
investments in applications. Meanwhile, EnterpriseDB also maintains full
compatibility with native PostgreSQL.

Budget compatibility

EnterpriseDB’s pricing represents a significant drop in the price point
at which enterprises can fulfill their relational database software
needs. And linear pricing ensures that price is always proportional to
your needs; no more exponential license cost growth.



Tablespaces:
http://www.postgresql.org/docs/8.0/s...blespaces.html

Support for a ton of server-side languages:
http://www.postgresql.org/docs/8.0/s...ogramming.html

PlSQL support:
http://www.postgresql.org/docs/8.0/static/plpgsql.html

Truely object oriented with inheritence:
http://www.postgresql.org/docs/8.0/s...heritance.html

More Data types:
http://www.postgresql.org/docs/8.0/i.../datatype.html

BASF case study:
http://www.postgresql.org/files/abou...gresqlv1.2.pdf

Enlightened and Free wrote:
> I recently stumbled upon the free open source PostgresSQL
> (http://www.postgresql.com).
>

[bulk of shameless marketing hype snipped]

This is SPAM, purely and simply put, as it belongs in
c.d.o.marketplace, NOT c.d.o.server.

Apologise to the group for your transgression and put this post where
it belongs.


David Fitzjarrell

Enlightened and Free wrote:
> I recently stumbled upon the free open source PostgresSQL
> (http://www.postgresql.com).

What rock have you been hiding under. We have all been waiting
for some brilliant person to guide us to a piece of garbage
with limited capabilities so we could all save money and be in
violation of Sarbanes-Oxley, HIPAA, FACTA, and other legal and
organizational security, stability, and scalability requirements.

How absolutely stupid of all of those CIO's at those companies
like Boeing, Bank of America, Amazon.com, etc. spending money
when they could run their businesses on free database software.

Just one quick question: In which issue of CIO or the Wall Street
Journal can I find your biography?
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

In <11ilrtae8vpoodd@news.supernews.com> Enlightened and Free <eaf@woohooo.planetearth> writes:
>In my opinion, this is one of the most advanced, FREE/open source RBM
>systems I have ever come across. It is practically easy to migrate
>Oracle databases to this since it supports _practically_ everything
>Oracle does. But it is also FREE. No expensive licensing costs. If you
>have one cpu, you pay nothing! If you have 10 cpus, you still pay
>absolutely nothing! What a novel idea!

And it is practically impossible to support high availability, BLOB support
practically sucks due to a lack of backup capability, and it is practically
impossible to cluster them for scalability.

andy

--
Andrew Finkenstadt (http://www.finkenstadt.com/andy/)

There is a great deal more to the cost of RDBMS than the purchase price of
the software.

Sheesh, here we go again. I wonder if this is the same turkey that wasted
our time about six months ago.

There is no doubt in my mind that open source databases have a valid place
in life. Very similar to open source operating systems. As always, use
the right tool for the job - and if the job can truly be fulfilled by
MySQL or PostgresQL, so be it.

Unfortunately many forget the long term cost, including cost to develop
replacements for the stuff that comes with Oracle (RMAN, EM, Locator,
interMedia, and the list goes on). It ain't just the data types.

Evaluate intelligently, not religiously. <sigh />

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***

On Fri, 16 Sep 2005 12:15:38 -0400, Enlightened and Free wrote:

> I recently stumbled upon the free open source PostgresSQL
> (http://www.postgresql.com).

So did I. There is even a great book by Korry Douglas.

>
> In my opinion, this is one of the most advanced, FREE/open source RBM
> systems I have ever come across.

Much better then MySQL, I'll have to agree. The thing I especially like is
the fact that it is using Perl as an internal scripting language, instead
of PL/SQL.

> It is practically easy to migrate
> Oracle databases to this since it supports _practically_ everything
> Oracle does. But it is also FREE. No expensive licensing costs. If you
> have one cpu, you pay nothing! If you have 10 cpus, you still pay
> absolutely nothing! What a novel idea!

The problem is that when you need support and a patch ASAP, there is
nobody to write it. It's a good thing for non-critical databases, but
if you want something really stable and survivable, you're left with
commercial product. In addition to that PostgreSQL is missing many
availability options like standby databases or RAC. There are five (5)
published books about Pg and a gazillion or more published books about
Oracle, some of them really great (Jonathan's "Practical Oracle 8i",
Cary's "Optimizing Oracle for Performance", Tom Kyte's "Efficient Oracle
by Design" and Dan Tow's "Tuning SQL"). I sometimes swear and curse at
Oracle for their behavior but I stick to it. At least their WW support is
there when I need somebody to yell at. Practically, I've never been given
an offer to become a Pg DBA with the equal or larger salary as what I'm
getting as an Oracle DBA. That settles it. I love good public domain
software but I need to pay the bills. Postgres is still a wooden gun and
you have to shout "bang, bang" if you want to scare somebody. Oracle is
the real thing.
In addition to that, this seems to be a group about the Oracle RDBMS, at
least judging by its name. Your post, therefore, qualifies as spam.

--
http://www.mgogala.com

DA Morgan <damorgan@psoug.org> wrote:


> What rock have you been hiding under. We have all been waiting
> for some brilliant person to guide us to a piece of garbage
> with limited capabilities so we could all save money and be in
> violation of Sarbanes-Oxley, HIPAA, FACTA, and other legal and
> organizational security, stability, and scalability requirements.


I'm a wee bit confused by this bit about conforming to Sarbanes-Oxley,
HIPAA and FACTA.


Surely there are a myriad organisations out there that have to have
good accountancy practices, and/or protect medical data and/or process
credit cards, correct?


Not all of these organisations use Oracle - they might use Sybase, MS
SQL Server or IBM DB2 or Informix - i.e. not Oracle.


What I would like to know is what is it, particularly, about Oracle
that makes it compliant with these rules and regulations? I'm sure
that an Oracle server has as much potential to be sloppily
administered as a PostgreSQL one.


Are you basically saying that Oracle makes compliance *_easier_* than
other solutions, but is far from the only solution - basically any db
properly administered could do the job?



Paul...



--

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2,

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;

When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.

Furthermore, as a courtesy to those who spend
time analysing and attempting to help, please
do not top post.

Paul wrote:
>
> DA Morgan <damorgan@psoug.org> wrote:
>
>>What rock have you been hiding under. We have all been waiting
>>for some brilliant person to guide us to a piece of garbage
>>with limited capabilities so we could all save money and be in
>>violation of Sarbanes-Oxley, HIPAA, FACTA, and other legal and
>>organizational security, stability, and scalability requirements.
>
> I'm a wee bit confused by this bit about conforming to Sarbanes-Oxley,
> HIPAA and FACTA.

So are most of us that have to comply with them. ;-)

> Surely there are a myriad organisations out there that have to have
> good accountancy practices, and/or protect medical data and/or process
> credit cards, correct?

Correct.

> Not all of these organisations use Oracle - they might use Sybase, MS
> SQL Server or IBM DB2 or Informix - i.e. not Oracle.

They might. And they might have no problem being compliant with these
laws if they use the correct versions of the correct products.

> What I would like to know is what is it, particularly, about Oracle
> that makes it compliant with these rules and regulations? I'm sure
> that an Oracle server has as much potential to be sloppily
> administered as a PostgreSQL one.

The ability to audit all inserts, updates, and deletes no matter
who does them, no matter the interface, no matter the authority,
even if done by expert DBAs and operating system administrators.
That capability does not exist in ANY open source RDBMS of which
I am aware.

> Are you basically saying that Oracle makes compliance *_easier_* than
> other solutions, but is far from the only solution - basically any db
> properly administered could do the job?
>
> Paul...

Easier ... I'd say yes. There is no question someone can make
anything compliant if they start writing Assembly code: Possibly
even C. The secret is to have the capability built into the database
at the kernel level and to have it in such a way that the auditors
will sign off on it.

Compliance with the law is only as good as the willingness of an
Accenture, Price-Waterhouse, or KPMG to put ink on paper on a financial
statement. If they won't do it you might as well start cleaning out
your desk if in the US and a public company or in Japan and engaged
in banking (for example).
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

Omlet's anyone?