Join us on a literary world trip!
Add this book to bookshelf
Grey
Write a new comment Default profile 50px
Grey
Subscribe to read the full book or read the first pages for free!
All characters reduced
Learn PostgreSQL - Use manage and build secure and scalable databases with PostgreSQL 16 - cover

Learn PostgreSQL - Use manage and build secure and scalable databases with PostgreSQL 16

Luca Ferrari, Enrico Pirozzi

Publisher: Packt Publishing

  • 0
  • 0
  • 0

Summary

The latest edition of this PostgreSQL book will help you to start using PostgreSQL from absolute scratch, helping you to quickly understand the internal workings of the database. With a structured approach and practical examples, go on a journey that covers the basics, from SQL statements and how to run server-side programs, to configuring, managing, securing, and optimizing database performance.This new edition will not only help you get to grips with all the recent changes within the PostgreSQL ecosystem but will also dig deeper into concepts like partitioning and replication with a fresh set of examples. The book is also equipped with Docker images for each chapter which makes the learning experience faster and easier. Starting with the absolute basics of databases, the book sails through to advanced concepts like window functions, logging, auditing, extending the database, configuration, partitioning, and replication. It will also help you seamlessly migrate your existing database system to PostgreSQL and contains a dedicated chapter on disaster recovery. Each chapter ends with practice questions to test your learning at regular intervals.By the end of this book, you will be able to install, configure, manage, and develop applications against a PostgreSQL database.
Available since: 10/31/2023.
Print length: 744 pages.

Other books that might interest you

  • A Protest Against Parkinson’s - Hope and Despair - cover

    A Protest Against Parkinson’s -...

    Lucas S Kanigan

    • 0
    • 0
    • 0
    Parkinson’s disease (PD) is more than a medical condition, it is a rapidly growing global health crisis. Since 1990, the number of diagnosed cases has increased by about 118%, while deaths have risen by roughly 150%. By 2040, more than 20 million people worldwide are expected to be living with Parkinson’s. Despite these alarming trends, many patients feel that current treatments offer limited long-term hope. 
    In A Protest Against Parkinson’s, the author, himself living with Parkinson’s, offers a candid and deeply personal account of the disease. Drawing on both personal experience and extensive research, he describes the physical and psychological realities of Parkinson’s in a way rarely addressed in traditional medical texts. The book explores the frustrations surrounding levodopa, the long-standing “gold standard” treatment. While levodopa can provide significant short-term symptom relief, many patients experience diminishing benefits over time along with difficult side effects. 
    The book argues that the early success of levodopa may have unintentionally slowed the search for more fundamental solutions. For decades, research focused largely on improving dopamine replacement rather than finding ways to slow, stop, or reverse the disease itself. 
    Yet the book is not merely critical, it is also hopeful. The author examines emerging research and alternative approaches that may help slow the progression of Parkinson’s. These include exercise, carefully selected supplements, lifestyle changes, and strategies that may allow patients to delay or complement traditional medications. While these approaches are not cures, they may help some patients improve symptoms and extend quality of life. 
    Ultimately, the book is both a personal testimony and a call to action. It challenges common assumptions about Parkinson’s and encourages patients to remain proactive, informed, and hopeful while the search for a true cure continues.
    Show book
  • The Hidden World of the Fox - cover

    The Hidden World of the Fox

    Adele Brand

    • 0
    • 0
    • 0
    Ecologist Adele Brand has devoted her life to understanding the fabled yet enigmatic fox. Now she reveals their secrets in this extraordinary portrait of our most remarkable wild neighbors. 
     
    The fox. For thousands of years myth and folklore have celebrated its cunning intelligence. Today the red fox is the nature’s most populous carnivore, its dancing orange tail a common sight in backyards. Yet who is this wild neighbor, truly? How do we negotiate this uneasy new chapter of an ancient relationship? Join British ecologist Adele Brand on a journey to discover the surprising secrets of the fabled fox, the familiar yet enigmatic creature that has adapted to the human world with astonishing—some say, unsettling—success. 
    Brand has studied foxes for twenty years across four continents—from the Yucatán rainforest to India’s remote Thar Desert, from subarctic Canada to metropolitan London. Her observations have convinced her that the fox is arguably the most modern of all wildlife, uniquely suited to survival in the rapidly expanding urban/wild interface. Blending cutting-edge science, cultural anthropology, and intimate personal storytelling drawn from her own remarkable fieldwork, The Hidden World of the Fox is Brand’s rich and revelatory portrait of the extraordinary animal she has devoted her life to understanding. 
    Show book
  • Geopolitics Energy Transition Critical Materials 2023 - cover

    Geopolitics Energy Transition...

    International Renewable Energy...

    • 0
    • 0
    • 0
    Geopolitics of the energy transition: Critical materials provides comprehensive insights into the significance of critical materials, examining their associated geopolitical implications and offering recommendations for a sustainable and efficient global energy transition.
    Show book
  • Quantum Physics for Beginners - The EPR Paradox the Photoelectric Effect Conservation Laws Perturbation Theory Blackbody Radiation the Double-Slit Experiment Electromagnetism and Much More - cover

    Quantum Physics for Beginners -...

    Oliver Graves

    • 0
    • 0
    • 0
    What if everything you thought you knew about reality… was incomplete? 
    How can a particle be in two places at once? Why does simply observing something change its behavior? And how can two objects be “connected” across vast distances with no visible link? 
    This audiobook breaks down the mind-bending logic of quantum mechanics into something even complete beginners can follow — without dumbing it down. With engaging, bite-sized chapters, it brings you inside the bizarre but beautiful logic that shapes the tiniest parts of our universe… and influences far more than you might think. 
    You’ll finally understand concepts like entanglement, the photoelectric effect, and quantum uncertainty — but more importantly, you’ll discover how these ideas connect to technology, philosophy, and even the human body. 
    You’ll learn:Why the double-slit experiment is the weirdest and most important experiment in physicsHow observation can change reality, and what that really meansWhat Einstein got right — and wrong — about quantum mechanicsWhy energy is quantized, and what that means for atoms and lightHow mathematics became physics’ secret weaponWhat perturbation theory is, and how it helps predict the unpredictableThe surprising role of conservation laws and symmetriesWhat quantum physics tells us about the nature of time and causalityHow technology like lasers, transistors, and MRI depends on quantum principlesWhat modern science says about the human body as a quantum system 
    Forget lifeless textbooks. This is science with all the wonder left in.Start listening — and discover the quantum side of reality you were never taught in school.
    Show book
  • Journey Through the Wilderness: Embracing Nature's Solitude - "Immerse in Nature: Access Captivating Audio Lessons for an Unforgettable Wilderness Journey!" - cover

    Journey Through the Wilderness:...

    Jasper Thornfield

    • 0
    • 0
    • 0
    Journey Through the Wilderness: Embracing Nature's Solitude 
    ⭐⭐ Simplified Audio Guide ⭐⭐ 
    Are you looking to find peace, strength, and rediscover yourself through the solitude of nature? 
    Seeking a comprehensive guide that provides all necessary elements to embrace the wilderness? 
    Your search ends here! 
    This guide serves as your definitive companion for deepening your connection with nature, applying your skills for survival, and engaging in hands-on exercises. With this, you're geared for a transformative journey. 
    Here's what you'll find inside: 
    - Profound insights about embracing nature's solitude 
    - Detailed explanation of the emotional and mental benefits of nature 
    - Fruitful strategies for adapting to and thriving in the wilderness 
    Our guide distinguishes itself through comprehensive coverage, essential for your journey. Concepts aren't merely skimmed; they are delved into with precision. 
    Please note that this guide is not affiliated with any official entity and is purely an independent resource for your benefit. 
    Designed with a clear structure and easy-to-understand language, our Wilderness Guide ensures smooth transitions between topics. Say goodbye to dense jargon and welcome clear, precise, and genuinely human-written content. 
    So, why wait? Click the BUY NOW button, secure your guide, and begin your journey to rediscovering peace, strength, and self in the wilderness!
    Show book
  • Deep Solfeggio Tones - Music-Free Frequencies for Restorative Sleep Meditative Calm and Nervous System Relaxation Overnight 417 Hz & 523 HZ Resonance for Grounding Balance and Transformation - cover

    Deep Solfeggio Tones -...

    Jonas Reed

    • 0
    • 0
    • 0
    Experience profound healing and holistic balance with Deep Solfeggio Tones — a pure, music-free collection of sacred frequencies designed to harmonize the mind, rejuvenate the body, and restore natural energy flow. 
    This collection includes a 2-hour session to promote deep relaxation and mental clarity, along with an 8-hour overnight session crafted to align your body’s energy centers and support the restoration of physical and emotional equilibrium. Each track features precisely tuned Solfeggio frequencies, known for their ability to resonate with the body’s natural rhythms and promote mental calmness, nervous system balance, and overall well-being — all without background music, nature sounds, or distracting vocals. 
    Whether you face chronic stress, mental fatigue, or imbalance, Deep Solfeggio Tones is designed to nurture your body’s innate healing processes. Simply put on your headphones, relax, and let the pure frequencies guide you toward restored harmony, enhanced vitality, and deep physical and mental renewal. 
    These Solfeggio tones help facilitate:Restoration of mental and emotional balanceActivation of the parasympathetic nervous system for stress reliefSupport for healthy energy flow and chakra alignmentEnhanced physical recovery and immune system supportA tranquil, music-free environment ideal for meditation and sensitive listeners 
    Perfect for daily relaxation, meditation, or overnight healing, Deep Solfeggio Tones is your sound sanctuary for total mind-body restoration. 
    No music. No mantras. Restful Relaxation.
    Show book