Berkeley DB...

Berkeley DB (or BDB) is a computer program library that offers an embedded database. The software has bindings for various programming languages, including Smalltalk, Python, Perl, Java, PHP C++ and C.

Berkeley DB Information

BDB keeps the data pairs/arbitrary key as byte arrays. BDB also provides support for many simultaneous threads or processes handling databases. BDB can handle data as big as 256 terabytes. BDB can also work in different operating systems, including Windows.

An application retrieving data has the option to decide how the information will be stored. Unlike other programs, there are no restrictions on the data record. In terms of length, the key and record can be 4 GB long.

Architecture

BDB is noted for its simple architecture. Despite its simple structure, the program has support for many features. These include replication, hot backups, fine-grained locking, and ACID transactions. The system does not have support for network access. Databases can be accessed utilizing API calls.

Versions

BDB comes in three editions: Berkeley DB XML, Berkeley DB Java Edition and Berkeley DB. All the editions come with their own distinct database library. The first is Berkeley DB, which is made using C. The Berkeley DB Java Edition (JE) is set in Java entirely.

In terms of design it is somewhat like BDB. While it has features like BDB, it also has features specifically for java. There is no native code needed since it is made using Java. The Berkeley DB XML database is used for storing XML documents. It can also support various XQuery queries.

Another piece of Berkeley DB information worth noting is that Berkeley DB XML is used as a layer for BDB. Berkeley DB XML has support for Java, C and multiple language bindings.

Apps that Use BDB

BDB is used as the retrieval and storage system of numerous LDAP servers. Some of these programs include MySQL, Rbot (an IRC bot), Terracotta, Sun Grid Engine (open source database management), Bogofilter (a spam filter) and Cfengine (a configuration management program).

Other programs that employ BDB are Citadel, Cyrus IMAP Server, Figaro DB, GlusterFS, GRAMPS and HyperGraphDB. There are other database management programs that use it.

One more piece of Berkeley DB information has to be said: its license will depend on how the program will be utilized. If the program will not be distributed, the Sleepycat License is used. For proprietary programs, the license agreement between the program publisher and Oracle will be applied.

How to Install PostgreSQL...

PostgreSQL is an open source relational database that can be run in different platforms. It is also compatible with various programming languages. The following guides will show you how to install the program.

How to Install PostgreSQL

Step 1

Get the PostgreSQL source code package from the Internet. Unzip it using these commands: gunzip postgresql-8.3.1.tar.gz & tar xf postgresql-8.3.1.tar.

Step 2

Move the postgresql-8.3.1 folder under the present folder where the source code had been unpacked.

Step 3

Keep running the configure script to set up the source tree for your system. The default setup assesses the components in the system. It will conduct examinations to determine what values will be utilized to make the source tree. This is going to build the tools, server
and client applications.

Step 4

Enter “gmake install” to put the files in the folders you made. The installation is finished.

Tips

The build can go about in various ways depending on the preferences you set on the command line. It is also possible to make changes following the package installation.

It is also possible to start all over again. Rebuilding the installation is possible. It means you can change the system settings until the right configuration is attained.

How to Install PostgreSQL PHP Connectors in Windows XP

Step 1

Find the php.ini file. In some PHP installations, this is in the C:\Windows folder. If it isn’t there, go to the folder where you installed the PHP files. Use Notepad or another simple text editor to open this file.

Step 2

Scroll through the file until you see the “;extension=php_pgsql.dll” line. Change it to take away the semicolon. It should now read “extension=php_pgsql.dll”. Click file, save.

Step 3

Restart the web server. Reload the PHP. Go to the Start menu and choose “Run”. Type “iisreset” as the administrator.

Tips

You can verify the php_pgsql.dll module is loaded by making another PHP file. At the web server, use the following syntax: “<?php phpinfo(); ?>”. After running the file, it will be visible at the modules.

Warnings

Make sure you study the configuration before making changes. While the program is easy to use, making unnecessary changes may lead to unforeseen problems.It is better to be sure, so examine the configuration.