From Fedora Project Wiki

< SIGs‎ | Server

No edit summary
mNo edit summary
 
(12 intermediate revisions by 2 users not shown)
Line 1: Line 1:
== Databases Overview ==


=== Firebird ===
{{admon/important|This page is outdated.}}


SQL relational database management system
== Firebird ==


=== MySQL ===
[[Firebird]]
MySQL client programs and shared libraries


MySQL is a multi-user, multi-threaded SQL database server. MySQL is a
== MySQL ==
client/server implementation consisting of a server daemon (mysqld)
=== Package Management ===
and many different client programs and libraries. The base package
<pre>
contains the standard MySQL client programs and generic MySQL files.
yum install mysql
 
</pre>
==== resources ====
* Package and Version
** mysql 5.1.39.fc12
* dependencies which gonne be installed
** none
* Subpackages
** none
=== Config Tools ===
* Standard
** mysql, mysql-admin
* Webbased
** phpmyadmin
=== Config Overview ===
* Config files
** /etc/my.cnf
* Path to Database
** /var/....
=== Resources ===
* Fedora Package
** [https://admin.fedoraproject.org/pkgdb/packages/name/mysql?_csrf_token=707bffb9e328c55fc0f9e19d78d9cd9b89487a36 mysql]
* Web
* Web
** [http://www.mysql.com Official Webside]
** [http://www.mysql.com Official Webside]
** [http://dev.mysql.com/doc/refman/5.1/en/index.html reference ] (Version 5.1)
** [http://dev.mysql.com/doc/refman/5.1/en/index.html reference ] (Version 5.1)


=== Postgresql ===
== Postgresql ==
PostgreSQL is an advanced Object-Relational database management system
== Berkeley DB ==
(DBMS) that supports almost all SQL constructs (including
{{admon/tip|The Berkeley DB supports C, C++, Java, and Perl APIs. It is
transactions, subselects and user-defined types and functions). The
used by many applications, including Python and Perl, so this should
postgresql package includes the client programs and libraries that
be installed on all systems.}}
you'll need to access a PostgreSQL DBMS server. These PostgreSQL
=== Package Mangement ===
client programs are programs that directly manipulate the internal
<pre>
structure of PostgreSQL databases on a PostgreSQL server. These client
yum install db4
programs can be located on the same machine with the PostgreSQL
</pre>
server, or may be on a remote machine which accesses a PostgreSQL
* Package and Version
server over a network connection. This package contains the docs
** db4 4.7.2.fc12
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
=== Information ===
server, you need this package. You also need to install this package
The Berkeley DB is also backend to OpenLDAP
if you're installing the postgresql-server package.


=== Berkeley DB ===
=== Resources ===
The Berkeley Database (Berkeley DB) is a programmatic toolkit that
* Fedora Package
provides embedded database support for both traditional and
** [https://admin.fedoraproject.org/pkgdb/packages/name/db4?_csrf_token=5de54285c72440edf7bd730764e288c103731c7e db4]
client/server applications. The Berkeley DB includes B+tree, Extended
* Web
Linear Hashing, Fixed and Variable-length record access methods,
** [http://www.oracle.com/technology/products/berkeley-db/index.html Official Homepage]
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

Latest revision as of 11:13, 8 April 2021

Important.png
This page is outdated.

Firebird

Firebird

MySQL

Package Management

yum install mysql
  • Package and Version
    • mysql 5.1.39.fc12
  • dependencies which gonne be installed
    • none
  • Subpackages
    • none

Config Tools

  • Standard
    • mysql, mysql-admin
  • Webbased
    • phpmyadmin

Config Overview

  • Config files
    • /etc/my.cnf
  • Path to Database
    • /var/....

Resources

Postgresql

Berkeley DB

Idea.png
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.

Package Mangement

yum install db4
  • Package and Version
    • db4 4.7.2.fc12

Information

The Berkeley DB is also backend to OpenLDAP

Resources

sqlite

Retrieved from "https://fedoraproject.org/w/index.php?title=SIGs/Server/Databases&oldid=611378"