Dengarkan dan baca

Masuki dunia cerita tanpa batas

  • Baca dan dengarkan sebanyak yang Anda mau
  • Lebih dari 1 juta judul
  • Judul eksklusif + Storytel Original
  • Uji coba gratis 14 hari, lalu €9,99/bulan
  • Mudah untuk membatalkan kapan saja
Coba gratis
Cover for PLpgSQL Programming Essentials: Definitive Reference for Developers and Engineers

PLpgSQL Programming Essentials: Definitive Reference for Developers and Engineers

Bahasa
Inggris
Format
Kategori

Non Fiksi

"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 (E-book): 6610000874422

Tanggal rilis

E-book: 14 Juni 2025

Buku yang mirip dengan PLpgSQL Programming Essentials: Definitive Reference for Developers and Engineers

  1. The 48 Laws of Power
    The 48 Laws of PowerRobert Greene
    4.2
  2. Filsafat Untuk Pemalas
    Filsafat Untuk PemalasAch. Dhofir Zuhry
    5
  3. Dark Psychology: How To Analyze People and Make Them Do Whatever You Want Without Them Noticing!
    Dark Psychology: How To Analyze People and Make Them Do Whatever You Want Without Them Noticing!David Spark
    4.4
  4. The Secret
    The SecretRhonda Byrne
    4.3
  5. Menyedekahkan Perasaan: Sebuah Perjalanan Menuju Dewasa
    Menyedekahkan Perasaan: Sebuah Perjalanan Menuju Dewasa@Keretapengantarpesan
  6. Cara Menganalisis Orang dengan Psikologi Gelap: Pelajari Cara Menguasai Psikologi Gelap dan Manipulasi Terlarang
    Cara Menganalisis Orang dengan Psikologi Gelap: Pelajari Cara Menguasai Psikologi Gelap dan Manipulasi TerlarangChristopher Rothchester
  7. The Moral Landscape: How Science Can Determine Human Values
    The Moral Landscape: How Science Can Determine Human ValuesSam Harris
    4.2
  8. Astrophysics for People in a Hurry
    Astrophysics for People in a HurryNeil deGrasse Tyson
    4.3
  9. On Memory and Reminiscence
    On Memory and ReminiscenceAristotle
    4
  10. Self-Compassion: The Proven Power of Being Kind to Yourself
    Self-Compassion: The Proven Power of Being Kind to YourselfKristin Neff
    4.5
  11. Homo Deus: A Brief History of Tomorrow
    Homo Deus: A Brief History of TomorrowYuval Noah Harari
    4.5
  12. The Boy, the Mole, the Fox and the Horse
    The Boy, the Mole, the Fox and the HorseCharlie Mackesy
    4.6
  13. Psychological Triggers: Human Nature, Irrationality, and Why We Do What We Do. The Hidden Influences Behind Our Actions, Thoughts, and Behaviors.
    Psychological Triggers: Human Nature, Irrationality, and Why We Do What We Do. The Hidden Influences Behind Our Actions, Thoughts, and Behaviors.Peter Hollins
    4
  14. Kesaksian lain dari Bagian-bagian Tubuhku
    Kesaksian lain dari Bagian-bagian TubuhkuBudi Setiawan
  15. The Untethered Soul: The Journey Beyond Yourself
    The Untethered Soul: The Journey Beyond YourselfMichael A. Singer
    4.6
  16. Men are From Mars, Women are From Venus
    Men are From Mars, Women are From VenusJohn Gray
    4.2
  17. Fast Food Fix
    Fast Food FixDevin Alexander
    5
  18. Mating in Captivity: Unlocking Erotic Intelligence
    Mating in Captivity: Unlocking Erotic IntelligenceEsther Perel
    5
  19. Child Psychology I: Development in the First Four Years: Understanding the Crucial Early Years of Child Development
    Child Psychology I: Development in the First Four Years: Understanding the Crucial Early Years of Child DevelopmentVilhelm Rasmussen
    3
  20. Почему народ за Сталина
    Почему народ за СталинаЮрий Мухин
  21. Lettera sulla felicità
    Lettera sulla felicitàEpicuro
    4.3
  22. Sick Enough: A Guide to the Medical Complications of Eating Disorders
    Sick Enough: A Guide to the Medical Complications of Eating DisordersJennifer L. Gaudiani, MD
    4.7
  23. The Tenth Man
    The Tenth ManAlex Josey
    2
  24. The Communist Manifesto and Das Kapital
    The Communist Manifesto and Das KapitalKarl Marx, Friedrich Engels, Robert Weick
    5
  25. Cara Berbicara kepada Siapa Saja Tentang Apa Saja, Kapan Saja, di Mana Saja, dan Siapa Saja.
    Cara Berbicara kepada Siapa Saja Tentang Apa Saja, Kapan Saja, di Mana Saja, dan Siapa Saja.Christopher Rothchester

Selalu dengan Storytel

  • Lebih dari 900.000 judul

  • Mode Anak (lingkungan aman untuk anak)

  • Unduh buku untuk akses offline

  • Batalkan kapan saja

Terpopuler

Premium

Bagi yang ingin mendengarkan dan membaca tanpa batas.

Rp39000 /bulan

Diskon 50%
  • 1 akun

  • Akses Tanpa Batas

  • Akses bulanan tanpa batas

  • Batalkan kapan saja

  • Judul dalam bahasa Inggris dan Indonesia

Coba sekarang

Local

Bagi yang hanya ingin mendengarkan dan membaca dalam bahasa lokal.

Rp19900 /bulan

Diskon 50%
  • 1 akun

  • Judul dalam bahasa tertentu

  • Akses tidak terbatas

  • Batalkan kapan saja

  • Judul dalam bahasa Indonesia

Coba sekarang