PostgreSQL Developer's Handbook


Book Description

"PostgreSQL Developer's Handbook" provides a complete overview of the PostgreSQL database server and extensive coverage of its core features, including object orientation, PL/SQL, and the most important programming interfaces. The authors introduce the reader to the language and syntax of PostgreSQL and then move quickly into sophisticated programming topics.




Containers for Developers Handbook


Book Description

Effortlessly create and manage complex multi-component applications based on Docker containers Key Features Gain a clear understanding of software containers from the SecDevOps perspective Master the construction of application pieces within containers to achieve a seamless life cycle Prepare your applications to run smoothly and with ease in complex container orchestrators Purchase of the print or Kindle book includes a free PDF eBook Book DescriptionDevelopers are changing their deployment artifacts from application binaries to container images, giving rise to the need to build container-based apps as part of their new development workflow. Managing an app’s life cycle is complex and requires effort—this book will show you how to efficiently develop, share, and execute applications. You’ll learn how to automate the build and delivery process using CI/CD tools with containers as container orchestrators manage the complexity of running cluster-wide applications, creating infrastructure abstraction layers, while your applications run with high availability, resilience, and persistence. As you advance, you’ll develop, test, and debug applications on your desktop and get them ready to run in production with optimal security standards, using deployment patterns and monitoring tools to help identify common issues. You’ll also review deployment patterns that’ll enable you to solve common deployment problems, providing high availability, scalability, and security to your applications. Finally, you’ll explore different solutions to monitor, log, and instrument your applications as per open-source community standards. By the end of this book, you’ll be able to manage your app’s life cycle by implementing CI/CD workflows using containers to automate the building and delivery of its components.What you will learn Find out how to build microservices-based applications using containers Deploy your processes within containers using Docker features Orchestrate multi-component applications on standalone servers Deploy applications cluster-wide in container orchestrators Solve common deployment problems such as persistency or app exposure using best practices Review your application’s health and debug it using open-source tools Discover how to orchestrate CI/CD workflows using containers Who this book is forThis book is for developers and DevOps engineers looking to learn about the implementation of containers in application development, especially DevOps engineers who deploy, monitor, and maintain container-based applications running on orchestrated platforms. In general, this book is for IT professionals who want to understand Docker container-based applications and their deployment. A basic understanding of coding and frontend-backend architectures is needed to follow the examples presented in this book.




PHP and PostgreSQL


Book Description

"Introduction. 1. Pt. I. Getting Started. 3. 1. Getting Started. 5. 2. Setting Up PHP. 15. 3. PHP Basics. 43. 4. Object-Oriented PHP. 121. Pt. II. Getting Started with PostgreSQL. 137. 5. Relational and Object-Relational Database Concepts. 139. 6. Installing PostgreSQL. 149. 7. Basic SQL. 177. 8. Advanced SQL. 225. 9. Embedded Languages. 307. 10. PostgreSQL Administration. 349. Pt. III. PHP/PostgreSQL Interaction. 379. 11. Writing Database-Driven Applications. 381. 12. Working with BLOBs. 405. 13. Working with Persistent Database Connections. 423. Pt. IV. Advanced Technologies. 433. 14. Managing Regular Expressions. 435. 15. Session Management. 463. 16. Working with Dynamic Documents, Images, and Movies. 475. 17. Working with Dates and Time. 521. 18. Tuning. 551. 19. XML. 573. 20. Security Issues. 585. Pt. V. Practical Examples. 597. 21. Web Applications. 599. 22. Extending PostgreSQL. 669. 23. High-Availability Systems. 695. Pt. VI. Migration. 709. 24. Migration. 711. . Index. 721.




Clarion Databases & SQL


Book Description




Mastering PostgreSQL in Application Development


Book Description

Mastering PostgreSQL in Application Development is intended for developers working on applications that use a database server. The book addresses specifically the PostgreSQL RDBMS: it actually is the world's most advanced Open Source database as said in its slogan on the official website. By the end of this book, you will know why, and agree!




Open Source Software: Implementation and Management


Book Description

In 2004/5, over half of IT professionals will be looking at open source, most for the first time. This book provides key tools for System administrators, Network Administrators, IT project managers, and consultants who must evaluate and deploy open source software. This book details open source successes so far, explains which scenarios are the most realistic opportunities now, then gives the details needed to select these solutions, adopt the best tools and practices, introduce them to an organization, implement and manage them. The IT professional can use this book to review opportunities in their organization, evaluate components such as Apache, Linux, and OpenOffice against systems they know, and follow up in detail on their specific interests here and through referred resources.*Deployment scenarios categorized by function and industry*Rules of thumb on where and when open source software is or is not the right choice*Roadmaps for deployment in terms of the components of open source




PostgreSQL: Up and Running


Book Description

Thinking of migrating to PostgreSQL? This updated guide helps you quickly understand and use the 9.3 release of this open source database system. You’ll not only learn about its unique enterprise-class features, but also discover that PostgeSQL is more than just a database system—it’s also an impressive application platform. Using numerous examples, this book shows you how to achieve tasks that are difficult or impossible in other databases. The second edition covers LATERAL queries, augmented JSON support, materialized views, and other key topics. If you’re an existing PostgreSQL user, you’ll pick up gems you may have missed along the way. Learn basic administration tasks, such as role management, database creation, backup, and restore Apply the psql command-line utility and the pgAdmin graphical administration tool Explore PostgreSQL tables, constraints, and indexes Learn powerful SQL constructs not generally found in other databases Use several different languages to write database functions Tune your queries to run as fast as your hardware will allow Query external and variegated data sources with Foreign Data Wrappers Learn how to replicate data, using built-in replication features




Handbook of Research on Open Source Software: Technological, Economic, and Social Perspectives


Book Description

This handbook of research is one of the few texts to combine Open Source Software (OSS) in public and private sector activities into a single reference source. It examines how the use of OSS affects practices in society, business, government, education, and law.




Practical PostgreSQL


Book Description

Arguably the most capable of all the open source databases, PostgreSQL is an object-relational database management system first developed in 1977 by the University of California at Berkeley. In spite of its long history, this robust database suffers from a lack of easy-to-use documentation. Practical PostgreSQL fills that void with a fast-paced guide to installation, configuration, and usage. This comprehensive new volume shows you how to compile PostgreSQL from source, create a database, and configure PostgreSQL to accept client-server connections. It also covers the many advanced features, such as transactions, versioning, replication, and referential integrity that enable developers and DBAs to use PostgreSQL for serious business applications. The thorough introduction to PostgreSQL's PL/pgSQL programming language explains how you can use this very useful but under-documented feature to develop stored procedures and triggers. The book includes a complete command reference, and database administrators will appreciate the chapters on user management, database maintenance, and backup & recovery. With Practical PostgreSQL, you will discover quickly why this open source database is such a great open source alternative to proprietary products from Oracle, IBM, and Microsoft.




PHP and MySQL Web Development


Book Description

A new, updated and revised edition of the best-selling #1 book on any open source programming topic.