(Created page with '== Databases Overview == === Firebird === === MySQL === MySQL client programs and shared libraries MySQL is a multi-user, multi-threaded SQL database server. MySQL is a client...') |
No edit summary |
||
| Line 2: | Line 2: | ||
=== Firebird === | === Firebird === | ||
SQL relational database management system | |||
=== MySQL === | === MySQL === | ||
| Line 12: | Line 14: | ||
=== Postgresql === | === Postgresql === | ||
PostgreSQL is an advanced Object-Relational database management system | |||
(DBMS) that supports almost all SQL constructs (including | |||
transactions, subselects and user-defined types and functions). The | |||
postgresql package includes the client programs and libraries that | |||
you'll need to access a PostgreSQL DBMS server. These PostgreSQL | |||
client programs are programs that directly manipulate the internal | |||
structure of PostgreSQL databases on a PostgreSQL server. These client | |||
programs can be located on the same machine with the PostgreSQL | |||
server, or may be on a remote machine which accesses a PostgreSQL | |||
server over a network connection. This package contains the docs | |||
in HTML for the whole package, as well as command-line utilities for | |||
managing PostgreSQL databases on a PostgreSQL server. | |||
If you want to manipulate a PostgreSQL database on a remote PostgreSQL | |||
server, you need this package. You also need to install this package | |||
if you're installing the postgresql-server package. | |||
=== Berkeley DB === | === Berkeley DB === | ||
The Berkeley Database (Berkeley DB) is a programmatic toolkit that | |||
provides embedded database support for both traditional and | |||
client/server applications. The Berkeley DB includes B+tree, Extended | |||
Linear Hashing, Fixed and Variable-length record access methods, | |||
transactions, locking, logging, shared memory caching, and database | |||
recovery. The Berkeley DB supports C, C++, Java, and Perl APIs. It is | |||
used by many applications, including Python and Perl, so this should | |||
be installed on all systems. | |||
=== sqlite === | === sqlite === | ||
SQLite is a C library that implements an SQL database engine. A large | |||
subset of SQL92 is supported. A complete database is stored in a | |||
single disk file. The API is designed for convenience and ease of use. | |||
Applications that link against SQLite can enjoy the power and | |||
flexibility of an SQL database without the administrative hassles of | |||
supporting a separate database server. Version 2 and version 3 binaries | |||
are named to permit each to be installed on a single host | |||
Revision as of 11:26, 2 December 2009
Databases Overview
Firebird
SQL relational database management system
MySQL
MySQL client programs and shared libraries
MySQL is a multi-user, multi-threaded SQL database server. MySQL is a client/server implementation consisting of a server daemon (mysqld) and many different client programs and libraries. The base package contains the standard MySQL client programs and generic MySQL files.
Postgresql
PostgreSQL is an advanced Object-Relational database management system (DBMS) that supports almost all SQL constructs (including transactions, subselects and user-defined types and functions). The postgresql package includes the client programs and libraries that you'll need to access a PostgreSQL DBMS server. These PostgreSQL client programs are programs that directly manipulate the internal structure of PostgreSQL databases on a PostgreSQL server. These client programs can be located on the same machine with the PostgreSQL server, or may be on a remote machine which accesses a PostgreSQL server over a network connection. This package contains the docs in HTML for the whole package, as well as command-line utilities for managing PostgreSQL databases on a PostgreSQL server.
If you want to manipulate a PostgreSQL database on a remote PostgreSQL server, you need this package. You also need to install this package if you're installing the postgresql-server package.
Berkeley DB
The Berkeley Database (Berkeley DB) is a programmatic toolkit that provides embedded database support for both traditional and client/server applications. The Berkeley DB includes B+tree, Extended Linear Hashing, Fixed and Variable-length record access methods, transactions, locking, logging, shared memory caching, and database recovery. The Berkeley DB supports C, C++, Java, and Perl APIs. It is used by many applications, including Python and Perl, so this should be installed on all systems.
sqlite
SQLite is a C library that implements an SQL database engine. A large subset of SQL92 is supported. A complete database is stored in a single disk file. The API is designed for convenience and ease of use. Applications that link against SQLite can enjoy the power and flexibility of an SQL database without the administrative hassles of supporting a separate database server. Version 2 and version 3 binaries are named to permit each to be installed on a single host