Showing results for "PostgreSQL" in All Categories

Author Martin Kleppmann helps you navigate the diverse data landscape by examining the pros and cons of various technologies for processing and storing data. Software keeps changing, but the fundamental principles remain the same. With this book, software engineers and architects will learn how to apply those ideas in practice, and how to make full use of data in modern applications. 

Most real-world applications store their data in databases. Most of their databases are relational. PostgreSQL is one of the most-used relational databases. It is an open source software that you can download from https://www.postgresql.org To access data in a relational database we use SQL (Structured Query Language). If you are new to SQL, and want to use SQL in PostgreSQL, this is the book of choice. It is a practical book, teaching you SQL step-by-step using examples. If you take a glance at the table of contents, you will appreciate the comprehensive coverage of the book. When you ...

Master the world's most advanced open-source relational database — the one powering Apple, Instagram, Spotify, and Supabase — and build AI-powered data systems on top of it, from scratch. PostgreSQL with AI takes you from your very first SQL query through advanced query optimization, window functions, JSONB, full-text search, replication, cloud deployment, and pgvector — and then into integrating modern AI APIs to build semantic search engines, intelligent recommendation systems, and AI-driven data pipelines. Written for the 2026 ecosystem, every chapter is practical, current, and ...

Data engineering has grown rapidly in the past decade, leaving many software engineers, data scientists, and analysts looking for a comprehensive view of this practice. With this practical book, you'll learn how to plan and build systems to serve the needs of your organization and customers by evaluating the best technologies available through the framework of the data engineering lifecycle.

Knowing how to craft SQL queries and navigate your way around a database is an essential skill if are a Database Administrator, System Administrator, or Programmer. This book guides you step-by-step by teaching you how to create databases, populate those databases with data, extract just the data you need, and much more.

If you’ve ever lost an afternoon fixing a broken Excel file, you know the pain. When Mara Delgado opened Rook & Pawn Café, a single spreadsheet handled all her member tracking. It worked perfectly. Then concurrent edits wiped out the renewal records. Next, a comma-separated list ruined her inventory queries. Eventually, a bad formula caused billing errors. In Relational Database Design for Beginners, Jessie Landon shows you how to turn that chaos into a clean, scalable system. You don't need a computer science degree, and you don't need prior coding experience. This guide teaches core ...

"Mastering PostgreSQL with Python: A Comprehensive Guide" is a comprehensive book that provides a deep understanding of PostgreSQL and its integration with Python for building robust and scalable data-driven applications. This book covers a wide range of topics, from the basics of PostgreSQL and Python to advanced features, performance tuning, and security. The book begins with an introduction to relational databases, highlighting the importance of PostgreSQL and Python in modern data-driven applications. It guides readers through the installation and setup process of PostgreSQL and Python,...

If you are a backend developer who has been writing SQL for years but still feels uneasy when a query slows down in production, this book is for you. You already know how to SELECT, JOIN, and GROUP BY. What you do not yet know is what PostgreSQL is doing on the other side of that query, why the planner makes the choices it does, and which common habits are quietly costing you performance, correctness, and sleep. This is not a beginner tutorial. It is not a DBA handbook. It is a practical, no-filler guide written specifically for developers who build real applications on PostgreSQL and want ...

A composite type is a collection of columns. In postgreSQL database you create a composite type using a CREATE TYPE statement. Once created, you can use a composite type the same way as a primitive datatype, for example, as the datatype of a column. In this practical book you will learn how to create, use, and maintain composite type, by examples.

PostgreSQL is an open relational database. In PostgreSQL you can have a query with CUBE clause. A cube is an aggregated row. A query with a CUBE clause returns (generates) a complete set of cubes; complete in the sense that the cubes generated cover all the possible combinations of all columns specified (listed) under the WITH clause. In this book you will learn the WITH clause and usages of cubes, known as OLAP queries.

"PostgreSQL Administration Essentials: From Roles to Replication" is a comprehensive guide designed for database administrators looking to master the art of managing PostgreSQL databases. This book covers a wide range of topics, from setting up and configuring PostgreSQL, to advanced performance tuning, security, and replication strategies. With detailed explanations and practical examples, it provides readers with the knowledge needed to effectively administer PostgreSQL in diverse environments, ensuring high availability, scalability, and optimal performance for any database-driven ...

Ready to move past "Hello World" tutorials and build AI tools that actually do real work? The AI landscape is moving fast, but most resources are either bogged down in heavy academic theory or leave you copy-pasting code you don't understand. In Build Your Own AI Agent FOR BEGINNERS, full-stack developer and AI systems educator Joe Hunter cuts through the noise. This is a no-fluff, no-complex-jargon, step-by-step path designed specifically for total beginners. Instead of building a toy app that breaks the moment you look away, you will build, test, and deploy a robust, real-world AI system ...

Learn the Ansible automation technology with some real-life examples. Every successful IT department needs automation nowadays for bare metal servers, virtual machines, could, containers, and edge computing. Automate your IT journey with Ansible automation technology. I'm going to teach you example by example how to accomplish the most common Dabatse Administrator tasks. Each of the lessons summarizes a module: from the most important parameter to some live demo of code and real-life usage. Each code is battle proved in the real life. Console interaction and verification are included in ...

Every SQL developer eventually hits the same wall: a question that a single SELECT statement simply cannot answer on its own. “Show me every customer whose total orders exceed the average.” “Find the product that sold the most units last month.” “Delete every row that no longer has a matching record in another table.” These questions share a common trait — the answer depends on the result of another query. That is the world of subqueries, and it is the subject of this book. A subquery is, at its simplest, a query (enclosed in parentheses) nested inside another query. But that ...

PostgreSQL logical replication can provide a selective stream of data changes, but what happens when the schema itself changes?James Nelson, Founder and CTO of PgCache, shares his Postgres wishlist: more information about DDL and schema changes in the logical replication stream. For systems that use replication events to keep a cache current, a dropped table can create a serious blind spot when there is no corresponding event to invalidate its cached data.James and JD explore why consuming the binary replication stream is not always a practical alternative, including the volume of cluster-wide...

Most books explain what Retrieval-Augmented Generation is. This one makes you build it. Over six hands-on labs and a capstone project, you grow one code base into an enterprise-grade RAG system on PostgreSQL + pgvector and Groq. Each chapter adds exactly one capability to the same system, so by the last page you own a working stack – and the architectural judgment to defend every decision inside it. What you will have built A private knowledge store on PostgreSQL upgraded into a vector database, with parent-child chunks linked by foreign keys An ingestion pipeline for messy real-world ...

PostgreSQL (Regina O. Obe) - Amazon USA Store: https://www.amazon.com/dp/1491963417?tag=9natree-20 - Amazon Worldwide Store: https://global.buys.trade/PostgreSQL-Regina-O-Obe.html - Apple Books: https://books.apple.com/us/audiobook/sql-for-beginners-learn-the-structured-query-language/id1632258664?itsct=books_box_link&itscg=30200&ls=1&at=1001l3bAw&ct=9natree - eBay: https://www.ebay.com/sch/i.html?_nkw=PostgreSQL+Regina+O+Obe+&mkcid=1&mkrid=711-53200-19255-0&siteid=0&campid=5339060787&customid=9natree&toolid=10001&mkevt=1 - Shopee: https://asia.buys.trade/shopee_PostgreSQL-Regina-O-Obe.html...

Multi-region database architecture is one of the most consequential decisions an engineering team can make — and PostgreSQL logical replication is increasingly the tool teams reach for to get it right. This episode of DEV.co walks through the full picture: how logical replication actually works under the hood, what a sound multi-region topology looks like, and where teams consistently stumble when moving from theory to production. The discussion is grounded in the deep-dive guide on PostgreSQL logical replication for multi-region systems, and goes further by unpacking the practical ...

👉 📥 Continue Reading: PostgreSQL for DBA: PostgreSQL 12 : https://lastoutline.com/post/A-1796506044 Find the premium editorial review as Audio readable copy PostgreSQL for DBA: PostgreSQL 12 by Mr Federico Campoli perfect for checking availability on the digital store. This audiobook is highly recommended. Enjoy insightful storytelling and start discovering right now. Optimized for mobile devices.. Tags: book summary 📌 Check out our visual board: Another Podcast : https://music.amazon.com/podcasts/c738095f-71d4-486a-ba90-761eba05c644

In Part 2 of "When Postgres Is Enough", Michael Cooper and JD examine what it took for AgLedger to trust PostgreSQL with work previously split between PostgreSQL and Valkey.Supporting two databases meant maintaining separate schemas, backups, restores, and state that had to stay coordinated. PostgreSQL did not need to outperform Valkey at every task. It only needed to handle AgLedger’s workload well enough to make the second system unnecessary.Michael explains how pg-boss allowed him to move queue and rate-limiting work into PostgreSQL, and why managing connections became a more important ...