Re: Oracle news article

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: Shaun Thomas <sthomas(at)townnews(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Oracle news article
Date: 2001-06-13 20:28:13
Message-ID: Pine.BSO.4.10.10106131619590.19943-100000@spider.pilosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 13 Jun 2001, Shaun Thomas wrote:

> > What do you mean by connection pooling?
>
> I mean allowing an unlimited amount of connections (as much as the process
> table will allow) that are served in a round-robin basis by oracle, much
> like an httpd process. I'm tired of having to up the number of user
> connections just because we get an unprecedented surge in interest from
> people viewing all of our sites.
How about doing -N 5000? Or a equally-big
your-webserver-will-melt-down-before-the-number-is-achieved.

> > b) perl,tcl, python programming languages (damn, how much I wished Oracle
> > had perl support on backend)
>
> Yeah, if you don't mind escaping backtics every time you turn around. I
> admit, perl in oracle would be nice. But just like postgres, you can
> expand oracle with whatever you want. I just don't think anyone has
I somehow don't seem to have heard of a way to add a PL to Oracle. But
maybe I'm just not privileged enough, even if the company I work for
paid them 50k for license...:)

> gotten around to doing so. Does postgres give you the ability to define a
> library of functions so you have your own index types?
Yeah it does.

> > c) things like 'select foo from (select bar)'
> > (I'm pretty sure oracle doesn't handle that one yet)
>
> Yes it does. Subselects are subselects.
Sorry I was mistaken...Oracle does support that...
>
> > d) a decent outer join syntax (f=a(*) just doesn't cut it for complex
> > queries)
>
> Sure it does. Besides that, I like the syntax better. I hate having
> to put almost my entire blanking query in the from section because
> explicit join syntax wants to be difficult. Want your query to be an
> outer join instead? Don't rewrite the whole query and play with join
> order and possibly fsck up your application's dynamic query generator,
> just add a (*) to the field you want expanded. See? That was easy.

I agree, sometimes the syntax for postgres' join buggers me too. But I
learnt to live with it.

> But that isn't really that much of an issue. I haven't seen a single
> database other than oracle that has that nice shortcut. I've learned to
> live with it.
Yeah. in the end, most of it is 'features you are used to'. Each database
has its own set of nice things and its own set of things that annoy you to
no end...

-alex

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-06-13 20:37:07 Re: Index rebuild question
Previous Message Lamar Owen 2001-06-13 19:53:39 Re: Log files, how to rotate properly