Giornate corte, storie lunghe: -50% per 12 mesi

Ascolto illimitato per un anno, a metà prezzo

Attiva Storytel Unlimited a 4,99 € al mese per 12 mesi (poi 9,99 € al mese) e porta con te oltre 400.000 titoli, online o offline. Disdici quando vuoi. Preferisci pagare una volta sola? Risparmia ancora di più con Unlimited Annuale a 49,99 € per un anno.

Attiva ora e risparmia

PLpgSQL Programming Essentials: Definitive Reference for Developers and Engineers

Lingua
Inglese
Formato
Categoria

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

Data di uscita

Ebook: 14 giugno 2025

Libri simili a PLpgSQL Programming Essentials: Definitive Reference for Developers and Engineers

Scegli il piano che fa per te

  • Più di 400.000 titoli

  • Kids Mode (accesso sicuro per bambini)

  • Scarica e ascolta offline

  • Disdici quando vuoi

Il più popolare

Unlimited

Ascolto illimitato. Dove vuoi, quando vuoi.

9.99 € /mese

  • 1 account

  • Ascolto illimitato

  • Disdici quando vuoi

Attiva ora

Unlimited Annuale

Paghi subito 49.99€/anno, l'equivalente di 4.17€/mese, per 1 anno di ascolto illimitato.

89.99 € /anno

12 mesi al prezzo di 5
  • 1 account

  • Ascolto illimitato

  • Disdici quando vuoi

Attiva ora

Unlimited Family

Risparmia con più account. Ognuno con le proprie storie.

14.99 € /mese

  • 2 account

  • Ascolto illimitato

  • Disdici quando vuoi

Prova gratis per 14 giorni

Basic

Le tue prime storie, al prezzo più basso.

6.49 € /mese

  • 1 account

  • 10 ore/mese

  • Disdici quando vuoi

Prova gratis per 7 giorni