Databases
From AdminWiki
(Difference between revisions)
m (→PostgresSQL) |
|||
| (17 intermediate revisions not shown) | |||
| Line 1: | Line 1: | ||
| - | = | + | = SQL = |
| - | = | + | == [[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 |
| + | * [[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.
- 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
