Apache Derby—Off to the Races: Includes Details of IBM Cloudscape

Apache Derby—Off to the Races: Includes Details of IBM Cloudscape

Part 1

Chapter 1. On Your Marks … Get Set … Go!!! An Introduction to the Apache Derby and IBM Cloudscape Community

Part 2

Chapter 2. Deployment Options for Apache Derby Databases

Chapter 4. Installing Apache Derby and IBM Cloudscape on Windows

Chapter 5. Installing Apache Derby and IBM Cloudscape on Linux

Chapter 6. Managing an Apache Derby Database

Chapter 7. Security

Chapter 8. SQL

Part 3

Chapter 9. Developing Apache Derby Applications with JDBC

Chapter 10. Developing Apache Derby Applications with Perl, PHP, Python, and ODBC Communicating with an Apache Derby Network Server Installing the DB2 Runtime Client Cataloging Apache Derby Network Servers Cataloging Apache Derby Databases Testing Your Connection Uncataloged Connections Summary

Part 4

Chapter 11. "Your Momma Loves Drama" in JDBC

Chapter 12. "Your Momma Loves Drama" in Windows

Chapter 13. "Your Momma Loves Drama" in PHP

Chapter 14. "Your Momma Loves Drama" in Perl

Chapter 15. "Your Momma Loves Drama" in Python

Part 5

;Appendix A. Web Site Contents

Appendix B. Apache Derby and IBM Cloudscape Resources

Appendix C. Troubleshooting Hints and Tips

This book is written for everyone! Well, that may be a broad statement, but it's partially true. For the most part, we've tried to put a little bit of everything in this book. From a discussion on the open source movement, to the benefits of relational database technology for those of you who leverage a file system to persist data, to a primer on SQL, to step-by-step tutorials on building sample applications, you'll find it all in this book.

In Part I, we introduce you to the open source world, and we talk about such fundamental concepts as the Apache process, why IBM contributes to the open source movement, IBM's significant role with respect to open source software, why someone would want to use a relational database, the differences between the IBM Cloudscape and the Apache Derby databases, and more. You don't have to be technical to benefit from Part I. However, even if you're a developer and you don't think that you'll find this information useful, read it: you're going to learn some key information that will prove invaluable as you work your way through the rest of this book.

Part II introduces you to the different ways that you can use the IBM Cloudscape database (also known as Apache Derby) in the "real world." You don't know the difference between IBM Cloudscape and Apache Derby? That's what Part I is for! In Part II we talk about deployment and functional considerations for development environments, client/server environments, multi-threaded applications, Web servers, and more. After giving you a foundation in the ways that you can use Apache Derby, we present you with a general overview of this database and database technology in general. (After all, not everyone who reads this book is a database expert—we'll give you enough to get going.) The "meat" of this part of the book takes you through step-by-step examples of how to install the Apache Derby code on a Windows or Linux workstation for developmental purposes. (We cover how to install it on any operating system and production deployment as well.) Finally, this part ends with important concepts such as managing the Apache Derby database (for all you DBAs out there), securing the database, and a really good primer on SQL. After reading Part II, you'll not only have a great foundation that's applicable to most databases in general, you'll also have the Apache Derby code installed on your workstation, at which point you'll be ready to really get the Apache Derby database working for you. For the most part, we aren't expecting most of you to be DBAs, so we'll take the time to give you a good enough DBA foundation. The best part of the Apache Derby and IBM Cloudscape databases are that they don't require DBAs—just basic database knowledge.

Part III prepares you for the tutorials in Part IV. You'll learn about each of the programming languages that are supported by Apache Derby and how their elements interact with the Apache Derby database engine.

Part IV shows you how to build a sample application called "Your Momma Loves Drama" (YMLD).