|
|
|
|
| LEADER |
02320nmm a2200313 u 4500 |
| 001 |
EB002184191 |
| 003 |
EBX01000000000000001321678 |
| 005 |
00000000000000.0 |
| 007 |
cr||||||||||||||||||||| |
| 008 |
231103 ||| eng |
| 020 |
|
|
|a 9781484298404
|
| 100 |
1 |
|
|a Shaik, Baji
|
| 245 |
0 |
0 |
|a Procedural Programming with PostgreSQL PL/pgSQL
|h Elektronische Ressource
|b Design Complex Database-Centric Applications with PL/pgSQL
|c by Baji Shaik, Dinesh Kumar Chemuduru
|
| 250 |
|
|
|a 1st ed. 2023
|
| 260 |
|
|
|a Berkeley, CA
|b Apress
|c 2023, 2023
|
| 300 |
|
|
|a XIX, 316 p. 12 illus
|b online resource
|
| 653 |
|
|
|a Open source software
|
| 653 |
|
|
|a Database Management System
|
| 653 |
|
|
|a Programming languages (Electronic computers)
|
| 653 |
|
|
|a Database management
|
| 653 |
|
|
|a Programming Language
|
| 653 |
|
|
|a Open Source
|
| 700 |
1 |
|
|a Chemuduru, Dinesh Kumar
|e [author]
|
| 041 |
0 |
7 |
|a eng
|2 ISO 639-2
|
| 989 |
|
|
|b Springer
|a Springer eBooks 2005-
|
| 028 |
5 |
0 |
|a 10.1007/978-1-4842-9840-4
|
| 856 |
4 |
0 |
|u https://doi.org/10.1007/978-1-4842-9840-4?nosfx=y
|x Verlag
|3 Volltext
|
| 082 |
0 |
|
|a 005.13
|
| 520 |
|
|
|a Learn the fundamentals of PL/PGSQL, the programming language of PostgreSQL which is most robust Open Source Relational Database. This book provides practical insights into developing database code objects such as functions and procedures, with a focus on effectively handling strings, numbers, and arrays to achieve desired outcomes, and transaction management. 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. You will: 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
|