Choose an application

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

PostgreSQL has become the most advanced open source database on the market. This book adopts a step-by-step approach to meet almost every requirement you can think of while deploying PostgreSQL in production environments. You will not only learn how to design and manage your database but also discover how to administer and secure the database.

SQL (Computer program language) --- Database management. --- Databases --- Design. --- PostgreSQL.

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)

Ce livre vise à fournir au lecteur tous les éléments nécessaires pour mettre en place un système d'information géographique (SIG) fondé sur l'utilisation conjointe de PostgreSQL et de PostGIS. Très détaillé et doté de nombreux exemples, il aidera aussi bien les débutants à se former que les utilisateurs intermédiaires et avancés à affiner leur pratique de l’outil.Organisé de manière thématique, les chapitres peuvent être lus dans n’importe quel ordre. Une première partie permet de se familiariser avec les concepts clés de la cartographie informatique et présente les principaux éléments de l'écosystème PostGIS et son fonctionnement. La deuxième partie passe en revue le traitement des données vecteur : importation, création, stockage mais aussi édition, comparaison, validation, analyse des relations spatiales et gestion des réseaux. La troisième partie explique comment manipuler, interroger et traiter des données raster. Enfin, la dernière partie présente différentes facettes de l'administration d'une base PostgreSQL + PostGIS en production.Le livre a été écrit à partir de la version 15 de PostgreSQL et 3.3.2 de PostGIS.

Système d'information géographique --- Bases de données -- Interrogation --- PostgreSQL (système informatique) --- Bases de données --- Geospatial data. --- Données géospatiales. --- Geographic information systems. --- Système d'information géographique. --- Données géospatiales --- Données géospatiales. --- PostgreSQL (système informatique) --- Système d'information géographique.

Choose an application

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

Obtain all the skills you need to configure and manage a PostgreSQL database. In this book you will begin by installing and configuring PostgreSQL on a server by focusing on system-level parameter settings before installation. You will also look at key post-installation steps to avoid issues in the future. The basic configuration of PostgreSQL is tuned for compatibility rather than performance. Keeping this in mind, you will fine-tune your PostgreSQL parameters based on your environment and application behavior. You will then get tips to improve database monitoring and maintenance followed by database security for handling sensitive data in PostgreSQL. Every system containing valuable data needs to be backed-up regularly. PostgreSQL follows a simple back-up procedure and provides fundamental approaches to back up your data. You will go through these approaches and choose the right one based on your environment. Running your application with limited resources can be tricky. To achieve this you will implement a pooling mechanism for your PostgreSQL instances to connect to other databases. Finally, you will take a look at some basic errors faced while working with PostgreSQL and learn to resolve them in the quickest manner. You will: Configure PostgreSQL for performance Monitor and maintain PostgreSQL instances Implement a backup strategy for your data Resolve errors faced while using PostgreSQL.

Programming --- Computer architecture. Operating systems --- Information systems --- Open Source --- applicatiebeheer --- apps --- computers --- database management --- architectuur (informatica) --- Open source software. --- Computer programming. --- Database management. --- Application software. --- Open Source. --- Database Management. --- Computer Applications. --- 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.