Bücher veröffentlicht von Packt Publishing Limited

Get to know effective ways to improve PostgreSQL's performance and master query optimization, and database monitoring. About This Book* Perform essential database tasks such as benchmarking the database and optimizing the server's memory usage* Learn ways to improve query performance and optimize the PostgreSQL server* Explore a wide range of high availability and replication mechanisms to build robust, highly available, scalable, and fault-tolerant PostgreSQL databasesWho This Book Is ForIf you are a developer or administrator with limited PostgreSQL knowledge and want to develop your skills with this great open source database, then this book is ideal for you. Learning how to enhance the database performance is always an exciting topic to everyone, and this book will show you enough ways to enhance the database performance. What You Will Learn* Build replication strategies for homogeneous and heterogeneous databases* Test and build a powerful machine with multiple bench marking techniques* Get to know a few SQL injection techniques* Find out how to manage the replication using multiple tools* Benchmark the database server using multiple strategies* Work with the query processing algorithms and their internal behaviors* Build a proper plan to upgrade or migrate to PostgreSQL from other databases* See the essential database load balancing techniques and the various partitioning approaches PostgreSQL provides* Learn memory optimization techniques and database server configurationsIn DetailPostgreSQL is one of the most powerful and easy to use database management systems. It has strong support from the community and is being actively developed with a new release every year. PostgreSQL supports the most advanced features included in SQL standards. It also provides NoSQL capabilities and very rich data types and extensions. All of this makes PostgreSQL a very attractive solution in software systems. If you run a database, you want it to perform well and you want to be able to secure it. As the world's most advanced open source database, PostgreSQL has unique built-in ways to achieve these goals. This book will show you a multitude of ways to enhance your database's performance and give you insights into measuring and optimizing a PostgreSQL database to achieve better performance. This book is your one-stop guide to elevate your PostgreSQL knowledge to the next level. First, you'll get familiarized with essential developer/administrator concepts such as load balancing, connection pooling, and distributing connections to multiple nodes. Next, you will explore memory optimization techniques before exploring the security controls offered by PostgreSQL. Then, you will move on to the essential database/server monitoring and replication strategies with PostgreSQL. Finally, you will learn about query processing algorithms. Style and approachThis comprehensive guide is packed with practical administration tasks. Each topic is explained using examples and a step-by-step approach.

This second edition of Industrial Cybersecurity is a practical guide to implementing a comprehensive and solid security program for the ICS environment. This book shows anyone new to industrial security or professionals looking to extend their industrial security posture how to effectively monitor their ICS environment.

OAuth 2.0 is a standard protocol for authorization and focuses on client development simplicity while providing specific authorization flows for web applications, desktop applications, mobile phones, and so on. This book also provides useful recipes for solving real-life problems using Spring Security and creating Android applications.

This book is your guide to exploring the various developer capabilities offered by SQL Server 2017. Model your data and the complex relationships within it, and integrate SQL Server with R and Python for efficient analytics. The book also covers the performance and troubleshooting aspects to help you develop efficient database applications.

This book is your one-stop guide to mastering Qlik Sense, catering for all your organizational BI needs. You'll see how you can seamlessly navigate through tons of organizational data from multiple sources and create smart visualizations that meet your unique business needs.

Chef is a configuration management tool that turns IT infrastructure into code. Chef provides tools to manage systems at scale. This learning path takes you on a comprehensive tour of Chef's functionality, ranging from its core features to advanced development.

NFRs are the lifeline of any software application, capturing and addressing them is a critical activity in any IT project. The book provides a comprehensive approach delivering strategic, tactical and operational engagements for fortune 100 customers worldwide.

The Enterprise PowerShell Scripting Bootcamp book is designed to provide real-world examples to solve common challenges in enterprises around the world. This book provides a scripting framework, optimization methodologies, and a final script to provide you with a platform to build your own enterprise-ready PowerShell scripts.

Learn how to build robust web applications using Vue.js with the help of this easy-to-follow guide. Explore exercises and examples to study the MVVM architecture, create customized plugins to enhance your website, and bring a static application to life by harnessing the power of Vue.js.

The Linux Kernel which possesses a kind of collective intelligence, attributed by its scores of contributors has managed to remain serene at its core and displays the efficiency of its design. Along with tips and tricks, this book follows a tenacious approach at decoding the core principles of the kernel.

IoT is an upcoming trend in the IT industry today; there are a lot of IoT devices on the market but there is a minimal understanding of how to safeguard them. If you are a security enthusiast or pentester, this book will help you understand how to exploit and secure IoT devices. You will learn how to identify vulnerabilities in IoT device archit...

Spring Security 4.2 is an incremental guide that will teach you how to protect your application from malicious users. Through this book, you will learn how to cleanly integrate Spring Security into your application using the latest technologies and frameworks with the help of detailed examples.

This book will empower you to produce and present impressive analyses from data, by selecting and implementing the appropriate data mining techniques in R. Explore a data mining crime case, where you will be requested to help resolving a real fraud case affecting a commercial company, by the mean of both basic and advanced data mining techniques.

Microsoft Dynamics CRM is the most trusted name in the enterprise-level customer relationship management. The latest version of Dynamics CRM 2016 comes with important addition of some exciting features that is guaranteed to make your life easier with Dynamics CRM. This book will give a comprehensive coverage of Dynamics CRM 2016 and help you mak...

This book is designed to help you explore QGIS. Starting from understanding essential concepts in QGIS and creating maps and plugins through to learning data management, visualization, and spatial analysis techniques in QGIS, this book will get you up to speed quickly yet effectively.

This Mastering Django book equips you with the knowledge you need to implement Django in web applications. You'll learn best practices for writing flawless code and creating powerful websites with the help of engaging examples and exercises.