PostgreSQL server programming :: extend PostgreSQL and integrate the database layer into your development framework /
This practical guide leads you through numerous aspects of working with PostgreSQL. Step by step examples allow you to easily set up and extend PostgreSQL. ""PostgreSQL Server Programming"" is for moderate to advanced PostgreSQL database professionals. To get the best understandi...
Saved in:
| Main Author: | |
|---|---|
| Other Authors: | , |
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Birmingham :
Packt Pub.,
2013.
|
| Series: | Community experience distilled.
|
| Subjects: | |
| Online Access: | DE-862 DE-863 |
| Summary: | This practical guide leads you through numerous aspects of working with PostgreSQL. Step by step examples allow you to easily set up and extend PostgreSQL. ""PostgreSQL Server Programming"" is for moderate to advanced PostgreSQL database professionals. To get the best understanding of this book, you should have general experience in writing SQL, a basic idea of query tuning, and some coding experience in a language of your choice. |
| Item Description: | Includes index. |
| Physical Description: | 1 online resource (vi, 245 pages) : illustrations (some color) |
| ISBN: | 9781849516990 1849516995 1849516987 9781849516983 9781680153606 1680153609 |
| Access: | Legal Deposit; |
Staff View
MARC
| LEADER | 00000cam a2200000Ma 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn854569125 | ||
| 003 | OCoLC | ||
| 005 | 20250103110447.0 | ||
| 006 | m o d | ||
| 007 | cr cn||||||||| | ||
| 008 | 130715s2013 enka o 001 0 eng d | ||
| 040 | |a E7B |b eng |e pn |c E7B |d OCLCQ |d OCLCO |d OCLCF |d COO |d EBLCP |d YDXCP |d IDEBK |d UMI |d DEBSZ |d N$T |d KNOVL |d OCLCQ |d AGLDB |d ICA |d MOR |d PIFAG |d ZCU |d MERUC |d OCLCQ |d JBG |d OCLCQ |d OCLCO |d U3W |d D6H |d STF |d WRM |d OCLCQ |d VTS |d NRAMU |d ICG |d NLE |d INT |d VT2 |d AU@ |d OCLCQ |d OCLCO |d UKMGB |d OCLCQ |d OCLCO |d A6Q |d DKC |d OCLCQ |d UKAHL |d NLW |d OCLCQ |d AJS |d OCLCO |d OCLCQ |d OCLCO |d OCLCL | ||
| 015 | |a GBB747685. |2 bnb | ||
| 016 | 7 | |a 018014763 |2 Uk | |
| 019 | |a 852757349 |a 857717648 |a 860713075 |a 961562098 |a 962701088 |a 974769790 |a 974861972 |a 981867021 |a 989428728 |a 1005640116 |a 1018043075 |a 1041919219 |a 1048744515 |a 1049100126 |a 1053492086 |a 1058147862 |a 1065944621 |a 1081203821 |a 1083599168 |a 1103275223 |a 1120029063 |a 1129359017 | ||
| 020 | |a 9781849516990 |q (e-book) | ||
| 020 | |a 1849516995 |q (e-book) | ||
| 020 | |a 1849516987 | ||
| 020 | |a 9781849516983 | ||
| 020 | |a 9781680153606 | ||
| 020 | |a 1680153609 | ||
| 020 | |z 9781849516983 | ||
| 035 | |a (OCoLC)854569125 |z (OCoLC)852757349 |z (OCoLC)857717648 |z (OCoLC)860713075 |z (OCoLC)961562098 |z (OCoLC)962701088 |z (OCoLC)974769790 |z (OCoLC)974861972 |z (OCoLC)981867021 |z (OCoLC)989428728 |z (OCoLC)1005640116 |z (OCoLC)1018043075 |z (OCoLC)1041919219 |z (OCoLC)1048744515 |z (OCoLC)1049100126 |z (OCoLC)1053492086 |z (OCoLC)1058147862 |z (OCoLC)1065944621 |z (OCoLC)1081203821 |z (OCoLC)1083599168 |z (OCoLC)1103275223 |z (OCoLC)1120029063 |z (OCoLC)1129359017 | ||
| 037 | |a CL0500000277 |b Safari Books Online | ||
| 050 | 4 | |a QA76.9.D3 |b K76 2013eb | |
| 072 | 7 | |a COM |x 021000 |2 bisacsh | |
| 082 | 7 | |a 005.7585 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Krosing, Hannu. | |
| 245 | 1 | 0 | |a PostgreSQL server programming : |b extend PostgreSQL and integrate the database layer into your development framework / |c Hannu Krosing, Jim Mlodgenski, Kirk Roybal. |
| 260 | |a Birmingham : |b Packt Pub., |c 2013. | ||
| 300 | |a 1 online resource (vi, 245 pages) : |b illustrations (some color) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 1 | |a Community experience distilled | |
| 500 | |a Includes index. | ||
| 505 | 0 | |a Cover; Copyright; Credits; About the Authors; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1:What Is a PostgreSQL Server?; Why program in the server?; Using PL/pgSQL for integrity checks; About this book's code examples; Switching to the expanded display; Moving beyond simple functions; Data comparisons using operators; Managing related data with triggers; Auditing changes; Data cleaning; Custom sort orders; Programming best practices; KISS -- keep it simple stupid; DRY -- don't repeat yourself; YAGNI -- you ain't gonna need it; SOA -- service-oriented architecture. | |
| 505 | 8 | |a Type extensibilityOn caching; Wrap up -- why program in the server?; Performance; Ease of maintenance; Simple ways to tighten security; Summary; Chapter 2:Server Programming Environment; Cost of acquisition; Availability of developers; Licensing; Predictability; Community; Procedural languages; Platform compatibility; Application design; Databases are considered harmful; Encapsulation; What does PostgreSQL offer?; Data locality; More basics; Transactions; General error reporting and error handling; User-defined functions (UDF); Other parameters; More control; Summary. | |
| 505 | 8 | |a Chapter 3:Your First PL/pgSQL FunctionWhy PL/pgSQL?; Structure of a PL/pgSQL function; Accessing function arguments; Conditional expressions; Loops with counters; Looping through query results; PERFORM versus SELECT; Returning a record; Acting on function results; Summary; Chapter 4:Returning Structured Data; Sets and arrays; Returning sets; Returning a set of integers; Using a set-returning function; Returning rows from a function; Functions based on views; OUT parameters and records; OUT parameters; Returning records; Using RETURNS TABLE; Returning with no predefined structure. | |
| 505 | 8 | |a Returning SETOF ANYVariadic argument lists; Summary of RETURN SETOF variants; Returning cursors; Iterating over cursors returned from another function; Wrap up of functions returning a cursor(s); Other ways to work with structured data; Complex data types for modern world -- XML and JSON; XML data type and returning data as XML from functions; Returning data in the JSON format; Summary; Chapter 5:PL/pgSQL Trigger Functions; Creating the trigger function; Creating the trigger; Simple ""Hey, I'm called"" trigger; The audit trigger; Disallowing DELETE; Disallowing TRUNCATE. | |
| 505 | 8 | |a Modifying the NEW recordTimestamping trigger; Immutable fields trigger; Controlling when a trigger is called; Conditional trigger; Trigger on specific field changes; Visibility; And most importantly -- use triggers cautiously!; Variables passed to the PL/pgSQL TRIGGER function; Summary; Chapter 6:Debugging PL/pgSQL; ''Manual'' debugging with RAISE NOTICE; Throwing exceptions; Logging to a file; Advantages of RAISE NOTICE; Disadvantages of RAISE NOTICE; Visual debugging; Getting the debugger installed; Installing pgAdmin3; Using the debugger; Advantages of the debugger. | |
| 520 | |a This practical guide leads you through numerous aspects of working with PostgreSQL. Step by step examples allow you to easily set up and extend PostgreSQL. ""PostgreSQL Server Programming"" is for moderate to advanced PostgreSQL database professionals. To get the best understanding of this book, you should have general experience in writing SQL, a basic idea of query tuning, and some coding experience in a language of your choice. | ||
| 506 | 1 | |a Legal Deposit; |c Only available on premises controlled by the deposit library and to one user at any one time; |e The Legal Deposit Libraries (Non-Print Works) Regulations (UK). |5 WlAbNL | |
| 630 | 0 | 0 | |a PostgreSQL. |0 http://id.loc.gov/authorities/names/n00067354 |
| 630 | 0 | 7 | |a PostgreSQL. |2 blmlsh |
| 630 | 0 | 7 | |a PostgreSQL |2 fast |
| 650 | 0 | |a Database management. |0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a COMPUTERS |x Databases |x General. |2 bisacsh | |
| 650 | 7 | |a Database management |2 fast | |
| 700 | 1 | |a Mlodgenski, Jim. | |
| 700 | 1 | |a Roybal, Kirk. | |
| 758 | |i has work: |a PostgreSQL server programming (Work) |1 https://id.oclc.org/worldcat/entity/E39PCXvmbmxFYTrbBXGPqW4Chw |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Krosing, Hannu. |t PostgreSQL Server Programming. |d Birmingham : Packt Publishing, ©2013 |z 9781849516983 |
| 830 | 0 | |a Community experience distilled. |0 http://id.loc.gov/authorities/names/no2011030603 | |
| 966 | 4 | 0 | |l DE-862 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=604055 |3 Volltext |
| 966 | 4 | 0 | |l DE-863 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=604055 |3 Volltext |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26850736 | ||
| 938 | |a EBL - Ebook Library |b EBLB |n EBL1220931 | ||
| 938 | |a ebrary |b EBRY |n ebr10728417 | ||
| 938 | |a EBSCOhost |b EBSC |n 604055 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n cis26003739 | ||
| 938 | |a YBP Library Services |b YANK |n 10832965 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-862 | ||
| 049 | |a DE-863 | ||
Record in the Search Index
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn854569125 |
|---|---|
| _version_ | 1829094965629681664 |
| adam_text | |
| any_adam_object | |
| author | Krosing, Hannu |
| author2 | Mlodgenski, Jim Roybal, Kirk |
| author2_role | |
| author2_variant | j m jm k r kr |
| author_facet | Krosing, Hannu Mlodgenski, Jim Roybal, Kirk |
| author_role | |
| author_sort | Krosing, Hannu |
| author_variant | h k hk |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D3 K76 2013eb |
| callnumber-search | QA76.9.D3 K76 2013eb |
| callnumber-sort | QA 276.9 D3 K76 42013EB |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| contents | Cover; Copyright; Credits; About the Authors; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1:What Is a PostgreSQL Server?; Why program in the server?; Using PL/pgSQL for integrity checks; About this book's code examples; Switching to the expanded display; Moving beyond simple functions; Data comparisons using operators; Managing related data with triggers; Auditing changes; Data cleaning; Custom sort orders; Programming best practices; KISS -- keep it simple stupid; DRY -- don't repeat yourself; YAGNI -- you ain't gonna need it; SOA -- service-oriented architecture. Type extensibilityOn caching; Wrap up -- why program in the server?; Performance; Ease of maintenance; Simple ways to tighten security; Summary; Chapter 2:Server Programming Environment; Cost of acquisition; Availability of developers; Licensing; Predictability; Community; Procedural languages; Platform compatibility; Application design; Databases are considered harmful; Encapsulation; What does PostgreSQL offer?; Data locality; More basics; Transactions; General error reporting and error handling; User-defined functions (UDF); Other parameters; More control; Summary. Chapter 3:Your First PL/pgSQL FunctionWhy PL/pgSQL?; Structure of a PL/pgSQL function; Accessing function arguments; Conditional expressions; Loops with counters; Looping through query results; PERFORM versus SELECT; Returning a record; Acting on function results; Summary; Chapter 4:Returning Structured Data; Sets and arrays; Returning sets; Returning a set of integers; Using a set-returning function; Returning rows from a function; Functions based on views; OUT parameters and records; OUT parameters; Returning records; Using RETURNS TABLE; Returning with no predefined structure. Returning SETOF ANYVariadic argument lists; Summary of RETURN SETOF variants; Returning cursors; Iterating over cursors returned from another function; Wrap up of functions returning a cursor(s); Other ways to work with structured data; Complex data types for modern world -- XML and JSON; XML data type and returning data as XML from functions; Returning data in the JSON format; Summary; Chapter 5:PL/pgSQL Trigger Functions; Creating the trigger function; Creating the trigger; Simple ""Hey, I'm called"" trigger; The audit trigger; Disallowing DELETE; Disallowing TRUNCATE. Modifying the NEW recordTimestamping trigger; Immutable fields trigger; Controlling when a trigger is called; Conditional trigger; Trigger on specific field changes; Visibility; And most importantly -- use triggers cautiously!; Variables passed to the PL/pgSQL TRIGGER function; Summary; Chapter 6:Debugging PL/pgSQL; ''Manual'' debugging with RAISE NOTICE; Throwing exceptions; Logging to a file; Advantages of RAISE NOTICE; Disadvantages of RAISE NOTICE; Visual debugging; Getting the debugger installed; Installing pgAdmin3; Using the debugger; Advantages of the debugger. |
| ctrlnum | (OCoLC)854569125 |
| dewey-full | 005.7585 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.7585 |
| dewey-search | 005.7585 |
| dewey-sort | 15.7585 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>07214cam a2200733Ma 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn854569125</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20250103110447.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cn|||||||||</controlfield><controlfield tag="008">130715s2013 enka o 001 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">E7B</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">E7B</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCF</subfield><subfield code="d">COO</subfield><subfield code="d">EBLCP</subfield><subfield code="d">YDXCP</subfield><subfield code="d">IDEBK</subfield><subfield code="d">UMI</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">N$T</subfield><subfield code="d">KNOVL</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">AGLDB</subfield><subfield code="d">ICA</subfield><subfield code="d">MOR</subfield><subfield code="d">PIFAG</subfield><subfield code="d">ZCU</subfield><subfield code="d">MERUC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">JBG</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">U3W</subfield><subfield code="d">D6H</subfield><subfield code="d">STF</subfield><subfield code="d">WRM</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">VTS</subfield><subfield code="d">NRAMU</subfield><subfield code="d">ICG</subfield><subfield code="d">NLE</subfield><subfield code="d">INT</subfield><subfield code="d">VT2</subfield><subfield code="d">AU@</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">UKMGB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">A6Q</subfield><subfield code="d">DKC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">UKAHL</subfield><subfield code="d">NLW</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">AJS</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield></datafield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBB747685.</subfield><subfield code="2">bnb</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018014763</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">852757349</subfield><subfield code="a">857717648</subfield><subfield code="a">860713075</subfield><subfield code="a">961562098</subfield><subfield code="a">962701088</subfield><subfield code="a">974769790</subfield><subfield code="a">974861972</subfield><subfield code="a">981867021</subfield><subfield code="a">989428728</subfield><subfield code="a">1005640116</subfield><subfield code="a">1018043075</subfield><subfield code="a">1041919219</subfield><subfield code="a">1048744515</subfield><subfield code="a">1049100126</subfield><subfield code="a">1053492086</subfield><subfield code="a">1058147862</subfield><subfield code="a">1065944621</subfield><subfield code="a">1081203821</subfield><subfield code="a">1083599168</subfield><subfield code="a">1103275223</subfield><subfield code="a">1120029063</subfield><subfield code="a">1129359017</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781849516990</subfield><subfield code="q">(e-book)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1849516995</subfield><subfield code="q">(e-book)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1849516987</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781849516983</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781680153606</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1680153609</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781849516983</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)854569125</subfield><subfield code="z">(OCoLC)852757349</subfield><subfield code="z">(OCoLC)857717648</subfield><subfield code="z">(OCoLC)860713075</subfield><subfield code="z">(OCoLC)961562098</subfield><subfield code="z">(OCoLC)962701088</subfield><subfield code="z">(OCoLC)974769790</subfield><subfield code="z">(OCoLC)974861972</subfield><subfield code="z">(OCoLC)981867021</subfield><subfield code="z">(OCoLC)989428728</subfield><subfield code="z">(OCoLC)1005640116</subfield><subfield code="z">(OCoLC)1018043075</subfield><subfield code="z">(OCoLC)1041919219</subfield><subfield code="z">(OCoLC)1048744515</subfield><subfield code="z">(OCoLC)1049100126</subfield><subfield code="z">(OCoLC)1053492086</subfield><subfield code="z">(OCoLC)1058147862</subfield><subfield code="z">(OCoLC)1065944621</subfield><subfield code="z">(OCoLC)1081203821</subfield><subfield code="z">(OCoLC)1083599168</subfield><subfield code="z">(OCoLC)1103275223</subfield><subfield code="z">(OCoLC)1120029063</subfield><subfield code="z">(OCoLC)1129359017</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">CL0500000277</subfield><subfield code="b">Safari Books Online</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.D3</subfield><subfield code="b">K76 2013eb</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">021000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.7585</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Krosing, Hannu.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">PostgreSQL server programming :</subfield><subfield code="b">extend PostgreSQL and integrate the database layer into your development framework /</subfield><subfield code="c">Hannu Krosing, Jim Mlodgenski, Kirk Roybal.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Birmingham :</subfield><subfield code="b">Packt Pub.,</subfield><subfield code="c">2013.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (vi, 245 pages) :</subfield><subfield code="b">illustrations (some color)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Community experience distilled</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Cover; Copyright; Credits; About the Authors; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1:What Is a PostgreSQL Server?; Why program in the server?; Using PL/pgSQL for integrity checks; About this book's code examples; Switching to the expanded display; Moving beyond simple functions; Data comparisons using operators; Managing related data with triggers; Auditing changes; Data cleaning; Custom sort orders; Programming best practices; KISS -- keep it simple stupid; DRY -- don't repeat yourself; YAGNI -- you ain't gonna need it; SOA -- service-oriented architecture.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Type extensibilityOn caching; Wrap up -- why program in the server?; Performance; Ease of maintenance; Simple ways to tighten security; Summary; Chapter 2:Server Programming Environment; Cost of acquisition; Availability of developers; Licensing; Predictability; Community; Procedural languages; Platform compatibility; Application design; Databases are considered harmful; Encapsulation; What does PostgreSQL offer?; Data locality; More basics; Transactions; General error reporting and error handling; User-defined functions (UDF); Other parameters; More control; Summary.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Chapter 3:Your First PL/pgSQL FunctionWhy PL/pgSQL?; Structure of a PL/pgSQL function; Accessing function arguments; Conditional expressions; Loops with counters; Looping through query results; PERFORM versus SELECT; Returning a record; Acting on function results; Summary; Chapter 4:Returning Structured Data; Sets and arrays; Returning sets; Returning a set of integers; Using a set-returning function; Returning rows from a function; Functions based on views; OUT parameters and records; OUT parameters; Returning records; Using RETURNS TABLE; Returning with no predefined structure.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Returning SETOF ANYVariadic argument lists; Summary of RETURN SETOF variants; Returning cursors; Iterating over cursors returned from another function; Wrap up of functions returning a cursor(s); Other ways to work with structured data; Complex data types for modern world -- XML and JSON; XML data type and returning data as XML from functions; Returning data in the JSON format; Summary; Chapter 5:PL/pgSQL Trigger Functions; Creating the trigger function; Creating the trigger; Simple ""Hey, I'm called"" trigger; The audit trigger; Disallowing DELETE; Disallowing TRUNCATE.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Modifying the NEW recordTimestamping trigger; Immutable fields trigger; Controlling when a trigger is called; Conditional trigger; Trigger on specific field changes; Visibility; And most importantly -- use triggers cautiously!; Variables passed to the PL/pgSQL TRIGGER function; Summary; Chapter 6:Debugging PL/pgSQL; ''Manual'' debugging with RAISE NOTICE; Throwing exceptions; Logging to a file; Advantages of RAISE NOTICE; Disadvantages of RAISE NOTICE; Visual debugging; Getting the debugger installed; Installing pgAdmin3; Using the debugger; Advantages of the debugger.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">This practical guide leads you through numerous aspects of working with PostgreSQL. Step by step examples allow you to easily set up and extend PostgreSQL. ""PostgreSQL Server Programming"" is for moderate to advanced PostgreSQL database professionals. To get the best understanding of this book, you should have general experience in writing SQL, a basic idea of query tuning, and some coding experience in a language of your choice.</subfield></datafield><datafield tag="506" ind1="1" ind2=" "><subfield code="a">Legal Deposit;</subfield><subfield code="c">Only available on premises controlled by the deposit library and to one user at any one time;</subfield><subfield code="e">The Legal Deposit Libraries (Non-Print Works) Regulations (UK).</subfield><subfield code="5">WlAbNL</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">PostgreSQL.</subfield><subfield code="0">http://id.loc.gov/authorities/names/n00067354</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">PostgreSQL.</subfield><subfield code="2">blmlsh</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">PostgreSQL</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85035848</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Gestion.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Databases</subfield><subfield code="x">General.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="2">fast</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Mlodgenski, Jim.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Roybal, Kirk.</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">PostgreSQL server programming (Work)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCXvmbmxFYTrbBXGPqW4Chw</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Krosing, Hannu.</subfield><subfield code="t">PostgreSQL Server Programming.</subfield><subfield code="d">Birmingham : Packt Publishing, ©2013</subfield><subfield code="z">9781849516983</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Community experience distilled.</subfield><subfield code="0">http://id.loc.gov/authorities/names/no2011030603</subfield></datafield><datafield tag="966" ind1="4" ind2="0"><subfield code="l">DE-862</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=604055</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="4" ind2="0"><subfield code="l">DE-863</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=604055</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH26850736</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBL - Ebook Library</subfield><subfield code="b">EBLB</subfield><subfield code="n">EBL1220931</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ebrary</subfield><subfield code="b">EBRY</subfield><subfield code="n">ebr10728417</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">604055</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest MyiLibrary Digital eBook Collection</subfield><subfield code="b">IDEB</subfield><subfield code="n">cis26003739</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">10832965</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-862</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-ocn854569125 |
| illustrated | Illustrated |
| indexdate | 2025-04-11T08:41:30Z |
| institution | BVB |
| isbn | 9781849516990 1849516995 1849516987 9781849516983 9781680153606 1680153609 |
| language | English |
| oclc_num | 854569125 |
| open_access_boolean | |
| owner | MAIN DE-862 DE-BY-FWS DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-862 DE-BY-FWS DE-863 DE-BY-FWS |
| physical | 1 online resource (vi, 245 pages) : illustrations (some color) |
| psigel | ZDB-4-EBA FWS_PDA_EBA ZDB-4-EBA |
| publishDate | 2013 |
| publishDateSearch | 2013 |
| publishDateSort | 2013 |
| publisher | Packt Pub., |
| record_format | marc |
| series | Community experience distilled. |
| series2 | Community experience distilled |
| spelling | Krosing, Hannu. PostgreSQL server programming : extend PostgreSQL and integrate the database layer into your development framework / Hannu Krosing, Jim Mlodgenski, Kirk Roybal. Birmingham : Packt Pub., 2013. 1 online resource (vi, 245 pages) : illustrations (some color) text txt rdacontent computer c rdamedia online resource cr rdacarrier Community experience distilled Includes index. Cover; Copyright; Credits; About the Authors; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1:What Is a PostgreSQL Server?; Why program in the server?; Using PL/pgSQL for integrity checks; About this book's code examples; Switching to the expanded display; Moving beyond simple functions; Data comparisons using operators; Managing related data with triggers; Auditing changes; Data cleaning; Custom sort orders; Programming best practices; KISS -- keep it simple stupid; DRY -- don't repeat yourself; YAGNI -- you ain't gonna need it; SOA -- service-oriented architecture. Type extensibilityOn caching; Wrap up -- why program in the server?; Performance; Ease of maintenance; Simple ways to tighten security; Summary; Chapter 2:Server Programming Environment; Cost of acquisition; Availability of developers; Licensing; Predictability; Community; Procedural languages; Platform compatibility; Application design; Databases are considered harmful; Encapsulation; What does PostgreSQL offer?; Data locality; More basics; Transactions; General error reporting and error handling; User-defined functions (UDF); Other parameters; More control; Summary. Chapter 3:Your First PL/pgSQL FunctionWhy PL/pgSQL?; Structure of a PL/pgSQL function; Accessing function arguments; Conditional expressions; Loops with counters; Looping through query results; PERFORM versus SELECT; Returning a record; Acting on function results; Summary; Chapter 4:Returning Structured Data; Sets and arrays; Returning sets; Returning a set of integers; Using a set-returning function; Returning rows from a function; Functions based on views; OUT parameters and records; OUT parameters; Returning records; Using RETURNS TABLE; Returning with no predefined structure. Returning SETOF ANYVariadic argument lists; Summary of RETURN SETOF variants; Returning cursors; Iterating over cursors returned from another function; Wrap up of functions returning a cursor(s); Other ways to work with structured data; Complex data types for modern world -- XML and JSON; XML data type and returning data as XML from functions; Returning data in the JSON format; Summary; Chapter 5:PL/pgSQL Trigger Functions; Creating the trigger function; Creating the trigger; Simple ""Hey, I'm called"" trigger; The audit trigger; Disallowing DELETE; Disallowing TRUNCATE. Modifying the NEW recordTimestamping trigger; Immutable fields trigger; Controlling when a trigger is called; Conditional trigger; Trigger on specific field changes; Visibility; And most importantly -- use triggers cautiously!; Variables passed to the PL/pgSQL TRIGGER function; Summary; Chapter 6:Debugging PL/pgSQL; ''Manual'' debugging with RAISE NOTICE; Throwing exceptions; Logging to a file; Advantages of RAISE NOTICE; Disadvantages of RAISE NOTICE; Visual debugging; Getting the debugger installed; Installing pgAdmin3; Using the debugger; Advantages of the debugger. This practical guide leads you through numerous aspects of working with PostgreSQL. Step by step examples allow you to easily set up and extend PostgreSQL. ""PostgreSQL Server Programming"" is for moderate to advanced PostgreSQL database professionals. To get the best understanding of this book, you should have general experience in writing SQL, a basic idea of query tuning, and some coding experience in a language of your choice. Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK). WlAbNL PostgreSQL. http://id.loc.gov/authorities/names/n00067354 PostgreSQL. blmlsh PostgreSQL fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Bases de données Gestion. COMPUTERS Databases General. bisacsh Database management fast Mlodgenski, Jim. Roybal, Kirk. has work: PostgreSQL server programming (Work) https://id.oclc.org/worldcat/entity/E39PCXvmbmxFYTrbBXGPqW4Chw https://id.oclc.org/worldcat/ontology/hasWork Print version: Krosing, Hannu. PostgreSQL Server Programming. Birmingham : Packt Publishing, ©2013 9781849516983 Community experience distilled. http://id.loc.gov/authorities/names/no2011030603 |
| spellingShingle | Krosing, Hannu PostgreSQL server programming : extend PostgreSQL and integrate the database layer into your development framework / Community experience distilled. Cover; Copyright; Credits; About the Authors; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1:What Is a PostgreSQL Server?; Why program in the server?; Using PL/pgSQL for integrity checks; About this book's code examples; Switching to the expanded display; Moving beyond simple functions; Data comparisons using operators; Managing related data with triggers; Auditing changes; Data cleaning; Custom sort orders; Programming best practices; KISS -- keep it simple stupid; DRY -- don't repeat yourself; YAGNI -- you ain't gonna need it; SOA -- service-oriented architecture. Type extensibilityOn caching; Wrap up -- why program in the server?; Performance; Ease of maintenance; Simple ways to tighten security; Summary; Chapter 2:Server Programming Environment; Cost of acquisition; Availability of developers; Licensing; Predictability; Community; Procedural languages; Platform compatibility; Application design; Databases are considered harmful; Encapsulation; What does PostgreSQL offer?; Data locality; More basics; Transactions; General error reporting and error handling; User-defined functions (UDF); Other parameters; More control; Summary. Chapter 3:Your First PL/pgSQL FunctionWhy PL/pgSQL?; Structure of a PL/pgSQL function; Accessing function arguments; Conditional expressions; Loops with counters; Looping through query results; PERFORM versus SELECT; Returning a record; Acting on function results; Summary; Chapter 4:Returning Structured Data; Sets and arrays; Returning sets; Returning a set of integers; Using a set-returning function; Returning rows from a function; Functions based on views; OUT parameters and records; OUT parameters; Returning records; Using RETURNS TABLE; Returning with no predefined structure. Returning SETOF ANYVariadic argument lists; Summary of RETURN SETOF variants; Returning cursors; Iterating over cursors returned from another function; Wrap up of functions returning a cursor(s); Other ways to work with structured data; Complex data types for modern world -- XML and JSON; XML data type and returning data as XML from functions; Returning data in the JSON format; Summary; Chapter 5:PL/pgSQL Trigger Functions; Creating the trigger function; Creating the trigger; Simple ""Hey, I'm called"" trigger; The audit trigger; Disallowing DELETE; Disallowing TRUNCATE. Modifying the NEW recordTimestamping trigger; Immutable fields trigger; Controlling when a trigger is called; Conditional trigger; Trigger on specific field changes; Visibility; And most importantly -- use triggers cautiously!; Variables passed to the PL/pgSQL TRIGGER function; Summary; Chapter 6:Debugging PL/pgSQL; ''Manual'' debugging with RAISE NOTICE; Throwing exceptions; Logging to a file; Advantages of RAISE NOTICE; Disadvantages of RAISE NOTICE; Visual debugging; Getting the debugger installed; Installing pgAdmin3; Using the debugger; Advantages of the debugger. PostgreSQL. http://id.loc.gov/authorities/names/n00067354 PostgreSQL. blmlsh PostgreSQL fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Bases de données Gestion. COMPUTERS Databases General. bisacsh Database management fast |
| subject_GND | http://id.loc.gov/authorities/names/n00067354 http://id.loc.gov/authorities/subjects/sh85035848 |
| title | PostgreSQL server programming : extend PostgreSQL and integrate the database layer into your development framework / |
| title_auth | PostgreSQL server programming : extend PostgreSQL and integrate the database layer into your development framework / |
| title_exact_search | PostgreSQL server programming : extend PostgreSQL and integrate the database layer into your development framework / |
| title_full | PostgreSQL server programming : extend PostgreSQL and integrate the database layer into your development framework / Hannu Krosing, Jim Mlodgenski, Kirk Roybal. |
| title_fullStr | PostgreSQL server programming : extend PostgreSQL and integrate the database layer into your development framework / Hannu Krosing, Jim Mlodgenski, Kirk Roybal. |
| title_full_unstemmed | PostgreSQL server programming : extend PostgreSQL and integrate the database layer into your development framework / Hannu Krosing, Jim Mlodgenski, Kirk Roybal. |
| title_short | PostgreSQL server programming : |
| title_sort | postgresql server programming extend postgresql and integrate the database layer into your development framework |
| title_sub | extend PostgreSQL and integrate the database layer into your development framework / |
| topic | PostgreSQL. http://id.loc.gov/authorities/names/n00067354 PostgreSQL. blmlsh PostgreSQL fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Bases de données Gestion. COMPUTERS Databases General. bisacsh Database management fast |
| topic_facet | PostgreSQL. PostgreSQL Database management. Bases de données Gestion. COMPUTERS Databases General. Database management |
| work_keys_str_mv | AT krosinghannu postgresqlserverprogrammingextendpostgresqlandintegratethedatabaselayerintoyourdevelopmentframework AT mlodgenskijim postgresqlserverprogrammingextendpostgresqlandintegratethedatabaselayerintoyourdevelopmentframework AT roybalkirk postgresqlserverprogrammingextendpostgresqlandintegratethedatabaselayerintoyourdevelopmentframework |