Ibrar Ahmed - PostgreSQL Developer s Guide

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.

I would like to thank my loving parents for everything they did for me. Personal time always belongs to family, and I did this in my personal time, so thanks to my family for all the support. I would also like to thank Mr. Richard Harvey, who encouraged me to write the book, and my early age mentor, Mr. Mahmood Hussain, who helped me a lot at the start of my professional career. It has been a really great experience to work with Amjad Shahzad and 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.

I would like to thank my loving parents, encouraging siblings, friends, colleagues, my caring wife, and adorable daughter for not only bearing with my busy schedule but motivating me as well to get all this done.

I would also like to thank my colleagues, Ibrar Ahmed, for his technical expertise and guidance, and Amjad Shahzad, for his constant moral and technical support.

A thumbs up to Packt Publishing and notably to Richard, Gregory, Azhar, and Samantha. You folks were great mentors and got the best out of us. Undoubtedly a great experience!

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.

I would like to say a special thank you to my parents, who have been my source of inspiration since the start of my career. I would also like to thank my wife for putting up with my late night writing sessions. I would also like to thank Ibrar Ahmed, without whom this book would not have been possible.

Finally, I want to thank the Packt Publishing staff, which includes Richard, Gregory, Azhar, and Samantha for their continuous support.

Daniel Durante is an avid coffee drinker, motorcyclist, and rugby player. He has been programming since he was 12 years old. He has been mostly involved with web development from PHP-to-Golang while using PostgreSQL as his main choice of data storage.

He has worked on text-based browser games that have reached over 1,000,000 players, created bin-packing software for CNC machines, and helped contribute to one of the oldest ORMs of Node.js.

I would like to thank my parents, my brother, and friends who've all put up with my insanity sitting in front of a computer day in and day out. I would not have been here today if it wasn't for their patience, guidance, and love.

Vinit Kumar is an autodidact engineer who cares about writing beautiful code that scales well.

He has a good amount of experience in building social networks, multi-tenant systems, content management systems, and embedded website infrastructure. His main areas of interest are building performant systems, functional programming, and solving problems that really matter.

Vinit is an active member of the free and open source software community and has contributed to many projects, including Node.js, Python, and Django.

Prior to his current position, he worked as an application development consultant and wrote applications for clients all over the world.

Vinit is a full-time developer who builds Socialschools (http://socialschools.nl), which is a safe and secure social network for schools.

These days, he writes a lot of Django code along with frontend work on backbone layers. He also works closely with the mobile team (iOS and Android) to ensure that they get proper APIs and documentation support to get their job done.