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.
Table of Contents
- Transactional, Analytical and AI business systems and their database requirements
- The evolution of Postgres to become the number one database for modern applications
- A sample eCommerce application
- Database requirements for high volume transactional applications
- Transactions, ACID compliance, and data normalization
- Functions and Stored Procedures
- Designing for high transaction volumes and writing efficient transactional code
- Doing more with Postgres for transactional applications
- Database requirements for analytical use cases
- Data modeling for analytics
- Analytics functions in Postgres
- Views, Materialized Views, Partitions and Indexes
- Full text search
- Doing more with Postgres for analytical applications
- Database requirements for artificial intelligence use cases
(N.B. Please use the Read Sample option to see further chapters)
外文書商品之書封，為出版社提供之樣本。實際出貨商品，以出版社所提供之現有版本為主。部份書籍，因出版社供應狀況特殊，匯率將依實際狀況做調整。
無庫存之商品，在您完成訂單程序之後，將以空運的方式為你下單調貨。為了縮短等待的時間，建議您將外文書與其他商品分開下單，以獲得最快的取貨速度，平均調貨時間為1~2個月。
為了保護您的權益，「三民網路書店」提供會員七日商品鑑賞期(收到商品為起始日)。
若要辦理退貨，請在商品鑑賞期內寄回，且商品必須是全新狀態與完整包裝(商品、附件、發票、隨貨贈品等)否則恕不接受退貨。
