Thread: Good books?
I haven't been able to get a feel of any good PostgreSQL books. Any recommendations for someone with fifteen years of experience with other databases (SQL Server, Oracle, etc.), but with no experience outside of Windows? Steve Miller SIL International
I'd personally reccommend "PostgreSQL Essential Reference" from new riders publishing.. In my case I had had experience with MySQL, and MSSQL, so I what I really needed was a quick reference to familiarize myself with the "PGSQL" way of doing things ;-) Steinn E. Sigurðarson FRISK Software International On Wednesday 29 January 2003 15:14, Steve_Miller@sil.org wrote: > I haven't been able to get a feel of any good PostgreSQL books. Any > recommendations for someone with fifteen years of experience with other > databases (SQL Server, Oracle, etc.), but with no experience outside of > Windows? > > Steve Miller > SIL International > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
We are using "PostgreSQL Developer's Handbook" ISBN 0-672-32260-9, cost= $45.00 Sean Sugrue Product Test Engineer -----Original Message----- From: Steinn E. Sigurdarson [mailto:steinn@f-prot.com] Sent: Wednesday, January 29, 2003 10:31 AM To: pgsql-novice@postgresql.org Subject: Re: [NOVICE] Good books? I'd personally reccommend "PostgreSQL Essential Reference" from new riders publishing.. In my case I had had experience with MySQL, and MSSQL, so I what I really needed was a quick reference to familiarize myself with the "PGSQL" way of doing things ;-) Steinn E. Sigurðarson FRISK Software International On Wednesday 29 January 2003 15:14, Steve_Miller@sil.org wrote: > I haven't been able to get a feel of any good PostgreSQL books. Any > recommendations for someone with fifteen years of experience with other > databases (SQL Server, Oracle, etc.), but with no experience outside of > Windows? > > Steve Miller > SIL International > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly
> I haven't been able to get a feel of any good PostgreSQL books. Any > recommendations for someone with fifteen years of experience with other > databases (SQL Server, Oracle, etc.), but with no experience outside of > Windows? The Wrox book is pretty good: http://www.amazon.com/exec/obidos/tg/detail/-/1861005156/qid=1043854553/ sr=1-4/ref=sr_1_4/102-0444630-2449703?v=glance&s=books FYI, I split the URL above. It's more of a beginners approach, which seems to be what you're after, and it does cover some aspects of using PostgreSQL on Windows as well. I haven't read the whole thing, but learned a lot in just a few chapters. Many of the PostgreSQL books on amazon.com have a lot of poor ratings, I would go to amazon.com and search on "postgresql" and look over the ratings and comments, usually that will give a good indication on whether or not the book is good for your needs. HTH, Josh
>> I haven't been able to get a feel of any good PostgreSQL books. Any >> recommendations for someone with fifteen years of experience with other >> databases (SQL Server, Oracle, etc.), but with no experience outside of >> Windows? > >The Wrox book is pretty good: > >http://www.amazon.com/exec/obidos/tg/detail/-/1861005156/qid=1043854553/ >sr=1-4/ref=sr_1_4/102-0444630-2449703?v=glance&s=books > >FYI, I split the URL above. > >It's more of a beginners approach, which seems to be what you're after, >and it does cover some aspects of using PostgreSQL on Windows as well. I >haven't read the whole thing, but learned a lot in just a few chapters. >Many of the PostgreSQL books on amazon.com have a lot of poor ratings, I >would go to amazon.com and search on "postgresql" and look over the >ratings and comments, usually that will give a good indication on whether >or not the book is good for your needs. > >HTH, > >Josh I'm not really after a beginner's database book. After learning 5 other databases, 4 of them SQL based, I'm hopeful that I can pick up a new database relatively quickly. :-) OTOH, I'm a neophyte with Linux. I got Red Hat installed on a spare box, but that's the extent of it so far. As for going to Amazon, I've looked at the comments and ratings, and I got conflicting messages. And no wonder. I've had 3 different books recommended to me in this list in less than an hour. A definitive book or two doesn't seem to exist. Steve
Subject: Re: [NOVICE] Good books? To: pgsql-novice@postgresql.org From: Steve_Miller@sil.org Date sent: Wed, 29 Jan 2003 10:04:02 -0600 I'd nominate Bruce Momijan's book, (I think there's a new edition out soon), I've got the wrox one, the pg developers handbook and php &postgresql. The last three are all ok (though the handbook and advanced php are too similar to justify having both) but suffer the usual padding of what is a relational database, (see Pascal or Date's books for a proper approach to this), what is SQL (see the practical sql handbook). I keep coming back to the Momijan book, it's all pretty well explained and updates are available online. For a nice introduction to linux I'd recommend stevie shah's Linux administration beginners guide Cheers Paul Butler > > > >> I haven't been able to get a feel of any good PostgreSQL books. Any > >> recommendations for someone with fifteen years of experience with other > >> databases (SQL Server, Oracle, etc.), but with no experience outside of > >> Windows? > > > >The Wrox book is pretty good: > > > >http://www.amazon.com/exec/obidos/tg/detail/-/1861005156/qid=1043854553/ > >sr=1-4/ref=sr_1_4/102-0444630-2449703?v=glance&s=books > > > >FYI, I split the URL above. > > > >It's more of a beginners approach, which seems to be what you're after, > >and it does cover some aspects of using PostgreSQL on Windows as well. I > >haven't read the whole thing, but learned a lot in just a few chapters. > >Many of the PostgreSQL books on amazon.com have a lot of poor ratings, I > >would go to amazon.com and search on "postgresql" and look over the > >ratings and comments, usually that will give a good indication on whether > >or not the book is good for your needs. > > > >HTH, > > > >Josh > > I'm not really after a beginner's database book. After learning 5 other > databases, 4 of them SQL based, I'm hopeful that I can pick up a new > database relatively quickly. :-) OTOH, I'm a neophyte with Linux. I got > Red Hat installed on a spare box, but that's the extent of it so far. > > As for going to Amazon, I've looked at the comments and ratings, and I got > conflicting messages. And no wonder. I've had 3 different books recommended > to me in this list in less than an hour. A definitive book or two doesn't > seem to exist. > > Steve > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> I'd nominate Bruce Momijan's book, (I think there's a new edition out > soon), I've got the wrox one, the pg developers handbook and > php &postgresql. The last three are all ok (though the handbook > and advanced php are too similar to justify having both) but suffer the > usual padding of what is a relational database, (see Pascal or Date's > books for a proper approach to this), what is SQL (see the practical > sql handbook). I keep coming back to the Momijan book, > it's all pretty well explained and updates are available online. > For a nice introduction to linux I'd recommend stevie shah's Linux > administration beginners guide There's also the Rute book: http://wwwacs.gantep.edu.tr/linux/rute/ It's all online, and seems to be a great starting point for learning Linux... Josh >> >> I haven't been able to get a feel of any good PostgreSQL books. Any >> recommendations for someone with fifteen years of experience with >> other databases (SQL Server, Oracle, etc.), but with no experience >> outside of Windows? >> > >> >The Wrox book is pretty good: >> > >> >http://www.amazon.com/exec/obidos/tg/detail/-/1861005156/qid=1043854553/ >> sr=1-4/ref=sr_1_4/102-0444630-2449703?v=glance&s=books >> > >> >FYI, I split the URL above. >> > >> >It's more of a beginners approach, which seems to be what you're >> after, and it does cover some aspects of using PostgreSQL on Windows >> as well. I haven't read the whole thing, but learned a lot in just a >> few chapters. Many of the PostgreSQL books on amazon.com have a lot >> of poor ratings, I would go to amazon.com and search on "postgresql" >> and look over the ratings and comments, usually that will give a good >> indication on whether or not the book is good for your needs. >> > >> >HTH, >> > >> >Josh >> >> I'm not really after a beginner's database book. After learning 5 >> other databases, 4 of them SQL based, I'm hopeful that I can pick up a >> new database relatively quickly. :-) OTOH, I'm a neophyte with >> Linux. I got Red Hat installed on a spare box, but that's the extent >> of it so far. >> >> As for going to Amazon, I've looked at the comments and ratings, and I >> got conflicting messages. And no wonder. I've had 3 different books >> recommended to me in this list in less than an hour. A definitive book >> or two doesn't seem to exist. >> >> Steve >> >> >> >> >> >> ---------------------------(end of >> broadcast)--------------------------- TIP 2: you can get off all lists >> at once with the unregister command >> (send "unregister YourEmailAddressHere" to >> majordomo@postgresql.org) > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org Josh Trutwin http://trutwins.homeip.net
I also use PostgreSQL Developer's Handbook published by Sams. It is written in a more reference format. I haven't looked at the Wrox PostgreSQL book but I have used their books for PHP. I would only go with Wrox if you choose a book from their pro series. Their beginner books are too class room like. The Majority of the PostgreSQL Developer's Handbook covers PostgreSql Administration, features, and programming interfaces. It only covers the basics of sql which it sounds like you could skip. I highly recommend the book. I don't think you could go wrong with it, especially using it in conjunction with the PostgreSql website. Although, I doubt you would go wrong with any of the books from the major publishers either. The advantage of Momijan's book is that you get the word straight from the developer's mouth. The disadvantage I found from previewing it online is that it is very similar to the online documents so you don't get as much of a variety in the way things are explained. Julie P.S. Let us know what you go with and what you think.
Folks, Please check out the Book Review Page: http://techdocs.postgresql.org/#bookreviews And please contribute reviews! We need more. -- Josh Berkus Aglio Database Solutions San Francisco
Hello Steinn, Am 15:31 2003-01-29 +0000 hat Steinn E. Sigurdarson geschrieben: > >I'd personally reccommend "PostgreSQL Essential Reference" from new riders >publishing.. I have not found this title in the German Database... Please can you tell me the ISBN-Number please ??? Maybe as PM to 'michelle . konzack @freenet.de' Thanks Michelle
Hello Steve, Am 09:14 2003-01-29 -0600 hat Steve_Miller@sil.org geschrieben: > >I haven't been able to get a feel of any good PostgreSQL books. Any >recommendations for someone with fifteen years of experience with other >databases (SQL Server, Oracle, etc.), but with no experience outside of >Windows? > >Steve Miller >SIL International > ################## Get the Power of Debian/GNU-Linux ################## I bought the books from O'Reilly: 'Practical PostgreSQL' and 'Programing PHP' which are very fine to learn... Have Fun Michelle