首頁 > 工業(yè)技術(shù) >
自動化技術(shù)
> PostgreSQL 11 Server Side Programming Quick Start Guide最新章節(jié)目錄
舉報 
會員
PostgreSQL 11 Server Side Programming Quick Start Guide
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
推薦閱讀
- 數(shù)據(jù)展現(xiàn)的藝術(shù)
- JavaScript實例自學手冊
- 網(wǎng)頁編程技術(shù)
- 手把手教你玩轉(zhuǎn)RPA：基于UiPath和Blue Prism
- 西門子S7-200 SMART PLC從入門到精通
- 離散事件系統(tǒng)建模與仿真
- 城市道路交通主動控制技術(shù)
- Windows 7寶典
- Learning C for Arduino
- 變頻器、軟啟動器及PLC實用技術(shù)260問
- 中國戰(zhàn)略性新興產(chǎn)業(yè)研究與發(fā)展·工業(yè)機器人
- Extending Ansible
- 軟件構(gòu)件技術(shù)
- 21天學通Linux嵌入式開發(fā)
- 數(shù)據(jù)要素：全球經(jīng)濟社會發(fā)展的新動力
- 傳感器原理與工程應用
- 系統(tǒng)建模與控制導論
- INSTANT R Starter
- Architectural Patterns
- Geospatial Data Science Quick Start Guide
- Stream Analytics with Microsoft Azure
- Bash Quick Start Guide
- IBM主機技術(shù)一本通
- 一本書讀懂大數(shù)據(jù)（全彩圖解版）
- Mastering Microsoft Dynamics CRM 2016
- DevOps for Salesforce
- 計算機導論與C語言
- 常用算法深入學習實錄
- Photoshop CS3中文版圖像處理與創(chuàng)意設計
- Hands-On Python Natural Language Processing
