473,326 Members | 2,010 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

books/sites for someone really learning PG's advanced features?

I'm switching to PostgreSQL from MySQL. Using the SAMs book called
PostgreSQL which has been great to skim the surface of the
differerences.

I had never even heard of things like triggers, views, and foreign keys before.

Any recommended books or websites (or exercises) that would really
help someone get to know not just the basics of how these advanced
features work, but some real in-depth insight into how to USE them for
real work?

(It's always hard to get used to actually using features you never
knew existed before.)

Thanks!

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #1
5 1279
Miles Keaton wrote:
I'm switching to PostgreSQL from MySQL. Using the SAMs book called
PostgreSQL which has been great to skim the surface of the
differerences.

I had never even heard of things like triggers, views, and foreign keys before.

Any recommended books or websites (or exercises) that would really
help someone get to know not just the basics of how these advanced
features work, but some real in-depth insight into how to USE them for
real work?


I'd start out with:

http://www.acm.org/classics/nov95/toc.html

Unfortunately, the ACM doesn't have the complete paper online.

Then read:

C.J. Date, An Introduction to Database Systems

Or skip over the Intro book and read:

C.J. Date, A Guide to the SQL Standard

Here's a good link for problems caused due to lack of normalization:

http://209.197.234.36/db/simple.html

You'll see that views and foreign keys are fundamental to ensuring
consistency and handling data with normalized base tables. You should
try to achieve logical consistency in your design without using triggers
through the use of domain constraints, column and table constraints and
referential integrity constraints. Failing to enforce consistency at
that point, triggers can be used to enforce such things as what Date
calls database constraints. I.e.: if a department has a budget of under
1000, there should not exist more than 5 employees.

Hope that helps,

Mike Mascari

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #2
Hi,

On Fri, 2004-09-24 at 08:03, Miles Keaton wrote:
I'm switching to PostgreSQL from MySQL. Using the SAMs book called
PostgreSQL which has been great to skim the surface of the
differerences.

I had never even heard of things like triggers, views, and foreign keys before.
Smells like success story here :-)
Any recommended books or websites (or exercises) that would really
help someone get to know not just the basics of how these advanced
features work, but some real in-depth insight into how to USE them for
real work?

(It's always hard to get used to actually using features you never
knew existed before.)


The point is when you miss something and you know there must be a better
way to do things which motivates a change of a plattform.

I dont know many good books about this, but at least foreign keys
are a basic concept of RDBMS so you should find a lot about in the
literature. All other topics are something you will know when you
have a problem to solve. I'd recomment not using a feature just
because its so cool :-)
Postgresql has a lot of other helpful things like functions in
different languages - where you definitively will have to read
a lot, custom datatypes and operators and more.

Welcome to the world of postgres I'd say :-)

Regards
Tino
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #3
On Thu, Sep 23, 2004 at 11:03:30PM -0700, Miles Keaton wrote:
I'm switching to PostgreSQL from MySQL. Using the SAMs book called
PostgreSQL which has been great to skim the surface of the
differerences.

I had never even heard of things like triggers, views, and foreign keys before.

Any recommended books or websites (or exercises) that would really
help someone get to know not just the basics of how these advanced
features work, but some real in-depth insight into how to USE them for
real work?

(It's always hard to get used to actually using features you never
knew existed before.)


Hi Miles,

It sounds like you're in the same place I was in 18 months ago. I
learned SQL (as it were) by reading the MySQL manual, and then I read
an advocacy post somewhere and realized that I was re-implementing in my
middleware all the stuff that the DBMS should've been doing for me
already.

The way I learned Postgres was by reading the documentation
cover-to-cover (<http://www.postgresql.org/docs>). There are lots of
really good examples in there on all the features you mention, but I
seem to remember that they were scattered all over the place, and
anyway I found the docs to be a pretty easy read. I never bothered
with any of the Postgres-specific books because, as I understood it,
there was nothing on the market at the time that covered the latest
version.

Actually, the feature I had the hardest time learning were server-side
functions (including triggers), because I couldn't find a good
interactive programming environment with syntax highlighting and all
the rest to test them out with.

Now, what really helped me to understand how to *query* databases was
the book _An Introduction to Database Systems_ by Chris Date, but that
book might distract you from learning Postgres, if you're an idealist,
because it really finds a lot of reasons to disparage SQL.

- Jeremy

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #4
Miles,

(Just like someone else also commented), I was in a situation like
yours, and I found the postgres online documentation quite helpful. I
wouldn't read it cover-to-cover yet, but eventually you will want to
read every part of it.

Here is what I found particular helpful at the start:

SQL commands:
http://www.postgresql.org/docs/7.4/s...-commands.html

Concurrency control:
http://www.postgresql.org/docs/7.4/static/mvcc.html

Triggers:
http://www.postgresql.org/docs/7.4/static/triggers.html

Note that the section on triggers is a bit sparse, but you can see alot
of examples of triggers and their use by looking through the various
pages about pl/pgsql, pl/perl, etc. (which follow the section about
triggers)

Paul Tillotson

Miles Keaton wrote:
I'm switching to PostgreSQL from MySQL. Using the SAMs book called
PostgreSQL which has been great to skim the surface of the
differerences.

I had never even heard of things like triggers, views, and foreign keys before.

Any recommended books or websites (or exercises) that would really
help someone get to know not just the basics of how these advanced
features work, but some real in-depth insight into how to USE them for
real work?

(It's always hard to get used to actually using features you never
knew existed before.)

Thanks!

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #5
"Miles Keaton" <mi*********@gmail.com> wrote in message
news:59************************@mail.gmail.com...
I'm switching to PostgreSQL from MySQL. Using the SAMs book called
PostgreSQL which has been great to skim the surface of the
differerences.

I had never even heard of things like triggers, views, and foreign keys
before.

Any recommended books or websites (or exercises) that would really
help someone get to know not just the basics of how these advanced
features work, but some real in-depth insight into how to USE them for
real work?

(It's always hard to get used to actually using features you never
knew existed before.)

Thanks!


I too am just starting to learn, but I've found Practical PostgreSQL by
O'Reilly to be quite good and very informative.

--
Best regards, from Don Kelloway of Commodon Communications
Visit http://www.commodon.com to learn about the "Threats to Your Security
on the Internet".
Nov 23 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: noid droid | last post by:
Hi. I posted yesterday asking if C# lived up to the hype. Thus far the feedback has been all positive. (Thanks.) Can anyone suggest GOOD books for learning C# and the Visual Studio .NET IDE? ...
8
by: Earl | last post by:
I've been on a mission this past year to move from VB6 to .Net. I'm fortunate(!?) not to have the big catalog of some long-time VB developers, although I have some CE apps that have to be entirely...
54
by: m.roello | last post by:
In the book: "Working with Microsoft Visual Studio 2005" Craig Skibo wrote: "The power of Visual Studio 2005 lies in its ability to empower users to build, test, and debug powerful applications...
26
by: puzzlecracker | last post by:
It'd be interesting to compare the learning practices of c++ practitioners. I'll start with mine The C++ Programming Language C++ Primer Effective C++ More Effective C++ Effective STL The...
23
by: herraotic | last post by:
I have been getting ready to learn programming for a long time, installed a GNU/Linux operating system, learnt the ins and outs but I think it is time to pick up a book and learn to now program. ...
8
by: Frank Swarbrick | last post by:
I just got an email from Amazon.com offering me a pre-order of "DB2 9 for Developers" by Philip K. Gunning. Clicking on the link it showed me a few other possibly interesting books: "IBM DB2 9...
0
by: paradox6996 | last post by:
I was looking today at some Object Oriented Programming books today and wasn't sure which was good for what I wanted to learn. I'm currently in school for CSC and have taken programming classes; I...
38
by: FAQ server | last post by:
----------------------------------------------------------------------- FAQ Topic - What books cover EcmaScript? ----------------------------------------------------------------------- Most CLJ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.