會員

PostgreSQL 11 Server Side Programming Quick Start Guide

更新時間：2021-06-10 19:23:32

開會員，本書免費讀 >

PostgreSQLisarock-solid,scalable,andsafeenterprise-levelrelationaldatabase.Withabroadrangeoffeaturesandstability,itiseverincreasinginpopularity.ThisbookshowsyouhowtotakeadvantageofPostgreSQL11featuresforserver-sideprogramming.Server-sideprogrammingenablesstrongdataencapsulationandcoherence.Thebookbeginswiththeimportanceofserver-sideprogrammingandexplainstherisksofleavingallthechecksoutsidethedatabase.Tobuildyourcapabilitiesfurther,youwilllearnhowtowritestoredprocedures,bothfunctionsandthenewPostgreSQL11procedures,andcreatetriggerstoperformencapsulationandmaintaindataconsistency.Youwillalsolearnhowtoproduceextensions,theeasiestwaytopackageyourprogramsforeasyandsoliddeploymentondifferentPostgreSQLinstallations.

目錄(189章)

倒序

coverpage
Title Page
Dedication
About Packt
Why subscribe?
Packt.com
Contributors
About the author
About the reviewers
Packt is searching for authors like you
Preface
Who this book is for
What this book covers
To get the most out of this book
Download the example code files
Conventions used
Get in touch
Reviews
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
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
The PL/pgSQL Language
An 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
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
A tag insertion function
Compile 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
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
Implementing a PL/Java function without a deployment descriptor
Implementing a PL/Java function with a deployment descriptor
Summary
References
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
The trigger function
A 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
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
Using a rule to route tuples
When to use rules and when to use triggers
Summary
References
Extensions
Extensions
The control file
The script file
Relocatable extensions
Extension management
Creating and removing extensions
Which extensions are installed?
Creating your own extension
Starting from scratch
Creating an improved version
Installing all the preceding versions
Extension data and backups
Adding an object to an existing extension
The PostgreSQL Extension Network (PGXN)
The extension ecosystem
Getting an extension from the search website
The PGXN Client
Summary
References
Inter Process Communication and Background Workers
Inter-Process Communication (IPC)
Asynchronous events
Limitations of events
A single process example
Event special functions
Channels and event queues
An example of IPC between two database backends
An example of IPC between different applications
Background Workers
Implementing a Background Worker
An example implementation of a Background Worker
The module entry point
Background Worker Main Function
Module Signal Handlers
Deploying and starting the Background Worker
Signaling the Background Worker
Summary
References
Custom Data Types
Custom data types
Enumerations
Creating an enumeration
Type safety
Adding values to an existing enumeration
Where is my enumeration?
Changing an existing label
Composite types
Creating a composite type
Adding or removing attributes to composite types
Type safety
Where is my composite type?
Basic types
Basic type example – image resolution
Defining the textual representation
Defining the basic type and helper functions
Defining the input and output functions
The Makefile
Creating the glue code
Summary
References
Other Books You May Enjoy
Leave a review - let other readers know what you think 更新時間：2021-06-10 19:23:32

官术网_书友最值得收藏!

PostgreSQL 11 Server Side Programming Quick Start Guide