Databases

This chapter includes databases that range from single-user read/write to industrial database servers with transaction support. Generally, you will be sent here to satisfy dependencies to other applications although building a SQL server on a base LFS system is entirely possible.

Berkeley DB-4.2.52.2

Introduction to Berkeley DB

The Berkeley DB package contains programs and utilities used by many other applications for database related functions.

Package information

Berkeley DB dependencies

Optional

Tcl-8.4.6 and J2SDK-1.4.2

Installation of Berkeley DB

Install Berkeley DB by running the following commands:

patch -Np0 -i ../patch.4.2.52.1 &&
patch -Np0 -i ../patch.4.2.52.2 &&
cd build_unix &&
../dist/configure --prefix=/usr \
    --enable-compat185 \
    --enable-cxx &&
make &&
make docdir=/usr/share/doc/db-4.2.52.2 install
[Note]

Note

If you wish to enable Java support in Berkeley DB-4.2.52.2, add --enable-java to the configure options. This requires a Java compiler. Java support is needed if you plan to use system installed Berkeley DB when compiling OpenOffice-1.1.1.

Command explanations

cd build_unix && ../dist/configure --prefix=/usr --enable-compat185: This replaces the normal ./configure command as Berkeley DB comes with the various build directories for different platforms.

make docdir=/usr/share/doc/db-4.2.52.2 install: This installs the documentation in the correct place.

Contents

The Berkeley DB package contains db_archive, db_checkpoint, db_deadlock, db_dump, db_load, db_printlog, db_recover, db_stat, db_upgrade and db_verify.

Description

db_archive

db_archive prints the pathnames of log files that are no longer in use.

db_checkpoint

db_checkpoint is a daemon process used to monitor and checkpoint database logs.

db_deadlock

db_deadlock is used to abort lock requests when deadlocks are detected.

db_dump

db_dump converts database files to a flat file format readable by db_load.

db_load

db_load is used to create database files from flat files created with db_dump.

db_printlog

db_printlog converts database log files to human readable text.

db_recover

db_recover is used to restore a database to a consistent state after a failure.

db_stat

db_stat displays database environment statistics.

db_upgrade

db_upgrade is used to upgrade database files to a newer version of Berkeley DB.

db_verify

db_verify is used to run consistency checks on database files.