Re: Real novice question: Roles

On 18/11/11 18:26, "Jean-Yves F. Barbier" <12ukwn(at)gmail(dot)com> wrote:

>> Coming from MySQL to PostgreSQL, I find the pgsql documentation somewhat
>> obfuscated.
>
> Not really; this is because MySQL lacks many things (opposed to Pg AND SQL
> standards), so you can think about it as the difference between a (very)
> small car and a (very) large one: there are much more equipments in the
> larger one, thus the manual is... larger.
>
> You should begin reading docs with .../index.html, not .../bookindex.html

From the knowledge I've garnered over the years reading about PostgreSQL
I've always thought of it as in the upper league of RDBS capable of
supplying very large instances of support to major frameworks. That said, on
a computer, I hadn't clapped eyes on its methods 'til about 22:30 UTC last
night. With a working instance of pgsql now running on my Macbook Pro I can
now attempt to RTFM from the prologue onwards.

>> I needed to get in this one instance a working PostgreSQL
>> database running for a RoR project I'm doing (normally I'd use MySQL or
>> NoSQL) so I needed a quick & dirty way to get running in order to start
>> examining the documentation further.
>
> This is a very risky way: DB SQL, Pg idiomatics and modelization are *really*
> other worlds than regular programming (this is why both are usually separated
> in projects, not for pleasure but by necessity).

> While trying to get it fast'n'run you'll miss all the good things a real
> RDBMS can bring to you. In your case, the first one I see is learning
> that large tables can't make it with a high load on the server (modelization).

> Unfortunately this takes (long) time, but this time payback!
> (I spent a whole year exclusively on PG and I'm far from knowing it 100%)

Thanks for all your help & advice. It is much appreciated.

Cheers,

Phil...

--
Nothing to see here... move along, move along