Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Learn the fundamentals of PL/PGSQL, the programming language of PostgreSQL which is most robust Open Source Relational Database. This book provides practical insights into developing database code objects such as functions and procedures, with a focus on effectively handling strings, numbers, and arrays to achieve desired outcomes, and transaction management. The unique approach to handling Triggers in PostgreSQL ensures that both functionality and performance are maintained without compromise. You'll gain proficiency in writing inline/anonymous server-side code within the limitations, along with learning essential debugging and profiling techniques. Additionally, the book delves into statistical analysis of PL/PGSQL code and offers valuable knowledge on managing exceptions while writing code blocks. Finally, you'll explore the installation and configuration of extensions to enhance the performance of stored procedures and functions. You will: Understand the PL/PGSQL concepts Learn to debug, profile, and optimize PL/PGSQL code Study linting PL/PGSQL code Review transaction management within PL/PGSQL code Work with developer friendly features like operators, casts, and aggregators.

Programming --- Computer architecture. Operating systems --- Information systems --- Open Source --- database management --- programmeertalen --- Procedure calls (Computer programming) --- Relational databases. --- PostgreSQL.

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Get started with PostgreSQL on the cloud and discover the advantages, disadvantages, and limitations of the cloud services from Amazon, Rackspace, Google, and Azure. Once you have chosen your cloud service, you will focus on securing it and developing a back-up strategy for your PostgreSQL instance as part of your long-term plan. Beginning PostgreSQL on the Cloud covers other essential topics such as setting up replication and high availability; encrypting your saved cloud data; creating a connection pooler for your database; and monitoring PostgreSQL on the cloud. The book concludes by showing you how to install and configure some of the tools that will help you get started with PostgreSQL on the cloud. This book shows you how database as a service enables you to spread your data across multiple data centers, ensuring that it is always accessible. You’ll discover that this model does not expect you to install and maintain databases yourself because the database service provider does it for you. You no longer have to worry about the scalability and high availability of your database. You will: Migrate PostgreSQL to the cloud Choose the best configuration and specifications of cloud instances Set up a backup strategy that enables point-in-time recovery Use connection pooling and load balancing on cloud environments Monitor database environments on the cloud.

Computer science --- Programming --- Computer architecture. Operating systems --- Information systems --- Computer. Automation --- Open Source --- cloud computing --- computers --- informatica --- programmeren (informatica) --- database management --- programmeertalen --- computerkunde --- Database management. --- Computer programming. --- Open source software. --- Application software. --- Programming languages (Electronic computers). --- Database Management. --- Programming Techniques. --- Open Source. --- Computer Applications. --- Programming Languages, Compilers, Interpreters. --- PostgreSQL.