Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
PostgreSQL 11 Server Side Programming Quick Start Guide: Effective database programming and interaction

Buy

Extend PostgreSQL using PostgreSQL server programming to create, test, debug, and optimize a range of user-defined functions in your favorite programming language

Key Features

  • Learn the concepts of PostgreSQL 11 with lots of real-world datasets and examples
  • Learn queries, data replication, and database performance
  • Extend the functionalities of your PostgreSQL instance to suit your organizational needs

Book Description

PostgreSQL is a rock-solid, scalable, and safe enterprise-level relational database. With a broad range of features and stability, it is ever increasing in popularity.This book shows you how to take advantage of PostgreSQL 11 features for server-side programming. Server-side programming enables strong data encapsulation and coherence.

The book begins with the importance of server-side programming and explains the risks of leaving all the checks outside the database. To build your capabilities further, you will learn how to write stored procedures, both functions and the new PostgreSQL 11 procedures, and create triggers to perform encapsulation and maintain data consistency.

You will also learn how to produce extensions, the easiest way to package your programs for easy and solid deployment on different PostgreSQL installations.

What you will learn

  • Explore data encapsulation
  • Write stored procedures in different languages
  • Interact with transactions from within a function
  • Get to grips with triggers and rules
  • Create and manage custom data types
  • Create extensions to package code and data
  • Implement background workers and Inter-Process Communication (IPC)
  • How to deal with foreign languages, in particular Java and Perl

Who this book is for

This book is for database administrators, data engineers, and database engineers who want to implement advanced functionalities and master complex administrative tasks with PostgreSQL 11.

Table of Contents

  1. PostgreSQL Server-side Programming
  2. Statement Tricks: UPSERTs, RETURNING, and CTEs
  3. The PL/pgSQL Language
  4. Stored Procedures
  5. PL/Perl and PL/Java
  6. Triggers
  7. Rules and the Query Rewriting System
  8. Extensions
  9. Inter Process Communications and Background Workers
  10. Custom Data Types
(HTML tags aren't allowed.)

Machine Learning for Mobile: Practical guide to building intelligent mobile applications powered by machine learning
Machine Learning for Mobile: Practical guide to building intelligent mobile applications powered by machine learning

Leverage the power of machine learning on mobiles and build intelligent mobile applications with ease

Key Features

  • Build smart mobile applications for Android and iOS devices
  • Use popular machine learning toolkits such as Core ML and TensorFlow Lite
  • Explore...
Python Penetration Testing Essentials
Python Penetration Testing Essentials

Employ the power of Python to get the best out of pentesting

About This Book

  • Learn to detect and avoid various types of attacks that put the privacy of a system at risk
  • Employ practical approaches to penetration testing using Python to build efficient code and eventually save time
  • ...
Album
Album

This best-selling reader is designed to transition students from reading highly controlled elementary-level materials to appreciating authentic literature. Written primarily in the twentieth century by authors from Spain, Latin America, and the United States, the 31 short stories in ALBUM appear in order of increasing difficulty. Many...


Visual Information Systems (Lecture Notes in Computer Science)
Visual Information Systems (Lecture Notes in Computer Science)
This book is a thoroughly arranged anthology outlining the state of the art in the emerging area of visual informationsystems. The chapters presented are a selection of thoroughly refereed and revised full papers first presented at the First International Conference on visual Information Systems held in February 1996. Next generation information...
iPhone Cool Projects
iPhone Cool Projects
You are going to love this book! I know I do, and I had to read every word of it and check
every line of code, twice!!

If you’re like me, you’ve registered as an iPhone developer with Apple, read some documentation,
and sought help in taking the next bold step. Perhaps you’ve picked up “Beginning...
Time-Dependent Problems and Difference Methods
Time-Dependent Problems and Difference Methods

Praise for the First Edition

". . . fills a considerable gap in the numerical analysis literature by providing a self-contained treatment . . . this is an important work written in a clear style . . . warmly recommended to any graduate student or researcher in the field of the numerical solution of partial...

©2021 LearnIT (support@pdfchm.net) - Privacy Policy