This chapter explains conceptual information about databases, how to create a database, and how to set properties on one.

This chapter provides a brief introduction to the basic concepts and procedures involved with the job of maintaining a database.

This chapter explains in some detail the major components that make up Pervasive PSQL and some of their unique features.

This chapter explains how to use access the configuration properties and provides detailed information about all of the available configuration options for engines and clients.

This chapter explains how to increase database performance through a variety of means such as tuning and the use of Xtreme I/O driver.

This chapter explains how to setup referential integrity rules to enforce the internal consistency of related data.

This chapter explains Btrieve security and SQL security.

This chapter describes how to develop a regular backup procedure to ensure your data is protected, and how to restore from backup if necessary.

This chapter describes how Pervasive PSQL supports failover clustering.

This chapter provides technical details and advanced procedures regarding the Workgroup engine.

This chapter explains how to use the graphical utility named Monitor to view users connected to a database, file usage information, and resource usage information.

This chapter explains how to use the Function Executor utility to perform individual operations for the transactional interface.

This chapter explains how to use the Maintenance utility.

This chapter explains how to use the Rebuild utility.

This appendix covers how to use description files to archive information about Btrieve data files you have created.