Book Image

PostgreSQL Developer's Guide

By : Ibrar Ahmed, Asif Fayyaz, Amjad Shahzad
Book Image

PostgreSQL Developer's Guide

By: Ibrar Ahmed, Asif Fayyaz, Amjad Shahzad

Overview of this book

<p>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.</p> <p>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.</p>
Table of Contents (19 chapters)
PostgreSQL Developer's Guide
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

About the Reviewers

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.

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.

He also helps his team write good maintainable code by doing code reviews and following good practices such as Git, documentation, and tooling.

Jean Lazarou started spending time with computers at the age of 15.

He has worked in various sectors, such as the medical industry, the manufacturing industry, university education, and the multimedia world.

He mainly uses Basic, C/C++, Java, and Ruby to develop fat clients, web applications, frameworks, tools, and compilers, often involving databases.

He has published his personal works on GitHub and some technical articles on his blog.

Ľuboš Medovarský is an entrepreneur and open source C/C++, Pascal, Python, and Java software developer with experience in GNU/Linux and OpenBSD administration, configuration management, monitoring, networking, firewalls, and embedded systems.

Discontented with today's fragmented and broken state of home automation and the Internet of Things, he has developed hardware and software for the Whistler automation smart house project, which aims to disrupt the market with platform unification, privacy by design, device autonomy, built-in artificial intelligence, and security – all in open source packages and affordable for the masses. Accelera Networks s.r.o., the company he founded in 2006, develops custom software and hardware applications as well as provides IT management services. Previously, he was employed with Alcatel, Hewlett-Packard, AT&T, Erste Group, and a handful of smaller companies. When he's not at work, the trekkie inside him dreams of space colonization and the technological advancement of humanity. His favorite outdoor activities include biking and flying in a glider.