|
Postgresql- A Comprehensive Guide 2nd ed. eBook
|
PostgreSQL is the world's most advanced open-source database. PostgreSQL is the most comprehensive, in-depth, and easy-to-read guide to this award-winning database. This book starts with a thorough overview of SQL, a description of all PostgreSQL data types, and a complete explanation of PostgreSQL commands. If you are a developer or an administrator, you'll love the chapter that explores PostgreSQL performance. The authors explain how PostgreSQL stores data on disk (and in memory) and how to measure and influence the effectiveness of PostgreSQL's caching mechanisms. You'll also learn how PostgreSQL generates and evaluates execution plans. The authors explain all of the query operators that can appear in the results of an EXPLAIN command, describing the performance implications of each operator as well as the conditions which will cause PostgreSQL to use that operator. PostgreSQL is also a complete guide for the developer. Whether you're developing with C, C++, ODBC, Embedded SQL, Java, Tcl/Tk, Perl, Python or PHP, you'll find a comprehensive description of the PostgreSQL API for your language of choice. Easy to follow exercises will walk you through the development of working applications that fully demonstrate the features offered by each API. You will also find a chapter that describes the PL/pgSQL server-side procedural language, learning how to build triggers, functions, and stored-procedures. The authors have even included a chapter that walks you through the process of extending the PostgreSQL server with custom-written C functions and new data types.You will learn how to install PostgreSQL on Windows, Linux, and Unix systems, from source code or from pre-compiled installers. The authors have described all of the PostgreSQL configuration options (compile-time, startup, and on-the-fly). The chapter on PostgreSQL security describes all of the authentication protocols that you can choose from and describes how to secure your database, both internally and externally. If you have to support a multi-national environment, you will find the chapter on internationalization and localization to be invaluable. You won't find a more complete guide to PostgreSQL anywhere. The authors have made PostgreSQL approachable by leading the reader from basic concepts to advanced features. Whether you're a database beginner or an advanced user, you will find this book a valuable addition to your library.
|
|
|
| Random eBooks | |
|
Neurotransmitters, Drugs and Brain Function
| Neurotransmitters, Drugs and Brain Function aims to link basic aspects of the activity of neurotransmitters at the receptor and synaptic level with their role in normal brain function, disease states, and drug action. Thus, the material consid.. (read more) |
Managed DirectX 9 Kick Start- Graphics and Game Programming
|
Managed DirectX was released with the latest version of the core DirectX libraries in DirectX9. It enables developers using the new .NET languages (i.e. C#, VB.NET, etc.) to develop rich multimedia applications with DirectX. Unfortunately the Ma.. (read more) |
Learning UML 2.0 [ILLUSTRATED]
| "Since its original introduction in 1997, the Unified Modeling Language has revolutionized software development. Every integrated software development environment in the world--open-source, standards-based, and proprietary--now supports UML and, more.. (read more) |
Sams Teach Yourself SAP in 24 Hours
|
Sams Teach Yourself SAP in 24 Hours, Second Edition is the perfect tool for learning one of the most sophisticated enterprise solutions available today. Designed to being with the basics, you will become acquainted with the entire SAP sys.. (read more) |
Agile Software Development- Evaluating The Methods For Your Organization
| Here?s the first truly impartial book that gives you both an expert objective analysis of Agile software development methods together with much-needed tools for evaluating their suitability for your organization. It reviews the philosophical underpin.. (read more) |
| |
|
|
|
