Details zum E-Book

AI-Ready PostgreSQL 18. Building Intelligent Data Systems with Transactions, Analytics, and Vectors

AI-Ready PostgreSQL 18. Building Intelligent Data Systems with Transactions, Analytics, and Vectors

Vibhor Kumar, Marc Linster, Ed Boyajian

Wird geladen...
E-BOOK
Wird geladen...
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.
  • 1. Transactional, Analytical, and AI Business Systems and Their Database Requirements
  • 2. The Evolution of Postgres
  • 3. A Sample E-Commerce Application
  • 4. Database Requirements for High-Volume Transactional Applications
  • 5. Transactions, ACID Compliance, and Data Normalization
  • 6. Functions and Stored Procedures
  • 7. Designing for High Transaction Volumes and Writing Efficient Transactional Code
  • 8. Understanding and Monitoring Transactional Application Performance
  • 9. Database Requirements for Analytical Use Cases
  • 10. The Analytics Data Model
  • 11. Feeding the PostgreSQL Data Warehouse
  • 12. Transforming the Data for Analytics
  • 13. PostgreSQL's Analytics Functions
  • 14. Analyzing Text Documents in PostgreSQL
  • 15. Database Requirements for Artificial Intelligence Use Cases
  • 16. Vectors and Indexing for AI with pgvector
  • 17. Multi-Modal Reasoning: Combining AI Vectors with Standard SQL
  • 18. Step-by-Step Approach to Integrating LLMs with PostgreSQL to Create Complete AI Applications
  • 19. Production-Ready AI Embedding Pipeline Patterns
  • 20. PostgreSQL and MCP: The Blueprint for a Robust AI Assistant
  • 21. Tying It All Together
  • Titel:AI-Ready PostgreSQL 18. Building Intelligent Data Systems with Transactions, Analytics, and Vectors
  • Autor:Vibhor Kumar, Marc Linster, Ed Boyajian
  • Originaler Titel:AI-Ready PostgreSQL 18. Building Intelligent Data Systems with Transactions, Analytics, and Vectors
  • ISBN:9781806028467, 9781806028467
  • Veröffentlichungsdatum:2026-04-14
  • Format:E-Book
  • Artikel-ID: e_4iy4
  • Verleger: Packt Publishing
Wird geladen...
Wird geladen...