Leanpub Header

Skip to main content

Filters

Category: "PostgreSQL"

Books

  1. The Entity Framework Core & PostgreSQL Handbook
    The Entity Framework Core & PostgreSQL Handbook
    Mastering EF Core 10 with PostgreSQL 18 for Production-Grade Applications
    Rachid DAHIR

    Your ORM works until it doesn't: a query returns ten thousand duplicated rows, a migration refuses a partitioned table, or the feature the product needs is one PostgreSQL has had for years. Twenty-one chapters that close the gap — LINQ translation, query plans, JSONB, full-text search, PostGIS and pgvector, then auditing, multi-tenancy and deployment. Every listing run against a live database. Every output captured, never typed.

  2. The PostgreSQL Administrator's Handbook
    The PostgreSQL Administrator's Handbook
    Architecture, Operations, and Performance Tuning for Production Systems
    Steve Publications

    Master PostgreSQL administration with a practical guide to deploying, securing, optimizing, and operating production databases. Covering PostgreSQL 17 and 18, this book combines real-world examples, hands-on labs, and proven best practices for reliable, high-performance systems.

  3. Building Mobile Apps with Claude Code in 2026
    Building Mobile Apps with Claude Code in 2026
    A Complete Guide for Vibe-Coders: From Zero to App Store
    Muhammad Sohaib Roomi

    Build four real mobile apps from scratch — no coding experience required. Claude Code handles the code. You handle the idea.

  4. Analytics Patterns for Intelligent Decision Systems
    Analytics Patterns for Intelligent Decision Systems
    SQL, Forecasting, Recommendation Engines, Optimization, KPI Systems, and AI-Assisted Analytics
    Kevin Languedoc

    Analytics Patterns for Intelligent Decision Systems shows how to move beyond dashboards into analytics systems that explain, predict, recommend, optimize, and improve business outcomes.Packed with SQL patterns, KPI frameworks, forecasting models, recommendation logic, and decision intelligence templates, this book gives data professionals a practical blueprint for modern analytics.Build systems that do more than report the past — build systems that help decide what should happen next.

  5. PostgreSQL 18 Cookbook, Third Edition
    PostgreSQL 18 Cookbook, Third Edition
    Upgrade to PostgreSQL 18 with ready troubleshooting across replication, partitioning, security, cloud provisioning, backup, and migration
    GitforGits | Asian Publishing House

    This book is for anyone who wants to feel more confident. Over eleven chapters, we put together a single sample application, and we watch it grow from a simple table used by one employee into a more complex system that's divided into different parts, has backups, is secure using OAuth, and is audited.

  6. Data Analytics Foundations
    Data Analytics Foundations
    From First Question to Trusted Insight: The Analyst's Complete Guide to Thinking, Tools, and Communication
    fru kingsly

    Most analytics books teach tools first and thinking later. Data Analytics Foundations reverses that order — building the judgment, technical skills, and communication discipline required to transform raw data into trusted decisions. From spreadsheets and SQL to data quality, visualization, and analytical reasoning, this book equips readers with a complete foundation for professional analytical practice.

  7. PostgreSQL From MVCC to Production

    Postgres woke you up at three in the morning. Same code. Same hardware. Something changed. This book explains what changed and why, starting from the one idea that makes everything else legible: MVCC.

  8. Hibernate Spring Data JPA in Depth

    Most developers treat Hibernate as a black box that turns objects into rows. This book opens the box, shows you exactly what happens inside, and teaches you how to make it work for you at scale.

  9. Django 6 Cookbook, Second Edition
    Django 6 Cookbook, Second Edition
    Build modern full-stack apps with Django 6, Python 3.12, APIs, authentication, testing, search, and deployment
    GitforGits | Asian Publishing House

    The recipes in this book are practical answers to the kind of problems that real Django applications encounter, sometimes on the first day of a project and sometimes deep into the life of a codebase that has grown well beyond its original design. This book is written to guide you to utilize Django 6.0 capabilities in your apps with ease of implementation.

  10. PostgreSQL for the Senior .NET Architect
    PostgreSQL for the Senior .NET Architect
    Production-Grade Architecture & Performance Engineering
    Afandy

    Go beyond basic CRUD. Bridge the gap between .NET abstractions and PostgreSQL internals to architect resilient, high-scale enterprise systems that handle 10k+ TPS.

  11. PostgreSQL Internals Mastery: A Comprehensive Guide
    PostgreSQL Internals Mastery: A Comprehensive Guide
    Volume I: Foundations & Core Concepts
    Giovanni Martinez

    "It’s 3 AM, your database just hit 500 connections, and everything has ground to a halt. Do you know why?"Most database outages aren't mysterious—they are architectural. Stop treating PostgreSQL as a black box and start understanding the mechanical "why" behind the engine. PostgreSQL Internals Mastery: Volume I is a modular deep dive designed for senior engineers who need to bridge the gap between writing SQL and architecting high-performance systems. From the process-per-connection model to the groundbreaking Asynchronous I/O (AIO) features of PostgreSQL 18, learn the internals that separate database architects from administrators. Don't just tune knobs; understand the machine.

  12. Thinking in PostgreSQL
    Thinking in PostgreSQL
    A field guide to PostgreSQL for MySQL engineers
    Nick Vyzas

    Stop treating PostgreSQL like slightly broken MySQL and start using it the way it was designed.

  13. Deep dive into a SQL query
    Deep dive into a SQL query
    A Journey Through PostgreSQL's Query Processing
    Jesús Espino

    What really happens when PostgreSQL executes your query? Follow a SQL statement through every stage of PostgreSQL's internal pipeline—from raw text to returned results—and gain the deep understanding that transforms how you write, tune, and debug database applications.

  14. Creating AI Agents with MCP - Model Context Protocol
    Creating AI Agents with MCP - Model Context Protocol
    Part of the series, "The Only Book You'll Need On..."
    Lydia Evelyn and Bruce Hopkins

    Get started quickly, creating applications for the Model Context Protocol (MCP) using the official MCP SDKs for Python, Java 21, and Node.js. Quickly master, all of the concepts needed in order to build MCP servers, including transport protocols, tools, resources, prompts, roots, and sampling. Learn how to get familiar with popular MCP client applications such as, Claude Desktop, Postman, and the MCP Inspector.

  15. Modern Web Apps using Rust
    Modern Web Apps using Rust
    Build full-stack applications using Rust-based Leptos framework, GraphQL, WebAssembly, and cloud-native deployment
    GitforGits | Asian Publishing House

    In this book, you and I will build a sample book-selling application that evolves as you progress. You'll start by setting up Rust, Cargo, and Leptos in VS Code, compiling your first WebAssembly bundle, and watching "Hello, LibroCommerce!" light up your browser. You'll design a microservice-inspired architecture, model data with Serde-annotated structs, implement CRUD operations, secure every endpoint, then broadcast channels, and finally you get to write Playwright end-to-end tests that spin up headless browsers, place orders, and assert live status updates, all inside your continuous integration pipeline.