Skip site navigation (1) Skip section navigation (2)

Re: A different approach: Where to learn?

From: Alessandro Gagliardi <alessandro(at)path(dot)com>
To: fpiraneo(at)gmail(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: A different approach: Where to learn?
Date: 2012-07-24 22:49:41
Message-ID: CAAB3BBK2L0PdKd4bcGnoeWYNZc0Y2GBDA0DkyEA+mBCiNSjkYQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
I'm far from a PostgreSQL expert myself, but the way I taught myself was by
using their GUI, pgAdmin III, and just poking around. Postgres has a lot
more features than MySQL including a much richer set of datatypes (though
be careful with this: I got a little bit too excited when I discovered
arrays and made my schema less relational than it should have been). It
supports table inheritance which I found convenient. But at it's core, it's
a relational database and the kind of relational schema you are used to
from MySQL should work the same here.

-Alessandro

On Tue, Jul 24, 2012 at 2:30 PM, <fpiraneo(at)gmail(dot)com> wrote:

> Hi all,
> after eight years of using MySQL I learned about pgsql and I'm evaluating
> if it's the case to use it on a new coming project where reliability is a
> must.
>
> I've seen that pgsql is a DBMS that is "object oriented", that's mean that
> the data can be organized not only as tables with data to join on relations
> but also on object that can simplify the management of "real world data":
> WOW!
>
> I searched on Amazon for books explaining how to unleash the full power of
> an "object oriented data base" but I've found books explaining the basic of
> SQL (how to select, how to insert, joins between tables) that are concepts
> that I already know; I think that a revolutionary product like pgsql is,
> needs a different approach on design and query; now the question:
>
> Can you suggest books and / or websites where this different approach (if
> needed) can be learn? Is my idea about this "different approach" totally
> wrong and pgsql is not so different than other DBMS?
>
> Thanks a lot.
> Francesco
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

In response to

pgsql-novice by date

Next:From: Oliveiros d'Azevedo CristinaDate: 2012-07-25 11:08:49
Subject: Re: Joining time fields?
Previous:From: Thomas KellererDate: 2012-07-24 22:38:22
Subject: Re: A different approach: Where to learn?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group