Databases
From AdminWiki
(Difference between revisions)
m (→PostgresSQL) |
m (→PostgresSQL) |
||
| 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. Doesn't have native replication support. | Full-featured SQL Server. Is ACID<ref name="acid">a</ref>-compliant. Needs more maintenance than MySQL. Doesn't have native replication support. | ||
| Line 19: | Line 19: | ||
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 == | ||
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
