Databases
From AdminWiki
(Difference between revisions)
m (→MySQL) |
m (→PostgresSQL) |
||
| (3 intermediate revisions not shown) | |||
| Line 1: | Line 1: | ||
= SQL = | = SQL = | ||
| - | == [MySQL] == | + | == [[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. | 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. | ||
| Line 13: | Line 13: | ||
* [http://habtm.com/articles/2005/05/01/tagging-again-mysql-subselects-suck MySQL subselects suck] | * [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. | + | 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: | Food for thought: | ||
| - | * [http://sql-info.de/postgresql/postgres-gotchas.html | + | * [http://sql-info.de/postgresql/postgres-gotchas.html PostgreSQL gotchas] |
== Oracle == | == Oracle == | ||
| Line 29: | 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.
- OpenLDAP/slapd: the open source LDAP daemon
- Novell eDirectory/NLDAP: a commercial system
Footnotes
- ↑ 1.1 1.2 Atomicity, Consistency, Isolation, Durability. See The ACID model
