Обсуждение: Book
Hello I currently own a copy of "PostgreSQL Developer's Handbook" by Geshwinde and Schonig, 2002. Would this still be good enough to start making databases in the current version of PostgreSQL? I noticed it talks about Redhat 7.1. I have Windows XP Pro, Windows 98SE and a copy of Fedora Core 3 (as well as Knoppix 3.4 and a copy of Xandros Desktop OS Version 2 Value Pack that I won as a door prize at my local Linux Users Group). I'm trying to start up a web development business using JSP 2 and maybe moving onto desktop apps in Java later on. I'm thinking of developing in Windows but if Linux proves more stable I'd be tempted to develop in that. I'm currently trying out Netbeans 4.0 though I was using Eclipse 3.0 until recently. I've had some small experience with mysql but I've read that PostgreSQL doesn't buckle under high loads and that it supports referential integrity. Thanks Peter Mount info@petermount.au.com
On Feb 11, 2005, at 5:00 AM, Peter Mount wrote: > I currently own a copy of "PostgreSQL Developer's Handbook" by > Geshwinde and Schonig, 2002. Would this still be good enough to start > making databases in the current version of PostgreSQL? I noticed it > talks about Redhat 7.1. I have Windows XP Pro, Windows 98SE and a copy > of Fedora Core 3 (as well as Knoppix 3.4 and a copy of Xandros Desktop > OS Version 2 Value Pack that I won as a door prize at my local Linux > Users Group). > I have not seen the book, but I would guess that any PostgreSQL book from a few years ago would still provide a decent overview. But you'll want to work with something more recent as you get into advanced features. The PostgreSQL documentation is very good, so I would recommend to skim the book for an overview and then use the PostgreSQL documentation as your primary reference. John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
Peter......
> I currently own a copy of "PostgreSQL Developer's Handbook" by Geshwinde
> and Schonig, 2002. Would this still be good enough to start making
> databases in the current version of PostgreSQL?
In my opinion, yes. The admin and SQL statements are still much the same.
Plus there is much documentation online for you to read, you can pick up
any changes there.
> I'm thinking of developing in Windows but if Linux proves more stable
> I'd be tempted to develop in that.
I do programming work as a side job for a friend who hosts many websites,
plus have a few database backed websites of my own. We host on *nix
machines, when we started there were few, if any, web servers on windows
machines, but today it's possible to host on windows. I still prefer
FreeBSD and linix for hosting, but I've never tried windows for hosting,
so I can't really comment. There are others here who run postgreSQL on
windows, they can chip in.
I develop on my laptop, I have one plugin drive that boots to XP and
another drive that boots to Debian linux. I use the linux drive more than
80% of the time.
> I've had some small experience with mysql but I've read that PostgreSQL
> doesn't buckle under high loads and that it supports referential
> integrity.
On my linux laptop and my main online webserver machine (both Debian
linux) I have both postgreSQL and mysql database servers running
simultaneously. Some websites use one and some the other (and some
neither!).
Note that these are small litely used websites, about one pageview a
second or so (but it can easily handle more). My biggest table in any
database is less than 50,000 rows. I connect to the databases via perl
and/or php. There are others on the list with big heavily used databases
that get many (hundreds of?) hits a second with gigs of rows. They have
the webserver on one machine and postgreSQL on another machine.
I favor *nix machines. Keep reading the lists, get something loaded and
running properly and you'll soon find the way it works for you.
Welcome.....
brew
Both my personal websites in my .sig below use postgreSQL with php and
Apache and perl for the backend cron processes, btw.
==========================================================================
Strange Brew (brew@theMode.com)
Check out my Stock Option Covered Call website http://www.callpix.com
and my Musician's Online Database Exchange http://www.TheMode.com
==========================================================================
Peter, Instead of Java for the front end try using PHP or Python. They tie in better with Postgresql. The book you have is good enough to develop databases. I have used it for a contract that I was working on for the last year. Regards Hari -----Original Message----- From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Peter Mount Sent: Friday, February 11, 2005 4:01 AM To: PostgreSQL Novice Subject: [NOVICE] Book Hello I currently own a copy of "PostgreSQL Developer's Handbook" by Geshwinde and Schonig, 2002. Would this still be good enough to start making databases in the current version of PostgreSQL? I noticed it talks about Redhat 7.1. I have Windows XP Pro, Windows 98SE and a copy of Fedora Core 3 (as well as Knoppix 3.4 and a copy of Xandros Desktop OS Version 2 Value Pack that I won as a door prize at my local Linux Users Group). I'm trying to start up a web development business using JSP 2 and maybe moving onto desktop apps in Java later on. I'm thinking of developing in Windows but if Linux proves more stable I'd be tempted to develop in that. I'm currently trying out Netbeans 4.0 though I was using Eclipse 3.0 until recently. I've had some small experience with mysql but I've read that PostgreSQL doesn't buckle under high loads and that it supports referential integrity. Thanks Peter Mount info@petermount.au.com ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings