- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
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 DescriptionIn 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 forThis 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.
Contents
Table of Contents
Transactional, Analytical, and AI Business Systems and Their Database Requirements
The Evolution of Postgres
A Sample E-Commerce 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
Understanding and Monitoring Transactional Application Performance
Database Requirements for Analytical Use Cases
The Analytics Data Model
Feeding the PostgreSQL Data Warehouse
Transforming the Data for Analytics
PostgreSQL's Analytics Functions
Analyzing Text Documents in PostgreSQL
Database Requirements for Artificial Intelligence Use Cases
Vectors and Indexing for AI with pgvector
Multi-Modal Reasoning: Combining AI Vectors with Standard SQL
Step-by-Step Approach to Integrating LLMs with PostgreSQL to Create Complete AI Applications
Production-Ready AI Embedding Pipeline Patterns
PostgreSQL and MCP: The Blueprint for a Robust AI Assistant
Tying It All Together
-
- 電子書籍
- 京四郎(話売り) #244 少年チャン…
-
- 電子書籍
- 王位継承者の俺は覚醒兆候ゼロの肉体を手…
-
- 電子書籍
- 抱かれたい女～JDだけどアラサー女子に…
-
- 電子書籍
- MONOQLO the MONEY 2…
