Re: [GENERAL] Books
Thomas Løcke escribió: > Would I be supporting the PostgreSQL project by buying these, or are they > just a compilation of the online manuals, done by some random author calling > him-/herself "The PostgreSQL Global Development Group"? :o) If you really want to support the PostgreSQL project, you could donate money through SPI. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Books, the lulu.com scam
2009/11/22 Ivano Luberti > I read books about software products when I need to get introduced to > the whole picture: architecture, underlying technologies. > In this way I also understand what to search for when I need detailed > information or tip and tricks. > > > Well that's the problem in this case. The book isn't a high-level introduction, it's the official documentation in print. It's the same as the online documentation verbatim. As far as I can see, the differences between the electronic copy that Lulu sells and the PDF provided on the official site are that Lulu's one costs money, has restrictive DRM protections and is presented in a slightly different layout. Furthermore, when the next major release comes out, you can just download another copy from the official site for free, but not so with Lulu. Thom
Re: [GENERAL] Books, the lulu.com scam
I read books about software products when I need to get introduced to the whole picture: architecture, underlying technologies. In this way I also understand what to search for when I need detailed information or tip and tricks. Rikard Bosnjakovic ha scritto: > On Sat, Nov 21, 2009 at 18:10, Yordan Radunchev > wrote: > > [...] > >> Why should one buy a book? >> > > Books are invaluable reading material when "number two" is due. > Laptops and on line-documentation doesn't stand a chance in that > particular case. Also, I prefer laying down in the sofa reading a > book. Using a laptop, I can't lay down - I'd have to sit. Books are > for the win here. > > > -- == dott. Ivano Mario Luberti Archimede Informatica societa' cooperativa a r. l. Sede Operativa Via Gereschi 36 - 56126- Pisa tel.: +39-050- 580959 tel/fax: +39-050-9711344 web: www.archicoop.it == -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Books, the lulu.com scam
2009/11/21 Yordan Radunchev : > Postgre have such a great (and helpful and wiling to share knowledge) > community and great on-line documentation for free. +1 > Books (content) tent to get old and more useless with every Postgre > update. If some one offers a book with lifetime support meaning that it will > be > updated regularly following Postgre updates - that will be an offer... > but still - I don't need a book. I bought an O'Rielly Javascript book once, but had to ask a question online on the javascript group. I was flamed for using outdated documentation. (And they never even answered my question, either) This Postgres list is one of the most helpful around; thank you all! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Books, the lulu.com scam
On Sat, Nov 21, 2009 at 18:10, Yordan Radunchev wrote: [...] > Why should one buy a book? Books are invaluable reading material when "number two" is due. Laptops and on line-documentation doesn't stand a chance in that particular case. Also, I prefer laying down in the sofa reading a book. Using a laptop, I can't lay down - I'd have to sit. Books are for the win here. -- - Rikard -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Books, the lulu.com scam
Thom Brown wrote: >> So I bought this "book" thinking it was a PDF file which I am fine with. >> Its not. They download an .acsm file that will only work with their >> proprietary Windoze software. >> I am really angry with lulu.com about this. > I'm not sure I understand the purpose of them providing an electronic > book copy of the PostgreSQL documentation since it's already available > as both a PDF (A4 and US) and Windows help file (CHM) for free: > http://www.postgresql.org/docs/manuals/ Apparently, you can make money out of it. Tim -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Books, the lulu.com scam
On Sat, Nov 21, 2009 at 08:37:45AM -0700, Bill Todd wrote: > The Adobe ebook reader is available for Windows and Mac. I thought Adobe > offered a Linux version too but apparently not. It is not Lulu's fault that > Adobe does not offer a Linux version of the ebook reader. > > Bill > > Alan Gruskoff wrote: > > So I bought this "book" thinking it was a PDF file which I am fine with. > > Its not. They download an .acsm file that will only work with their > proprietary Windoze software. > > I am really angry with lulu.com about this. > > - Alan Gruskoff > Postgre have such a great (and helpful and wiling to share knowledge) community and great on-line documentation for free. Why should one buy a book? Is there anything in that book that one can't find in the on-line documentation or here?! Seriously? Even if it is PDF I will pass. Books (content) tent to get old and more useless with every Postgre update. If some one offers a book with lifetime support meaning that it will be updated regularly following Postgre updates - that will be an offer... but still - I don't need a book. -- All texts and all ideas expressed by me in this message are covered by CC-BY-NC-SA-3.0. http://creativecommons.org/licenses/by-nc-sa/3.0/ signature.asc Description: Digital signature
Re: [GENERAL] Books, the lulu.com scam
It IS their fault that they're selling DM books -- plenty of other publishers (like the Pragmatic Programmers) seem to make a living without assuming that all of their customers are thieves. I bought a book from them assuming it would be a PDF & was furious when it was that adobe thing. It may have said somewhere that that would be the case, but it certainly wasn't anywhere obvious, like it should be with an issue like that. They lost my custom for ever.
Re: [GENERAL] Books, the lulu.com scam
The Adobe ebook reader is available for Windows and Mac. I thought Adobe offered a Linux version too but apparently not. It is not Lulu's fault that Adobe does not offer a Linux version of the ebook reader. Bill Alan Gruskoff wrote: So I bought this "book" thinking it was a PDF file which I am fine with. Its not. They download an .acsm file that will only work with their proprietary Windoze software. I am really angry with lulu.com about this. - Alan Gruskoff On 11/20/2009 11:35 AM, Joshua D. Drake wrote: On Thu, 2009-11-19 at 15:34 -0500, Chris Browne wrote: thomas.granv...@gmail.com (Thomas Løcke) writes: There's a new series of PostgreSQL books available: PostgreSQL 8.4 Official Documentation - Volume I PostgreSQL 8.4 Official Documentation - Volume II And so on, up to volume V I think. Would I be supporting the PostgreSQL project by buying these, or are they just a compilation of the online manuals, done by some random author calling him-/ herself "The PostgreSQL Global Development Group"? :o) Lulu.com has some books of this form... http://www.lulu.com/product/e-book/postgresql-84-official-documentation---volume-i-the-sql-language/5912706#detailsSection If you are looking for a known contributor to the project for documentation I would review the following: http://www.lulu.com/product/hardcover/postgresql-81-volume-ii/543356
Re: [GENERAL] Books, the lulu.com scam
2009/11/21 Alan Gruskoff > > So I bought this "book" thinking it was a PDF file which I am fine with. > > Its not. They download an .acsm file that will only work with their > proprietary Windoze software. > > I am really angry with lulu.com about this. > > - Alan Gruskoff > I'm not sure I understand the purpose of them providing an electronic book copy of the PostgreSQL documentation since it's already available as both a PDF (A4 and US) and Windows help file (CHM) for free: http://www.postgresql.org/docs/manuals/ Thom -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Books, the lulu.com scam
So I bought this "book" thinking it was a PDF file which I am fine with. Its not. They download an .acsm file that will only work with their proprietary Windoze software. I am really angry with lulu.com about this. - Alan Gruskoff On 11/20/2009 11:35 AM, Joshua D. Drake wrote: > On Thu, 2009-11-19 at 15:34 -0500, Chris Browne wrote: > >> > thomas.granv...@gmail.com (Thomas Løcke) writes: >> >>> > > There's a new series of PostgreSQL books available: >>> > > >>> > > PostgreSQL 8.4 Official Documentation - Volume I >>> > > PostgreSQL 8.4 Official Documentation - Volume II >>> > > >>> > > And so on, up to volume V I think. >>> > > >>> > > Would I be supporting the PostgreSQL project by buying these, or are >>> > > they just >>> > > a compilation of the online manuals, done by some random author calling >>> > > him-/ >>> > > herself "The PostgreSQL Global Development Group"? :o) >>> >> > >> > Lulu.com has some books of this form... >> > >> > http://www.lulu.com/product/e-book/postgresql-84-official-documentation---volume-i-the-sql-language/5912706#detailsSection >> > If you are looking for a known contributor to the project for > documentation I would review the following: > > http://www.lulu.com/product/hardcover/postgresql-81-volume-ii/543356 > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Books
On Thu, 2009-11-19 at 15:34 -0500, Chris Browne wrote: > thomas.granv...@gmail.com (Thomas Løcke) writes: > > There's a new series of PostgreSQL books available: > > > > PostgreSQL 8.4 Official Documentation - Volume I > > PostgreSQL 8.4 Official Documentation - Volume II > > > > And so on, up to volume V I think. > > > > Would I be supporting the PostgreSQL project by buying these, or are they > > just > > a compilation of the online manuals, done by some random author calling > > him-/ > > herself "The PostgreSQL Global Development Group"? :o) > > Lulu.com has some books of this form... > > http://www.lulu.com/product/e-book/postgresql-84-official-documentation---volume-i-the-sql-language/5912706#detailsSection If you are looking for a known contributor to the project for documentation I would review the following: http://www.lulu.com/product/hardcover/postgresql-81-volume-ii/543356 Or: http://www.network-theory.co.uk/ Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering If the world pushes look it in the eye and GRR. Then push back harder. - Salamander -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Books
Thomas Løcke wrote: Would I be supporting the PostgreSQL project by buying these, or are they just a compilation of the online manuals, done by some random author calling him-/herself "The PostgreSQL Global Development Group"? :o) They're a printout of the manuals that come with the database. As you can see at http://www.linbrary.com/postgresql/840/index.html "Fultus Corporation is not affiliated with The PostgreSQL Global Development Group." -- Greg Smith2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Books
thomas.granv...@gmail.com (Thomas Løcke) writes: > There's a new series of PostgreSQL books available: > > PostgreSQL 8.4 Official Documentation - Volume I > PostgreSQL 8.4 Official Documentation - Volume II > > And so on, up to volume V I think. > > Would I be supporting the PostgreSQL project by buying these, or are they just > a compilation of the online manuals, done by some random author calling him-/ > herself "The PostgreSQL Global Development Group"? :o) Lulu.com has some books of this form... http://www.lulu.com/product/e-book/postgresql-84-official-documentation---volume-i-the-sql-language/5912706#detailsSection Looking at "publishing information": ISBN978-1-59682-163-7 Publisher Fultus Corporation LanguageEnglish Publication Date 8 January 2009 Format Adobe Encrypted PDF Apparently this is a way of providing "proprietary encrypted documentation"... While I'd be fairly prepared to pay something for a printed copy of the documentation (and would not be loathe to have someone profit from the service of publishing it for me), I don't think I'll be buying encrypted PDF files from anyone just now! -- (format nil "~...@~s" "cbbrowne" "acm.org") http://linuxfinances.info/info/slony.html "Bother," said Pooh, as he deleted his root directory. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Books for experienced DB developer
Tino, Multiple recordsets means returning multiple setof results, not just one. As an example in a SQL Server Stored Procedure you can have the following in the same stored procedure: create proc getdata as select * from table1 select * from table2 go and it will return 2 resultsets. This is not possible in postgresql today. "Tino Wildenhain" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Fri, 2005-01-07 at 11:56 +0100, Patrick FICHE wrote: > > I'm afraid this is still a problem. > > From my knowledge, Postgres function is able to return a single result-set > > not multiple. > > I may have missed some facility... > > see > http://techdocs.postgresql.org/guides/SetReturningFunctions > or > http://www.postgresql.org/docs/current/static/xfunc-sql.html#AEN28835 > > (fresh from freenode irc #postgresql channel) > > Or is it not what you mean? > > Regards > Tino > > > ---(end of broadcast)--- > TIP 4: Don't 'kill -9' the postmaster > ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Books for experienced developers
Postgresql introductions and concepts by bruce momijan isn't bad, though it is severely out of date, but most of the concepts of postgresql have stayed the same, the text will not provide you with any how-tos for the newer functionality, though it should help you make the conceptual switch to postgresql. It's available for cheap used through 3rd party vendors on amazon. Though if you have no problems reading online texts, the online documentation is very good, and far more up to date. regards matt On Fri, 07 Jan 2005 15:08:04 -0600, Shawn Harrison <[EMAIL PROTECTED]> wrote: > Craig Bryden wrote [01/07/05 3:46 AM]: > > Hi > > > > I have vast experience working with MS-SQL. Which books would be good > > for me to use in order to teach myself PostgreSQL? I need to migrate a > > MS-SQL Db to PostgreSQL. It contains tablers,views,stored procs, and > > user defined functions. > > With no other RDBMS experience, I learned PostgreSQL using the online > documentation. I'm using tables, views, rules, triggers, and stored > procedures -- everything you've mentioned. Everything you need is > explained very well in the docs. > > > > > Thanks > > Craig > > > -- > > [EMAIL PROTECTED] > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > >http://archives.postgresql.org > ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] Books for experienced developers
Craig Bryden wrote [01/07/05 3:46 AM]: Hi I have vast experience working with MS-SQL. Which books would be good for me to use in order to teach myself PostgreSQL? I need to migrate a MS-SQL Db to PostgreSQL. It contains tablers,views,stored procs, and user defined functions. With no other RDBMS experience, I learned PostgreSQL using the online documentation. I'm using tables, views, rules, triggers, and stored procedures -- everything you've mentioned. Everything you need is explained very well in the docs. Thanks Craig -- [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] Books for experienced DB developer
On Fri, Jan 07, 2005 at 12:20:13PM +0100, Tino Wildenhain wrote: > Nevertheless you should be able to return 3 cursors you > define in your stored function and use them afterwards. A function can also return SETOF RECORD. However, a query calling such a function would need to provide a column definition list, so the query must know in advance what record type the function will return. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Books for experienced DB developer
I installed pgadminIII and really enjoy their built in documentation reader for PostgreSQL. The documentation that came with pgadminIII had been updated for the new version 8 features. Rick Geoffrey <[EMAIL PROTECTED]>To: pgsql-general@postgresql.org Sent by: cc: [EMAIL PROTECTED]Subject: Re: [GENERAL] Books for experienced DB developer tgresql.org 01/07/2005 08:58 AM Craig Bryden wrote: > Hi > > I am a very experienced MS-SQL developer. I am looking to port a > database to PostgreSQL. Which books that are available would be ideal > for someone who is already an experienced DB developer? If you are experienced, I'd say you'd save yourself some cash and be perfectly fine using the online docs. I'll assume you'll be on a wintel arch, based on your experience. When you install Postgresql on a Linux box, you get all the docs installed as well. I don't know about the windows install. -- Until later, Geoffrey ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster ---(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
Re: [GENERAL] Books for experienced DB developer
Craig Bryden wrote: Hi Michael I am having some problems porting my Stored Procedures. I am using the pl/pgsql language. Instead of irritating/spamming everyone on this mailing list, I was hoping that there would be a comprehensive book that focusses on how to do DB things in PostgreSQL, but that does not spend too much time explaining RDBMS basics. Although I "really", "really" do appreciate what you say above these lists are specifically for helping people with the problems they are having. It is great that you are willing to read the docs first (more people should) but as you an experienced developed I would assume you are going to ask questions that make sense ;). So please, feel free and take your best shot :) On a general note it may be productive for you to look at the other procedural languages as well. Sincerely, Joshua D. Drake Thanks Craig From: Michael Fuhr <[EMAIL PROTECTED]> To: Craig Bryden <[EMAIL PROTECTED]> CC: pgsql-general@postgresql.org Subject: Re: [GENERAL] Books for experienced DB developer Date: Fri, 7 Jan 2005 02:58:29 -0700 On Fri, Jan 07, 2005 at 11:33:52AM +0200, Craig Bryden wrote: > I am a very experienced MS-SQL developer. I am looking to port a database > to PostgreSQL. Which books that are available would be ideal for someone > who is already an experienced DB developer? PostgreSQL has good documentation so I'd suggest starting there. If the documentation doesn't cover something you want to know then please provide more info about what you're looking for. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ _ Research SA schools and varsities on MSN Search. http://search.msn.co.za ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:[EMAIL PROTECTED] title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Books for experienced DB developer
Craig Bryden wrote: Hi I am a very experienced MS-SQL developer. I am looking to port a database to PostgreSQL. Which books that are available would be ideal for someone who is already an experienced DB developer? If you are experienced, I'd say you'd save yourself some cash and be perfectly fine using the online docs. I'll assume you'll be on a wintel arch, based on your experience. When you install Postgresql on a Linux box, you get all the docs installed as well. I don't know about the windows install. -- Until later, Geoffrey ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Books for experienced DB developer
On Fri, 2005-01-07 at 12:17 +0100, Patrick FICHE wrote: > No, this is only one result-set. > MS SQL Server is able to return multiple result-set. > > For example, one SQL Server function can return the result of the following > queries : > SELECT * FROM Table1 > SELECT * FROM Table2 > SELECT * FROM Table3 > > with Table1, Table2 and Table3 having different structures... > > For example, you can navigate in the result-sets in ODBC using the > SQLMoreResults function... I wonder how this fits into the SQL standard by any way ;) Nevertheless you should be able to return 3 cursors you define in your stored function and use them afterwards. Regards Tino ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL] Books for experienced DB developer
It has been able to do this for some time now... Take a look 33.4.4. SQL Functions Returning Sets http://www.postgresql.org/docs/7.4/static/xfunc-sql.html > I'm afraid this is still a problem. > From my knowledge, Postgres function is able to return a single result-set > not multiple. > I may have missed some facility... > > Regards, > Patrick > > --- > Patrick Fiche > email : [EMAIL PROTECTED] > tél : 01 69 29 36 18 > > --- > > > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Tino Wildenhain > Sent: vendredi 7 janvier 2005 11:45 > To: Patrick FICHE > Cc: Craig Bryden; pgsql-general@postgresql.org > Subject: Re: [GENERAL] Books for experienced DB developer > > > On Fri, 2005-01-07 at 11:25 +0100, Patrick FICHE wrote: >> Hi Craig, >> >> 2 years ago, I had to do some porting from MS SQL to Postgres. >> All the application logic was coded in stored procedures... >> >> The major problem I was faced to, was to port procedures returning > multiple >> result-sets... > > At least, this isnt a problem anymore :-) > > Regards > Tino > > > ---(end of broadcast)--- > TIP 8: explain analyze is your friend > > ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Books for experienced DB developer
No, this is only one result-set. MS SQL Server is able to return multiple result-set. For example, one SQL Server function can return the result of the following queries : SELECT * FROM Table1 SELECT * FROM Table2 SELECT * FROM Table3 with Table1, Table2 and Table3 having different structures... For example, you can navigate in the result-sets in ODBC using the SQLMoreResults function... That's probably not a very usual way of programming but we did it and experienced problems for porting Regards, Patrick --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 --- -Original Message- From: Tino Wildenhain [mailto:[EMAIL PROTECTED] Sent: vendredi 7 janvier 2005 12:08 To: Patrick FICHE Cc: Craig Bryden; pgsql-general@postgresql.org Subject: RE: [GENERAL] Books for experienced DB developer On Fri, 2005-01-07 at 11:56 +0100, Patrick FICHE wrote: > I'm afraid this is still a problem. > From my knowledge, Postgres function is able to return a single result-set > not multiple. > I may have missed some facility... see http://techdocs.postgresql.org/guides/SetReturningFunctions or http://www.postgresql.org/docs/current/static/xfunc-sql.html#AEN28835 (fresh from freenode irc #postgresql channel) Or is it not what you mean? Regards Tino ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Books for experienced DB developer
On Fri, 2005-01-07 at 11:56 +0100, Patrick FICHE wrote: > I'm afraid this is still a problem. > From my knowledge, Postgres function is able to return a single result-set > not multiple. > I may have missed some facility... see http://techdocs.postgresql.org/guides/SetReturningFunctions or http://www.postgresql.org/docs/current/static/xfunc-sql.html#AEN28835 (fresh from freenode irc #postgresql channel) Or is it not what you mean? Regards Tino ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Books for experienced DB developer
I'm afraid this is still a problem. >From my knowledge, Postgres function is able to return a single result-set not multiple. I may have missed some facility... Regards, Patrick --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 --- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tino Wildenhain Sent: vendredi 7 janvier 2005 11:45 To: Patrick FICHE Cc: Craig Bryden; pgsql-general@postgresql.org Subject: Re: [GENERAL] Books for experienced DB developer On Fri, 2005-01-07 at 11:25 +0100, Patrick FICHE wrote: > Hi Craig, > > 2 years ago, I had to do some porting from MS SQL to Postgres. > All the application logic was coded in stored procedures... > > The major problem I was faced to, was to port procedures returning multiple > result-sets... At least, this isnt a problem anymore :-) Regards Tino ---(end of broadcast)--- TIP 8: explain analyze is your friend ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] Books for experienced DB developer
On Fri, 2005-01-07 at 11:25 +0100, Patrick FICHE wrote: > Hi Craig, > > 2 years ago, I had to do some porting from MS SQL to Postgres. > All the application logic was coded in stored procedures... > > The major problem I was faced to, was to port procedures returning multiple > result-sets... At least, this isnt a problem anymore :-) Regards Tino ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] Books for experienced DB developer
Hi Craig, 2 years ago, I had to do some porting from MS SQL to Postgres. All the application logic was coded in stored procedures... The major problem I was faced to, was to port procedures returning multiple result-sets... Another problem was that there is no default value for stored procedures in PostgreSQL, so you have to set all parameters and modify calling applications to do so... I have written some tips for porting but in French. If you face to special problems, don't hesitate to ask for and if I perhaps encountered the same problem... Patrick --- Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36 18 --- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Craig Bryden Sent: vendredi 7 janvier 2005 11:04 To: [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Books for experienced DB developer Hi Michael I am having some problems porting my Stored Procedures. I am using the pl/pgsql language. Instead of irritating/spamming everyone on this mailing list, I was hoping that there would be a comprehensive book that focusses on how to do DB things in PostgreSQL, but that does not spend too much time explaining RDBMS basics. Thanks Craig >From: Michael Fuhr <[EMAIL PROTECTED]> >To: Craig Bryden <[EMAIL PROTECTED]> >CC: pgsql-general@postgresql.org >Subject: Re: [GENERAL] Books for experienced DB developer >Date: Fri, 7 Jan 2005 02:58:29 -0700 > >On Fri, Jan 07, 2005 at 11:33:52AM +0200, Craig Bryden wrote: > > > I am a very experienced MS-SQL developer. I am looking to port a >database > > to PostgreSQL. Which books that are available would be ideal for someone > > who is already an experienced DB developer? > >PostgreSQL has good documentation so I'd suggest starting there. >If the documentation doesn't cover something you want to know then >please provide more info about what you're looking for. > >-- >Michael Fuhr >http://www.fuhr.org/~mfuhr/ _ Research SA schools and varsities on MSN Search. http://search.msn.co.za ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Books for experienced DB developer
Hi Michael I am having some problems porting my Stored Procedures. I am using the pl/pgsql language. Instead of irritating/spamming everyone on this mailing list, I was hoping that there would be a comprehensive book that focusses on how to do DB things in PostgreSQL, but that does not spend too much time explaining RDBMS basics. Thanks Craig From: Michael Fuhr <[EMAIL PROTECTED]> To: Craig Bryden <[EMAIL PROTECTED]> CC: pgsql-general@postgresql.org Subject: Re: [GENERAL] Books for experienced DB developer Date: Fri, 7 Jan 2005 02:58:29 -0700 On Fri, Jan 07, 2005 at 11:33:52AM +0200, Craig Bryden wrote: > I am a very experienced MS-SQL developer. I am looking to port a database > to PostgreSQL. Which books that are available would be ideal for someone > who is already an experienced DB developer? PostgreSQL has good documentation so I'd suggest starting there. If the documentation doesn't cover something you want to know then please provide more info about what you're looking for. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ _ Research SA schools and varsities on MSN Search. http://search.msn.co.za ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL] Books for experienced DB developer
On Fri, Jan 07, 2005 at 11:33:52AM +0200, Craig Bryden wrote: > I am a very experienced MS-SQL developer. I am looking to port a database > to PostgreSQL. Which books that are available would be ideal for someone > who is already an experienced DB developer? PostgreSQL has good documentation so I'd suggest starting there. If the documentation doesn't cover something you want to know then please provide more info about what you're looking for. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] books/sites for someone really learning PG's advanced
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
Re: [GENERAL] Books for PostgreSQL?
As the co-author of Practical PostgreSQL: Yes Pratical PostgreSQL 2E is on the way. It will cover 7.4. It WILL NOT BE OUT NEXT MONTH. It will probably be out in mid-winter. Sincerely, Joshua Drake Martin Marques wrote: El Jue 28 Ago 2003 10:26, Benjamin Jury escribió: The only problem with 'Practical PostgreSQL' is that it is rather out of date. Not exactly. Yesterday a friend told me that a new edition of the book was coming out this month, which should cover up to 7.3, or even 7.4 features. Any way, I was only told, and didn't have time to check it out yet. -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-222-2783 - [EMAIL PROTECTED] - http://www.commandprompt.com The most reliable support for the most reliable Open Source database.
Re: [GENERAL] Books for PostgreSQL?
On Thursday, August 28, 2003, at 08:58 AM, Dennis Gearon wrote: Heath Tanner wrote: Not to take anything away from the books on the topic, but my favorite source is the docs that got installed with postgres (/usr/local/pgsql/doc/html). The index isn't great, but easily overcome: grep -i "search phrase" /usr/local/pgsql/doc/html/* | less Try to do that with a book. :-) That brings ujp a good point, indexes in many technical bools are pathetic. I wrote a quick'n'dirty search engine (using PostgreSQL, of course) for exactly that reason. Jeff ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Books for PostgreSQL?
Benjamin Jury wrote: The only problem with 'Practical PostgreSQL' is that it is rather out of date. True, there have been many new features, however you can't say its beyond usefullness now. A new person to PostgreSQL can look at it online, check it out at the library, pick it up new/used... and still learn the majority of PostgreSQL installation and usage. one on LXP, if its not included out of the box then why put it in the book? A chapter is way to much IMHO...) I heard a rumour that LXP should be open sourced fairly soon. Wait until the 2nd edition that should cover 7.3 or 7.4. We all wait in anticipation... ;-) However, the 1st release is open source and you can read it online anytime. -- Robby Russell, | Sr. Administrator / Lead Programmer Command Prompt, Inc. | http://www.commandprompt.com [EMAIL PROTECTED] | Telephone: (503) 222.2783 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] Books for PostgreSQL?
On 28 Aug 2003 at 7:55, Chris Webster wrote: > > Not to take anything away from the books on the topic, but my favorite > > source is the docs that got installed with postgres > > (/usr/local/pgsql/doc/html). > > > > The index isn't great, but easily overcome: > > grep -i "search phrase" /usr/local/pgsql/doc/html/* | less > > > > Try to do that with a book. :-) > > > > When I can't find the answer there, I search the mailing list archives > > and/or google. > > I'm sorry, but I'm also a DB newbie, and I find the online documentation > ok/good, and very good if you are a seasoned user who just needs > reference. It esp sucks regarding the configuration file. Yes it > explains each line item, but not how it affects the database, when do > you want a large value here, when do you want a small value, etc. This > fact is born out by the number of times people have to respond with "did > you tweak in the config file?" Maybe the books aren't any better http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html These are actually collections of FAQ put in a nice sugar candy. HTH Bye Shridhar -- Respect is a rational process -- McCoy, "The Galileo Seven", stardate 2822.3 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [GENERAL] Books for PostgreSQL?
Heath Tanner wrote: Not to take anything away from the books on the topic, but my favorite source is the docs that got installed with postgres (/usr/local/pgsql/doc/html). The index isn't great, but easily overcome: grep -i "search phrase" /usr/local/pgsql/doc/html/* | less Try to do that with a book. :-) That brings ujp a good point, indexes in many technical bools are pathetic. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Books for PostgreSQL?
Not to take anything away from the books on the topic, but my favorite source is the docs that got installed with postgres (/usr/local/pgsql/doc/html). The index isn't great, but easily overcome: grep -i "search phrase" /usr/local/pgsql/doc/html/* | less Try to do that with a book. :-) When I can't find the answer there, I search the mailing list archives and/or google. I'm sorry, but I'm also a DB newbie, and I find the online documentation ok/good, and very good if you are a seasoned user who just needs reference. It esp sucks regarding the configuration file. Yes it explains each line item, but not how it affects the database, when do you want a large value here, when do you want a small value, etc. This fact is born out by the number of times people have to respond with "did you tweak in the config file?" Maybe the books aren't any better -- --Chris Eagles may soar, but weasels don't get sucked into jet engines. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Books for PostgreSQL?
El Jue 28 Ago 2003 10:26, Benjamin Jury escribió: > The only problem with 'Practical PostgreSQL' is that it is rather out of > date. Not exactly. Yesterday a friend told me that a new edition of the book was coming out this month, which should cover up to 7.3, or even 7.4 features. Any way, I was only told, and didn't have time to check it out yet. -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] Books for PostgreSQL?
Not to take anything away from the books on the topic, but my favorite source is the docs that got installed with postgres (/usr/local/pgsql/doc/html). The index isn't great, but easily overcome: grep -i "search phrase" /usr/local/pgsql/doc/html/* | less Try to do that with a book. :-) When I can't find the answer there, I search the mailing list archives and/or google. -heath ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Books for PostgreSQL?
You could try postgres documentation at http://www.postgresql.org/docs/ or there is an online book titled 'PostgreSQL: Introduction and Concepts' at http://candle.pha.pa.us/main/writings/computer.html G Lam wrote: Hi, I have some experience in MS Access 97 and 2000 and did write some application with them. Now, I want to learn PostgreSQL. I installed it on a RH8.0 server. Which books would you guys recommand? Thank you. Gary ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Books for PostgreSQL?
On Wed, 2003-08-20 at 22:13, G Lam wrote: > Hi, I have some experience in MS Access 97 and 2000 and did write some > application with them. Now, I want to learn PostgreSQL. I installed it on a > RH8.0 server. Which books would you guys recommand? As important as the book: what version are you using? That which comes with RH8.0? It is recommended that you upgrade to v7.3.4. -- - Ron Johnson, Jr. [EMAIL PROTECTED] Jefferson, LA USA 4 degrees from Vladimir Putin ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] Books for PostgreSQL?
I'll second the usefulness of Bruce's book. I still refer to it years after buying it. I'd highly recommend either of the two books out by Sams with by Hans and Ewald. Both very good good books. One is just purely Postgresql, the other is a PHP/Postgresql book. On Wed, 27 Aug 2003, Christoph Becker wrote: > Together with the official documentation I still use > PostgreSQL - Introduction and Concepts from Bruce Momjian. He should write a > much more comprehensive (tuning, large objects vs bytea) and updated (to 7.4) > 2nd edition, but it is still very good and really worth the money. > Regards > Christoph > Am Donnerstag, 21. August 2003 05:13 schrieb G Lam: > > Hi, I have some experience in MS Access 97 and 2000 and did write some > > application with them. Now, I want to learn PostgreSQL. I installed it on a > > RH8.0 server. Which books would you guys recommand? > > Thank you. > > Gary > > > > > > > > ---(end of broadcast)--- > > TIP 7: don't forget to increase your free space map settings > > > ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Books for PostgreSQL?
Hi, I have some experience in MS Access 97 and 2000 and did write some application with them. Now, I want to learn PostgreSQL. I installed it on a RH8.0 server. Which books would you guys recommand? Well, I'm a little biased because I work at the author's shop :), but I use Practical PostgreSQL from O'Reilly (link below also has the book online). And I also use Bruce Momjian's PostgreSQL Introduction and Concepts book a lot -- it's been commuting with me to work for the past few weeks. I'm always on the lookout for more PostgreSQL books so I'll be following this thread with interest. -- Best, Al Hulaton| Sr. Account Engineer | Command Prompt, Inc. 503.222.2783 | [EMAIL PROTECTED] Home of Mammoth PostgreSQL and 'Practical PostgreSQL' Managed PostgreSQL, Linux services and consulting Read and Search O'Reilly's 'Practical PostgreSQL' at http://www.commandprompt.com ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Books for PostgreSQL?
G Lam wrote: Hi, I have some experience in MS Access 97 and 2000 and did write some application with them. Now, I want to learn PostgreSQL. I installed it on a RH8.0 server. Which books would you guys recommand? Thank you. Gary ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings 'PostgreSQL Essential Reference' by Barry Stinson is a useful book to have at your desk, it's the only one I use. As the name suggests, it's a reference and not a database/SQL how-to for total database newbies. OTOH I *can't* recommend the O'Reilly book because the index is very poor, making it useless as reference material. Ron ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] Books on PostgreSQL?
Ian Harding wrote: > I just got my copy of the programmers guide yesterday. > It is a printed copy of the document of the same name available online. > It is worth the money because you can read it in the bathroom, and because > hopefully Thomas Lochart (sic) gets some money. I found myself being > frustrated looking at a flashing screen when looking for information, but > find a real book to be easier to use. It is already a little out of date, > but that is a fact of life with printed materials. I have a Sony Vaio Picturebook... I hope that this does not discourage any writers but at 1 kg it is the weight of a book and yes you can take it to the loo (english for bathroom, bog...). For reading e-books a tool to rotate the screen would be nice. The e-book reader for windows does it. I'll have to read the XFree docs to see if my neomagic card does this in X too. I will have Acrobat 5 in the next few days. If you are interested maybe it would be worth while to convert the .ps docs to e-book format? Off home - temperature is back up over 30° again so time for a beer or two. Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html Macromedia UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl