Buch, Englisch, 316 Seiten, Paperback, Format (B × H): 178 mm x 254 mm, Gewicht: 634 g
Design Complex Database-Centric Applications with PL/pgSQL
Buch, Englisch, 316 Seiten, Paperback, Format (B × H): 178 mm x 254 mm, Gewicht: 634 g
ISBN: 978-1-4842-9839-8
Verlag: Apress
The unique approach to handling Triggers in PostgreSQL ensures that both functionality and performance are maintained without compromise. You'll gain proficiency in writing inline/anonymous server-side code within the limitations, along with learning essential debugging and profiling techniques. Additionally, the book delves into statistical analysis of PL/PGSQL code and offers valuable knowledge on managing exceptions while writing code blocks.
Finally, you'll explore the installation and configuration of extensions to enhance the performance of stored procedures and functions.
What You'll Learn
- Understand the PL/PGSQL concepts
- Learn to debug, profile, and optimize PL/PGSQL code
- Study linting PL/PGSQL code
- Review transaction management within PL/PGSQL code
- Work with developer friendly features like operators, casts, and aggregators
Who Is This Book For
App developers, database migration consultants, and database administrators.
Zielgruppe
Professional/practitioner
Autoren/Hrsg.
Fachgebiete
Weitere Infos & Material
PART ONE:
Chapter 1: Introduction to PostgreSQL procedural languages
Chapter 2 Introduction to PL/PGSQL
Chapter 3 Introduction to variables
Chapter 4 Variable’s data types
Chapter 5 Dealing with Strings
Chapter 6 Dealing with Numbers
Chapter 7 Dealing with Arrays
Chapter 8 Control Statements
Chapter 9 Expressions
Chapter 10 SQL Execution
PART TWO:
Chapter 11 Writing FUNCTIONS/PROCEDURES
Chapter 12 Defining own OPERATORS
Chapter 13 Writing own Casting
Chapter 14 Aggregators
Chapter 15 Handling Exceptions
Chapter 16 Triggers
Chapter 17 Writing anonymous code blocks
Chapter 18 Return Values
Chapter 19 Parameters
Chapter 20 CURSORS
PART THREE:
Chapter 21 PL/PGSQL essential extensions
Chapter 22 plpgsql_check extension
Chapter 23 orafce extension
Chapter 24 pldbgapi extension
Chapter 25 plprofiler extension