ACID For Databases

ACID: Atomicity, Consistency, Isolation, and Durability

ACID properties are an important concept for databases. The acronym stands for Atomicity, Consistency, Isolation, and Durability. The ACID properties apply to both ODBMSs and RDBMSs.

ACID is a database design term

ACID Stands for Atomicity, Consistency, Isolation, and Durability. Here's a good definition of those terms from www.whatis.com:

Atomicity. In a transaction involving two or more discrete pieces of information, either all of the pieces are committed or none are.

Consistency. A transaction either creates a new and valid state of data, or, if any failure occurs, returns all data to its state before the transaction was started.

Isolation. A transaction in process and not yet committed must remain isolated from any other transaction.

Durability. Committed data is saved by the system such that, even in the event of a failure and system restart, the data is available in its correct state

Foreign Key Support

Just to point out an error: Foreign key support is available via InnoDB as well.

Also, under performance, InnoDB performs even faster than normal MySQL.

Also, unless I am mistaken, PostgreSQL is available via windows through Cgywin. This should be mentioned.

Considering that yes, the author did say he was refering to the default installation, that really isn't fair. Default installations are just that, default. They shoudlnt' contain extra stuff you don't need. So if you want somethign, you add it in when you need it.

That being said, I agree with this article, it's a fair comparison.