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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Oliveiros d'Azevedo Cristina | 2012-07-25 11:08:49 | Re: Joining time fields? |
Previous Message | Thomas Kellerer | 2012-07-24 22:38:22 | Re: A different approach: Where to learn? |