Description:Since the original edition of The Firebird Book was published as a two-pound doorstop in 2004, the open source Firebird relational database management system has undergone three major releases through versions 2.0, 2.1 and 2.5. The Firebird Book Second Edition brings Firebird technical users up to score across all of the releases from the original v.1.0 through to the latest 2.5. The whole book, too big to publish as a paperback, is distributed by the IBPhoenix company on a DVD. For print, it has been split into three partly overlapping volumes, of which this is the second, following on from Volume 1, Firebird Fundamentals . In Developing with Firebird Data : Part I Working With Data (pp. 1 - 178)This section provides an in-depth survey of the data manipulation language (DML) lexicon of Firebird's SQL implementation, the concept of sets ("datasets") and the many ways available to retrieve stored data, manipulate it and operate on it. At the end is a detailed manual for using the interactive and command-line modes of isql, a tool that comes in every Firebird distribution, regardless of platform. Part II Transactions (pp. 179 - 223)This section contains three detailed chapters describing the transactional model that allows multiple users or tasks to work with the same data simultaneously, in compliance with the ACID rules for ensuring data integrity. The third chapter describes how to work with transactions in your applications. Part III Programming Server-Side (pp. 225 - 340)In this section is a full work-through of the many ways you can write code that is stored in your database for invoking when conditions call for it. It covers Firebird's prcedural language (PSQL) with its use in stored procedures, triggers and dynamic executable code blocks in the client applications. Error-handling and events are covered here, too. Part IV Appendices (pp. 341 - 472)Index GLOSSARY (18 pp. at end of book) Volume 1 of this series, Firebird Fundamentals , covers client/server concepts, the architecture of the multiple Firebird server models and the first tasks for installing a server, configuring it for the network and starting to work with Firebird. It moves on to the data definition language (DDL) lexicon that is used for creating databases and the objects in them to suit your requirements. Although it covers some of the same ground as this book on the subject of transactions, it is the precursor for this volume. The third companion volume, Administering Firebird Servers and Databases , starts with a section with the basics for installing, configuring, operating and migrating servers and databases and moves on to the detailed configuration of servers, users and databases and the tools for managing and monitoring them.We have made it easy for you to find a PDF Ebooks without any digging. And by having access to our ebooks online or by storing it on your computer, you have convenient answers with The Firebird Book, Volume 2: Developing with Firebird Data. To get started finding The Firebird Book, Volume 2: Developing with Firebird Data, you are right to find our website which has a comprehensive collection of manuals listed. Our library is the biggest of these that have literally hundreds of thousands of different products represented.
Pages
—
Format
PDF, EPUB & Kindle Edition
Publisher
—
Release
—
ISBN
1482767309
The Firebird Book, Volume 2: Developing with Firebird Data
Description: Since the original edition of The Firebird Book was published as a two-pound doorstop in 2004, the open source Firebird relational database management system has undergone three major releases through versions 2.0, 2.1 and 2.5. The Firebird Book Second Edition brings Firebird technical users up to score across all of the releases from the original v.1.0 through to the latest 2.5. The whole book, too big to publish as a paperback, is distributed by the IBPhoenix company on a DVD. For print, it has been split into three partly overlapping volumes, of which this is the second, following on from Volume 1, Firebird Fundamentals . In Developing with Firebird Data : Part I Working With Data (pp. 1 - 178)This section provides an in-depth survey of the data manipulation language (DML) lexicon of Firebird's SQL implementation, the concept of sets ("datasets") and the many ways available to retrieve stored data, manipulate it and operate on it. At the end is a detailed manual for using the interactive and command-line modes of isql, a tool that comes in every Firebird distribution, regardless of platform. Part II Transactions (pp. 179 - 223)This section contains three detailed chapters describing the transactional model that allows multiple users or tasks to work with the same data simultaneously, in compliance with the ACID rules for ensuring data integrity. The third chapter describes how to work with transactions in your applications. Part III Programming Server-Side (pp. 225 - 340)In this section is a full work-through of the many ways you can write code that is stored in your database for invoking when conditions call for it. It covers Firebird's prcedural language (PSQL) with its use in stored procedures, triggers and dynamic executable code blocks in the client applications. Error-handling and events are covered here, too. Part IV Appendices (pp. 341 - 472)Index GLOSSARY (18 pp. at end of book) Volume 1 of this series, Firebird Fundamentals , covers client/server concepts, the architecture of the multiple Firebird server models and the first tasks for installing a server, configuring it for the network and starting to work with Firebird. It moves on to the data definition language (DDL) lexicon that is used for creating databases and the objects in them to suit your requirements. Although it covers some of the same ground as this book on the subject of transactions, it is the precursor for this volume. The third companion volume, Administering Firebird Servers and Databases , starts with a section with the basics for installing, configuring, operating and migrating servers and databases and moves on to the detailed configuration of servers, users and databases and the tools for managing and monitoring them.We have made it easy for you to find a PDF Ebooks without any digging. And by having access to our ebooks online or by storing it on your computer, you have convenient answers with The Firebird Book, Volume 2: Developing with Firebird Data. To get started finding The Firebird Book, Volume 2: Developing with Firebird Data, you are right to find our website which has a comprehensive collection of manuals listed. Our library is the biggest of these that have literally hundreds of thousands of different products represented.