Listen and read

Step into an infinite world of stories

  • Read and listen as much as you want
  • Over 1 million titles
  • Exclusive titles + Storytel Originals
  • 7 days free trial, then €9.99/month
  • Easy to cancel anytime
Subscribe 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. Mais esperto que o diabo: O mistério revelado da liberdade e do sucesso
    Mais esperto que o diabo: O mistério revelado da liberdade e do sucessoNapoleon Hill
    4.7
  3. The 48 Laws of Power
    The 48 Laws of PowerRobert Greene
    4.2
  4. Атомные привычки. Как приобрести хорошие привычки и избавиться от плохих: Простой и надежный способ избавиться от плохих привычек и завести хорошие
    Атомные привычки. Как приобрести хорошие привычки и избавиться от плохих: Простой и надежный способ избавиться от плохих привычек и завести хорошиеДжеймс Клир
    4.3
  5. Dışa Bakan Rüya Görür İçe Bakan Uyanır - Carl Gustav Jung
    Dışa Bakan Rüya Görür İçe Bakan Uyanır - Carl Gustav JungCarl Gustav Jung, Özlem Küskü
    4.6
  6. The Untethered Soul: The Journey Beyond Yourself
    The Untethered Soul: The Journey Beyond YourselfMichael A. Singer
    4.6
  7. Can’t Hurt Me - Summarized for Busy People: Master Your Mind and Defy the Odds: Based on the Book by David Goggins
    Can’t Hurt Me - Summarized for Busy People: Master Your Mind and Defy the Odds: Based on the Book by David GogginsDavid Goggins
    4.2
  8. Поправителен за родители: Неверните вярвания за възпитанието
    Поправителен за родители: Неверните вярвания за възпитаниетоМадлен Алгафари
    4.9
  9. İnsanın Anlam Arayışı
    İnsanın Anlam ArayışıViktor E. Frankl
    4.5
  10. İnsan Olmak
    İnsan OlmakEngin Geçtan
    4.7
  11. Why Has Nobody Told Me This Before?
    Why Has Nobody Told Me This Before?Julie Smith
    4.4
  12. Tanrılar Okulu
    Tanrılar OkuluStefano D'Anna
    4.3
  13. All About Love: New Visions
    All About Love: New Visionsbell hooks
    4
  14. Philosophy of Science: A Very Short Introduction, 2nd Edition
    Philosophy of Science: A Very Short Introduction, 2nd EditionSamir Okasha
    4.3
  15. The Secret
    The SecretRhonda Byrne
    4.3
  16. What Every BODY is Saying: An Ex-FBI Agent’s Guide to Speed-Reading People
    What Every BODY is Saying: An Ex-FBI Agent’s Guide to Speed-Reading PeopleJoe Navarro, Marvin Karlins
    4.3
  17. The Handmaid's Tale by Margaret Atwood (Book Analysis): Detailed Summary, Analysis and Reading Guide
    The Handmaid's Tale by Margaret Atwood (Book Analysis): Detailed Summary, Analysis and Reading GuideBright Summaries
    4
  18. 101 Essays That Will Change The Way You Think
    101 Essays That Will Change The Way You ThinkBrianna Wiest
    4.3
  19. The Art of Impossible: A Peak Performance Primer
    The Art of Impossible: A Peak Performance PrimerSteven Kotler
    4.6
  20. Kız Neşesi
    Kız NeşesiBuket Uzuner
    4
  21. Wolf
    WolfLara Taveirne
    4.4
  22. Не верь всему, что чувствуешь. Как тревога и депрессия заставляют нас поверить тому, чего нет
    Не верь всему, что чувствуешь. Как тревога и депрессия заставляют нас поверить тому, чего нетРоберт Лихи
    5
  23. Live More Think Less
    Live More Think LessPia Callesen
    4.3
  24. Ulusların Düşüşü
    Ulusların DüşüşüJames Robinson, Daron Acemoğlu
    4.6
  25. Harry Potter: A History of Magic: The eBook of the Exhibition
    Harry Potter: A History of Magic: The eBook of the ExhibitionBritish Library
    4.2

This is why you’ll love Storytel

  • Listen and read without limits

  • 800 000+ stories in 40 languages

  • Kids Mode (child-safe environment)

  • Cancel anytime

Unlimited stories, anytime

Unlimited

Listen and read as much as you want

9.99 € /month

Save 50%!
  • 1 account

  • Unlimited Access

  • Offline Mode

  • Kids Mode

  • Cancel anytime

Get 50% off now