Databases
From AdminWiki
(Difference between revisions)
(→PostgresSQL) |
(→MySQL) |
||
| Line 4: | Line 4: | ||
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. | 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. | ||
| + | |||
| + | 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] | ||
== [[PostgresSQL]] == | == [[PostgresSQL]] == | ||
Revision as of 00:33, 25 May 2006
Contents |
SQL
MySQL
SQL server. 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:
PostgresSQL
Full-featured SQL Server. Is ACID[1]-compliant. Needs more maintenance than MySQL.
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
Footnotes
- ↑ 1.1 1.2 Atomicity, Consistency, Isolation, Durability. See The ACID model
