April 2026
Intermediate to advanced
580 pages
14h 12m
English
Overview
Developing intelligent applications that integrate AI, analytics, and transactional capabilities using the latest release of the world's most popular open-source database
Key Features
- Practical examples demonstrating how to use PostgreSQL to develop intelligent applications
- Best practices for developers of intelligent data management applications
- Includes the latest PostgreSQL 18 features for AI, analytics, and transactions.
Book Description
In today’s data-first world, businesses need applications that blend transactions, analytics, and AI to power real-time insights at scale. Mastering PostgreSQL 18 for AI-Powered Enterprise Apps is your essential guide to building intelligent, high-performance systems with the latest features of PostgreSQL 18.
Through hands-on examples and expert guidance, you’ll learn to design architectures that unite OLTP and OLAP, embed AI directly into apps, and optimize for speed, scalability, and reliability. Discover how to apply cutting-edge PostgreSQL tools for real-time decisions, predictive analytics, and automation. Go beyond basics with advanced strategies trusted by industry leaders. Whether you’re building data-rich applications, internal analytics platforms, or AI-driven services, this book equips you with the patterns and insights to deliver enterprise-grade innovation.
Ideal for developers, architects, and tech leads driving digital transformation, this book empowers you to lead the future of intelligent applications. Harness the power of PostgreSQL 18—and unlock the full potential of your data.
What you will learn
- How to leverage PostgreSQL 18 for building intelligent data-driven applications for the modern enterprise
- Data management principles and best practices for managing transactions, analytics, and AI use cases
- How to utilize PostgreSQL capabilities to address architectural challenges and attain optimal performance for each use case
- Methods for utilizing the latest PostgreSQL innovation to create integrated data management applications
- Guidelines on when to use PostgreSQL and when to opt for specialized data management solutions
Who this book is for
This book is for backend developers, data engineers, database engineers, and solution architects who want to build modern applications using PostgreSQL as a unified platform for transactions, analytics, and AI. It is intended for readers with a basic understanding of SQL and relational databases who want to learn how to design high-performance transactional systems, implement analytical workloads, and integrate AI capabilities such as vector search and LLM-based applications within Postgres.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.