首页｜社区论坛｜iTePub书库｜在线阅读｜电图引擎｜技术文档｜图书查询｜光盘刻录 ｜

The book is framed as a case study for building a custom database program in Linux for a video rental store. After a tour of the requirements and a brief look at project management for creating this software, the various Linux packages that are needed to implement this system are described, along with sample code, most of which is written in C. Some packages, such as the CVS version-control package, come with most distributions of Linux; others will require downloading additional software over the Internet. In every case, you're provided with the actual command-line arguments that are needed to install, configure, and run each package.

Besides a great exploration of CVS for version control, this title offers excellent coverage of the free PostgreSQL and MySQL databases, which are two very popular choices for Linux databases. The book also does a good job of explaining UI design under both the GTK+/GNOME and KDE (two popular Linux desktops), and how to extend the reach of the sample database application by using Remote Procedure Calls (RPCs) and CORBA. Of course, the finished application doesn't use every Linux API that's covered here, but the book does cast a wide net, and introduces features and tools that are available.

Two prominent chapters take you on a tour of the essentials of other programming languages. There's PHP for Web development and an appealing, enthusiastic introduction to Python (which probably will turn you into a Python convert). Later chapters provide practical tips for testing and debugging applications, including how to profile your code. The book closes with a useful guide to creating Red Hat Package Manager (RPM) packages for deploying applications, as well as an overview of your options for internationalization.

By covering so many APIs, languages, and tools effectively, Professional Linux Programming gives experienced C/C++ programmers all that they need to get started with Linux development. With its remarkably clear presentation style and abundance of practical tips, the book is an admirably useful blueprint for building custom software. --Richard Dragan

Topics covered: <ul><li>Introduction to open-source software and Linux requirements <li>Use cases and sample C objects for sample video rental store <li>Version control and CVS (command-line options, revisions, branches, and multiuser version control) <li>Open-source freeware packages compared (mSQL, MySQL, and PostgreSQL) <li>Introduction to databases <li>Installing and using PostgreSQL <li>Tutorial on psql SQL <li>PostgreSQL C database APIs using libcq and embedded SQL calls with ECPG <li>Installing and using MySQL (command-line utilities and C database APIs) <li>Debugging with gdb <li>Introduction and tutorial to UI programming with glib <li>GTK+ and GNOME <li>Source trees and GNOME <li>UI design with Glade <li>Testing strategies (including regression testing, profiling, and memory bounds checking) <li>KDE/Qt UI programming <li>Introduction and quick tutorial to Python (keywords and basic syntax) <li>PHP for Web programming <li>Introduction to Remote Procedure Calls (RPCs) and CORBA <li>XML basics (document structure, parsing, and libxml) <li>Strategies for documentation (including custom man pages) <li>Distributing Linux applications with Red Hat Package Manager (RPM) packages <li>Code patches</ul>

Usually associated with the lower end, Access 2000 has clearly grown up with the features that let you connect to SQL Server 7/2000, but with the convenience of a graphical tool. The book covers not only the features of Microsoft databases, but also how to rely on Access 2000 as your tool of choice for common administrative and programming tasks. Starting from table design, and the powerful database diagramming tools available in Access, you learn how to create effective database designs. And a full discussion of joins, indexes, constraints, views, and other advanced features make this book good for even more advanced readers. Besides admin functionality, there's coverage of VBA for database programmers, and T-SQL (Microsoft's version of SQL), including an excellent section on stored procedures and triggers.

While there's a lot of textual description in this book, there are also plenty of easy-to-understand screen shots, making this a useful resource to have at your desk. The graphics that detail the use of Access 2000 toolbars (which list the functions for each tiny button) are very good. The tutorial turns toward using Access 2000 features (forms and reports) to work with SQL Server data on the back end. Later sections examine the options you have for Web development, including Access's own Data Access Pages, data sheets, and a short introduction to using Active Server Pages on Microsoft IIS.

Reference sections of database security and upsizing older Access databases to SQL Server help round out this comprehensive and thoughtfully written book, which shows that Access 2000 really can let you access higher-end features on today's Windows platform. This book is perfect for any administrator or database programmer who wants to benefit from Access and SQL Server used together. --Richard Dragan

Topics covered: <ul><li>Introduction to relational databases and Access 2000 <li>Installing SQL Server 7/2000 and the Microsoft Data Engine (MSDE) <li>SQL Server data types <li>Creating and managing tables <li>Using constraints <li>Database diagramming in Access 2000 <li>Using SQL Server views <li>Programming the SQL Distributed Management Objects (SQL-DMO) <li>Stored procedures and triggers (including VBA and ADO programming techniques) <li>Access forms (bound and programmatic access to form controls) <li>Report design in Access 2000 (including conditional formatting and charts) <li>Publishing datasheets for Internet applications <li>Quick introduction to form design using Active Server Pages (ASPs) <li>Data Access Pages <li>Office Web Components (including spread sheets and charts) <li>Programming SQL Server in Access (including basic ADO programming) <li>SQL Server security tutorial <li>Upsizing Access databases to SQL Server <li>ADO 2.1 object model reference</ul>

Copyright © 2002 - 2008 iTePub.Group All Rights Reserved