Cargando…
PostgreSQL 11 Server Side Programming Quick Start Guide : Effective Database Programming and Interaction.
PostgreSQL is a rock-solid, scalable, and safe, enterprise-level relational database. With a broad range of features and stability it is ever increasing in popularity. The book shows you how to take advantages of PostgreSQL 11 features for Server-Side-Programming. Server-Side-Programming enables str...
| Autor principal: | |
|---|---|
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing Ltd,
2018.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000Mi 4500 | ||
|---|---|---|---|
| 001 | EBOOKCENTRAL_on1078551530 | ||
| 003 | OCoLC | ||
| 005 | 20240329122006.0 | ||
| 006 | m o d | ||
| 007 | cr |n|---||||| | ||
| 008 | 181208s2018 enk o 000 0 eng d | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d MERUC |d OCLCQ |d UKAHL |d OCLCQ |d VT2 |d NLW |d UKMGB |d OCLCO |d OCL |d OCLCQ |d OCLCO |d OCLCL | ||
| 015 | |a GBC213012 |2 bnb | ||
| 016 | 7 | |a 019176862 |2 Uk | |
| 020 | |a 9781789343502 | ||
| 020 | |a 178934350X | ||
| 020 | |z 9781789342222 |q print | ||
| 029 | 1 | |a AU@ |b 000065067613 | |
| 029 | 1 | |a UKMGB |b 019176862 | |
| 029 | 1 | |a AU@ |b 000070516191 | |
| 035 | |a (OCoLC)1078551530 | ||
| 037 | |a 9781789343502 |b Packt Publishing | ||
| 082 | 0 | 4 | |a 005.7585 |2 21 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Ferrari, Luca. | |
| 245 | 1 | 0 | |a PostgreSQL 11 Server Side Programming Quick Start Guide : |b Effective Database Programming and Interaction. |
| 260 | |a Birmingham : |b Packt Publishing Ltd, |c 2018. | ||
| 300 | |a 1 online resource (252 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 588 | 0 | |a Print version record. | |
| 505 | 0 | |a Cover; Title Page; Copyright and Credits; Dedication; About Packt; Contributors; Table of Contents; Preface; Chapter 1: PostgreSQL Server-side Programming; What is server-side programming?; How to get help; The example database; The source code of the examples in this book; Summary; Chapter 2: Statement Tricks: UPSERTs, RETURNING, and CTEs; Inserting, updating, or both?; Getting back modified data with RETURNING; Common Table Expressions (CTEs); Introducing CTEs; Writable CTEs and the RETURNING clause: Pipelining statements; Recursive CTEs; Summary; References | |
| 505 | 8 | |a Chapter 3: The PL/pgSQL LanguageAn introduction to PL/pgSQL; Variables and variable assignment; Conditionals; Iterations; Exceptions and error handling; The RAISE statement revisited; Executing dynamic statements; Throwing away a query result set; The FOUND Global Variable; Summary; References; Chapter 4: Stored Procedures; Using functions, procedures, and routines; Supported languages; Functions; Return Types; Function argument list; Returning values to the caller; Security; Immutability; Costs; Moving functions to other schemas; Temporary functions; Where is my function?; Permissions | |
| 505 | 8 | |a A tag insertion functionCompile and runtime problem detection; Procedures; Procedure argument list; Returning values to the caller; Security; Permissions; Moving procedures to other schemas; Temporary procedures; Where is my procedure?; Interacting with transactions; Nesting transactions and procedures; Summary; References; Chapter 5: PL/Perl and PL/Java; PL/Perl; Database interaction; Function arguments and return types; Re-implementing functions in PL/Perl; Implementing routines in PL/Perl; PL/Java; Installing PL/Java; PL/Java main concepts | |
| 505 | 8 | |a Implementing a PL/Java function without a deployment descriptorImplementing a PL/Java function with a deployment descriptor; Summary; References; Chapter 6: Triggers; Data manipulation triggers; The trigger function; Creating a simple trigger; Discovering if a table has triggers; Disabling Triggers; Using triggers to modify data on the fly; Parametric triggers; Aborting the current statement; The WHEN condition; The REFERENCING clause; Using a trigger to perform multiple statements; Trigger examples in foreign languages; PL/Perl Triggers; PL/Java Triggers; Data definition triggers | |
| 505 | 8 | |a The trigger functionA first event trigger; Using event triggers to avoid specific commands; Filtering specific commands; Managing event triggers; Event trigger examples in foreign languages; PL/Perl; PL/Java; Summary; References; Chapter 7: Rules and the Query Rewriting System; Introducing the query rewriting system; What is the query rewriting system?; When and where are rules used by PostgreSQL?; Rules; The syntax of rules; A rule example -- archiving tuples on deletion; Where is my rule?; Conditional rules; Using a rule to execute multiple statements- the playlist example | |
| 500 | |a Using a rule to route tuples | ||
| 520 | |a PostgreSQL is a rock-solid, scalable, and safe, enterprise-level relational database. With a broad range of features and stability it is ever increasing in popularity. The book shows you how to take advantages of PostgreSQL 11 features for Server-Side-Programming. Server-Side-Programming enables strong data encapsulation and coherence. | ||
| 504 | |a Includes bibliographical references. | ||
| 590 | |a ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 630 | 0 | 0 | |a PostgreSQL. |
| 630 | 0 | 7 | |a PostgreSQL |2 fast |
| 650 | 0 | |a Database management. | |
| 650 | 0 | |a Client/server computing. | |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 0 | |a Web servers. | |
| 650 | 4 | |a Databases. | |
| 650 | 4 | |a Computers |x Business & Productivity Software |x Databases. | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a Architecture client-serveur (Informatique) | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 6 | |a Serveurs Web. | |
| 650 | 7 | |a Data capture & analysis. |2 bicssc | |
| 650 | 7 | |a Data mining. |2 bicssc | |
| 650 | 7 | |a Databases. |2 bicssc | |
| 650 | 7 | |a Computers |x Data Processing. |2 bisacsh | |
| 650 | 7 | |a Computers |x Database Management |x Data Mining. |2 bisacsh | |
| 650 | 7 | |a Computers |x Database Management |x General. |2 bisacsh | |
| 650 | 7 | |a Web servers |2 fast | |
| 650 | 7 | |a Client/server computing |2 fast | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 758 | |i has work: |a POSTGRESQL 11 SERVER SIDE PROGRAMMING QUICK START GUIDE (Work) |1 https://id.oclc.org/worldcat/entity/E39PCXfKyJxg8Gyq3k7H33jcj3 |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Ferrari, Luca. |t PostgreSQL 11 Server Side Programming Quick Start Guide : Effective Database Programming and Interaction. |d Birmingham : Packt Publishing Ltd, ©2018 |z 9781789342222 |
| 856 | 4 | 0 | |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=5608200 |z Texto completo |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH35652464 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL5608200 | ||
| 994 | |a 92 |b IZTAP | ||