Software Systems Architecture or PostgreSQL

Software Systems Architecture: Working with Stakeholders Using Viewpoints and Perspectives

Author: Nick Rozanski

Software Systems Architecture is a practitioner-oriented guide to designing and implementing effective architectures for information systems. It is both a readily accessible introduction to software architecture and an invaluable handbook of well-established best practices. It shows why the role of the architect is central to any successful information-systems development project, and, by presenting a set of architectural viewpoints and perspectives, provides specific direction for improving your own and your organization's approach to software systems architecture.

With this book you will learn how to
• Design an architecture that reflects and balances the different needs of its stakeholders
• Communicate the architecture to stakeholders and demonstrate that it has met their requirements
• Focus on architecturally significant aspects of design, including frequently overlooked areas such as performance, resilience, and location
• Use scenarios and patterns to drive the creation and validation of your architecture
• Document your architecture as a set of related views
• Use perspectives to ensure that your architecture exhibits important qualities such as performance, scalability, and security

The architectural viewpoints and perspectives presented in the book also provide a valuable long-term reference source for new and experienced architects alike.

Whether you are an aspiring or practicing software architect, you will find yourself referring repeatedly to the practical advice in this book throughout the lifecycle of your projects.

A supporting Web site containing further information can be found atwww.viewpoints-and-perspectives.info

Go to: Arthritis or Not in My Family

PostgreSQL

Author: Korry Douglas

The second edition of the best-selling PostgreSQL has been updated to completely cover new features and capabilities of the 8.0 version of PostgreSQL. You will be lead through the internals of the powerful PostgreSQL open source database chapter, offering an easy-to-read, code-based approach that makes it easy to understand how each feature is implemented, how to best use each feature, and how to get more performance from database applications. This definitive guide to building, programming and administering the powerful PostgreSQL open-source database system will help you harness one of the most widely used open source, enterprise-level database systems.

Table of Contents:

1	Introduction to PostgreSQL and SQL	9
2	Working with data in PostgreSQL	77
3	PostgreSQL SQL syntax and use	139
4	Performance	189
5	Introduction to PostgreSQL programming	241
6	Extending PostgreSQL	253
7	PL/pgSQL	305
8	The PostgreSQL C API - libpq	361
9	A simpler C API - libpgeasy	405
10	The new PostgreSQL C++ API - libpqxx	421
11	Embedding SQL commands in C programs - ecpg	465
12	Using PostgreSQL from an ODBC client application	501
13	Using PostgreSQL from a Java client application	543
14	Using PostgreSQL with Perl	573
15	Using PostgreSQL with PHP	613
16	Using PostgreSQL with Tcl and Tcl/Tk	645
17	Using PostgreSQL with Python	683
18	Npgsql : the .NET data provider	707
19	Other useful programming tools	743
20	Introduction to PostgreSQL administration	777
21	PostgreSQL administration	783
22	Internationalization and localization	881
23	Security	899
24	Replicating PostgreSQLData with Slony	925
25	Contributed modules	947