Databases

From AdminWiki

(Difference between revisions)
Jump to: navigation, search
(Specialised Databases)
 
(15 intermediate revisions not shown)
Line 1: Line 1:
-
= Generic Databases =  
+
= SQL =
-
* MySQL
+
-
* Postgres
+
-
= Specialised Databases =
+
== [[MySQL]] ==
 +
 
 +
Database that has a SQL interface. Claims to be ACID<ref name="acid">Atomicity, Consistency, Isolation, Durability. See [http://databases.about.com/od/specificproducts/a/acid.htm The ACID model]</ref>-compliant; tries hard to. Same story as with [[Web Development|PHP]]: Large availability, everybody uses it, hardly the best choice.
 +
 
 +
Food for thought:
 +
 
 +
* [http://sql-info.de/mysql/gotchas.html MySQL Gotchas]
 +
* [http://www.databasejournal.com/features/mysql/article.php/3519116 MySQL oddities]
 +
* [http://drbrain.livejournal.com/61705.html MySQL Sucks]
 +
* [http://www.andrewsavory.com/blog/archives/000266.html MySQL sucks]
 +
* [http://habtm.com/articles/2005/05/01/tagging-again-mysql-subselects-suck MySQL subselects suck]
 +
 
 +
== [[PostgreSQL]] ==
 +
 
 +
Full-featured SQL Server. Is ACID<ref name="acid">a</ref>-compliant. Needs more maintenance than MySQL. Doesn't have native replication support.
 +
 
 +
Food for thought:
 +
 
 +
* [http://sql-info.de/postgresql/postgres-gotchas.html PostgreSQL gotchas]
 +
 
 +
== Oracle ==
 +
 
 +
The commercial behemoth.
 +
 
 +
= LDAP =
LDAP systems are like Databases too - often they build on a generic database and provide a more specialised view.
LDAP systems are like Databases too - often they build on a generic database and provide a more specialised view.
* [[OpenLDAP/slapd]]: the open source LDAP daemon
* [[OpenLDAP/slapd]]: the open source LDAP daemon
 +
* [[Novell eDirectory|Novell eDirectory/NLDAP]]: a commercial system
 +
 +
= Footnotes =
 +
 +
<references/>

Latest revision as of 00:23, 27 May 2006

Contents

SQL

MySQL

Database that has a SQL interface. Claims to be ACID[1]-compliant; tries hard to. Same story as with PHP: Large availability, everybody uses it, hardly the best choice.

Food for thought:

PostgreSQL

Full-featured SQL Server. Is ACID[1]-compliant. Needs more maintenance than MySQL. Doesn't have native replication support.

Food for thought:

Oracle

The commercial behemoth.

LDAP

LDAP systems are like Databases too - often they build on a generic database and provide a more specialised view.

Footnotes

  1. 1.1 1.2 Atomicity, Consistency, Isolation, Durability. See The ACID model
Personal tools