Databases

From AdminWiki

(Difference between revisions)
Jump to: navigation, search
(PostgresSQL)
 
(8 intermediate revisions not shown)
Line 1: Line 1:
= SQL =
= SQL =
-
== MySQL ==
+
== [[MySQL]] ==
-
SQL server. 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.
+
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.
-
== [[PostgresSQL]] ==
+
Food for thought:
-
Full-featured SQL Server. Is ACID<ref name="acid">a</ref>-compliant. Needs more maintenance than MySQL.
+
* [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 ==
== Oracle ==
Line 17: Line 29:
* [[OpenLDAP/slapd]]: the open source LDAP daemon
* [[OpenLDAP/slapd]]: the open source LDAP daemon
-
 
+
* [[Novell eDirectory|Novell eDirectory/NLDAP]]: a commercial system
= Footnotes =
= Footnotes =
<references/>
<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