What You Will Learn Refresh your knowledge of SQL with PostgreSQL-supported DDL and DML Explore native PostgreSQL procedural languages and learn how to write custom functions Leverage the power of indexes for optimal database efficiency Unfold tricky trigger concepts and implement them in native procedural languages Discover how to implement views, partitioned tables, and window functions in PostgreSQL Design efficient queries with query optimization and query analysis Communicate with PostgreSQL servers using foreign data wrappers such as LibPQ and ECPG Extend database powers using foreign data wrappers and achieve maintainability via PostgreSQL extensions Book Description PostgreSQL is an enterprise-level database that competes among proprietary database vendors, owing to its remarkable feature set and reliability without the expensive licensing overhead. This book is a comprehensive and pragmatic guide to developing databases in PostgreSQL. Beginning with a refresher of basic SQL skills, you will gradually be exposed to advanced concepts, such as learning how to program in native PostgreSQL procedural languages, implementing triggers, custom functions, and views. You will learn database optimization techniques such as query optimization and indexing while exploring extensive code examples. Lastly, you will explore foreign data wrappers, implementing extensibility, and improving maintainability. Authors Ibrar Ahmed Ibrar Ahmed has over 15 years of experience in software development. He is currently working as a software architect for a PostgreSQL-based company. He is an open source evangelist. He has contributed features such as pg_migrator (now called pg_upgrade) and Index Only Scans to PostgreSQL and has contributed to Google Chromium projects such as platform-independent FTP implementations of the Google Chrome browser, Chromium test framework enhancements, and porting of listen_socket and telnet_server to Linux. He has a lot of experience in implementing network protocols and writing Linux kernel modules. Apart from his professional life, he delivers lectures at universities and reads books. Asif Fayyaz Asif Fayyaz is an open source technology lover and practitioner. He is currently working as a senior software quality assurance engineer at a leading PostgreSQL based company. He has been learning and using PostgreSQL for the last 7 years. His areas of interest are exploring PostgreSQL replication solutions and software test automation solutions for desktop, web, and mobile applications. His future endeavors include joining a sports channel for set-top box automation in Python. Apart from his professional activities, he, along with his dedicated friends, is keen to find ways that can make life easier for those who are facing the worst living conditions. His other passions include, but are not limited to, traveling to different places, trying different cuisines, and reading books if somehow permitted by his loving family. Continue reading Amjad Shahzad Amjad Shahzad has been working in the open source software industry for the last 10 years. He is currently working as a senior quality assurance engineer at a leading PostgreSQL-based company, which is the only worldwide provider of enterprise-class products and services based on PostgreSQL. Amjad's core expertise lies in the areas of pg_upgrade, slony and streaming replication, Cloud database, and database partitioning. His future endeavors include exploring PostgreSQL replication solutions. Apart from his professional activities, he is also involved in doing social activities that involve helping people stand on their feet. In his free time, he likes to explore nature by doing outdoor activities, including hiking, trekking, and nature photography. Table of Contents Chapter 1: Getting Started with PostgreSQL Chapter 2: The Procedural Language Chapter 3: Working with Indexes Chapter 4: Triggers, Rules, and Views Chapter 5: Window Functions Chapter 6: Partitioning Chapter 7: Query Optimization Chapter 8: Dealing with Large Objects Chapter 9: Communicating with PostgreSQL Using LibPQ Chapter 10: Embedded SQL in C – ECPG Chapter 11: Foreign Data Wrapper Chapter 12: Extensions