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...

Full description

Saved in:
Bibliographic Details
Main Author: Krosing, Hannu.
Other Authors: Mlodgenski, Jim., Roybal, Kirk.
Format: eBook
Language: English
Published: Birmingham : Packt Pub., 2013.
Series: Community experience distilled.
Subjects:
PostgreSQL.
PostgreSQL
Database management.
elektronické knihy
electronic books
ISBN: 9781849516990
1849516995
1849516987
9781849516983
9781680153606
1680153609
Physical Description: 1 online resource (vi, 245 pages) : illustrations (some color)

Cover

Table of contents

LEADER 06045cam a2200541Ma 4500
001 kn-ocn854569125
003 OCoLC
005 20240717213016.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 
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 
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. 
506 |a Plný text je dostupný pouze z IP adres počítačů Univerzity Tomáše Bati ve Zlíně nebo vzdáleným přístupem pro zaměstnance a studenty 
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. 
590 |a Knovel  |b Knovel (All titles) 
630 0 0 |a PostgreSQL. 
630 0 7 |a PostgreSQL.  |2 blmlsh 
630 0 7 |a PostgreSQL  |2 fast 
650 0 |a Database management. 
655 7 |a elektronické knihy  |7 fd186907  |2 czenas 
655 9 |a electronic books  |2 eczenas 
700 1 |a Mlodgenski, Jim. 
700 1 |a Roybal, Kirk. 
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. 
856 4 0 |u https://proxy.k.utb.cz/login?url=https://app.knovel.com/hotlink/toc/id:kpPSQLSP0U/postgresql-server-programming?kpromoter=marc  |y Full text 

Similar Items