Listen and read

Step into an infinite world of stories

  • Read and listen as much as you want
  • Over 950 000 titles
  • Exclusive titles + Storytel Originals
  • Easy to cancel anytime
Try now
Cover for PLpgSQL Programming Essentials: Definitive Reference for Developers and Engineers

PLpgSQL Programming Essentials: Definitive Reference for Developers and Engineers

Language
English
Format
Category

Non-Fiction

"PLpgSQL Programming Essentials"

Master the art and science of PostgreSQL's procedural language with "PLpgSQL Programming Essentials," a comprehensive technical guide designed for database developers, architects, and DevOps engineers. This book delivers a meticulous exploration of PLpgSQL, beginning with its historical context and deep-diving into the language’s architectural foundations, internals of compilation and execution, robust data typing, and error diagnostics. Readers will gain a solid grounding in essential language constructs—such as block structures, function and procedure syntax, and sophisticated error handling—while also learning how to design maintainable, high-performance code through practical, real-world examples.

Navigating beyond the basics, the guide covers advanced procedural control flows, dynamic SQL construction, metaprogramming, and the manipulation of complex data structures including arrays, composites, and JSONB. Special emphasis is placed on event-driven programming with triggers and rules, optimization techniques, robust debugging, and best practices for profiling and code quality. In addition, "PLpgSQL Programming Essentials" demystifies DevOps integration, from automated testing and CI/CD pipelines to versioning and database migrations, preparing practitioners to achieve continuous delivery and operational resilience.

The journey culminates with essential topics in security, high-availability, and extensibility, emphasizing safe privilege configurations, audit compliance, and protection for sensitive data. Readers will also discover how to scale PLpgSQL routines in modern distributed, cloud-native architectures and leverage powerful integration patterns with external systems, extensions, and community frameworks. Whether modernizing legacy code or building mission-critical systems, this book is your all-in-one blueprint for harnessing the full spectrum of PLpgSQL’s capabilities in today’s PostgreSQL ecosystems.

© 2025 HiTeX Press (Ebook): 6610000874422

Release date

Ebook: 14 June 2025

Books similar to PLpgSQL Programming Essentials: Definitive Reference for Developers and Engineers

  1. The 48 Laws of Power
    The 48 Laws of PowerRobert Greene
    4.2
  2. This Is What Inequality Looks Like
    This Is What Inequality Looks LikeTeo You Yenn
    4.6
  3. Fundamental Aspects of Palliative Care Nursing 2nd Edition
    Fundamental Aspects of Palliative Care Nursing 2nd EditionRobert Becker
    4.3
  4. Fusion: Art and Nature in Ceramic Restorations
    Fusion: Art and Nature in Ceramic RestorationsJean-François Lasserre
  5. The Socratic Dialogues: Early Period: Volume 1: The Apology, Crito, Charmides, Laches, Lysis, Menexenus, Ion
    The Socratic Dialogues: Early Period: Volume 1: The Apology, Crito, Charmides, Laches, Lysis, Menexenus, IonPlato, Benjamin Jowett
    5
  6. The Will to Change: Men, Masculinity, and Love
    The Will to Change: Men, Masculinity, and Lovebell hooks
    4.5
  7. Academic Skills for Interdisciplinary Studies
    Academic Skills for Interdisciplinary Studies
  8. The Art of Thinking Clearly
    The Art of Thinking ClearlyRolf Dobelli
    4.4
  9. De machtscode: Hoe de onzichtbare belangenstrijd achter AI onze democratie bedreigt
    De machtscode: Hoe de onzichtbare belangenstrijd achter AI onze democratie bedreigtMarietje Schaake
    4.4
  10. The Easy Way to Stop Gambling: Take Control of Your Life
    The Easy Way to Stop Gambling: Take Control of Your LifeAllen Carr
    4.8
  11. 101 More Amazing Harry Potter Facts
    101 More Amazing Harry Potter FactsJack Goldstein
    3.9
  12. Elite Capture: How the Powerful Took Over Identity Politics (and Everything Else)
    Elite Capture: How the Powerful Took Over Identity Politics (and Everything Else)Olúfẹ́mi O. Táíwò
    4.2
  13. Speed Read Anything: How to Read a Book a Day With Better Retention Than Ever
    Speed Read Anything: How to Read a Book a Day With Better Retention Than EverPeter Hollins
    4.5
  14. Conspiracy of Fear
    Conspiracy of FearRaphael Terra
  15. Alan Rickman on Jaques: Performing Shakespeare
    Alan Rickman on Jaques: Performing ShakespeareJulian Curry, Alan Rickman
    5
  16. Kopzorgen. Neurodiversiteit begrijpen: in 33 vragen
    Kopzorgen. Neurodiversiteit begrijpen: in 33 vragenJim van Os, Simona Karbouniaris
  17. Where Are Your Boys Tonight?: The Oral History of Emo's Mainstream Explosion 1999-2008
    Where Are Your Boys Tonight?: The Oral History of Emo's Mainstream Explosion 1999-2008Chris Payne
  18. Discovery of India, The
    Discovery of India, TheJawaharlal Nehru
    4.4
  19. Everything Was Forever, Until It Was No More: The Last Soviet Generation
    Everything Was Forever, Until It Was No More: The Last Soviet GenerationAlexei Yurchak
  20. Царь собственной персоной: Как Владимир Путин обманул всех нас
    Царь собственной персоной: Как Владимир Путин обманул всех насРоман Баданин, Михаил Рубин
    5
  21. معلقة لبيد بن ربيعة
    معلقة لبيد بن ربيعةلبيد بن ربيعة
    4
  22. Practical Detection Engineering with Sigma
    Practical Detection Engineering with SigmaWojciech Ciemski
  23. The Art of Living: Peace and Freedom in the Here and Now
    The Art of Living: Peace and Freedom in the Here and NowThich Nhat Hanh
    4.6
  24. Race and Culture: A World View
    Race and Culture: A World ViewThomas Sowell
    4.4
  25. Пять эссе на темы этики
    Пять эссе на темы этикиУмберто Эко

Features:

  • Over 950 000 titles

  • Kids Mode (child safe environment)

  • Download books for offline access

  • Cancel anytime

Unlimited

For those who want to listen and read without limits.

S$12.98 /month

Limited Offer
  • 1 account

  • Unlimited Access

  • Unlimited listening

  • Cancel anytime

Try now

Family

For those who want to share stories with family and friends.

Starting at S$14.90 /month

  • 2-3 accounts

  • Unlimited Access

  • Unlimited listening

  • Cancel anytime

You + 1 family member

2 accounts

S$14.90 /month

Try now
Most popular

Unlimited Yearly

For those who want to listen and read without limits.

S$119 /year

Save 58%
  • 1 account

  • Unlimited Access

  • Unlimited listening

  • Cancel anytime

Try now