Welcome to Squishdot How-To Newbies Squishdot
 post article
 Mailing Lists
 Bug Tracking


Is Squishdot's backend ACID compliant?
Newbies Posted by Daniel C. Silverstein on Monday May 14, 01:23PM, 2001
from the database-weenies dept.
Recently, I've been talking with some friends about running a news/discussion site with the potential to generate a significant volume of traffic. Someone suggested Squishdot as a possibility. I've done a little digging, but have been unable to discern whether or not the Squishdot backend is ACID-compliant. Can anyone out there help?

For anyone not familiar with the acronym, ACID means: Atomicity, Consistency, Isolation, and Durability. It's the test database folks use to define what it means to be a correctly functioning, fault-tolerant database.

Atomicity - All elements of a given transaction take place or none do.

Consistency - Each transaction transforms the database from one valid state to another valid state.

Isolation - The effects of a transaction are not visible to other transactions in the system until it is complete.

Durability - Once a transaction has been committed, it's effects are permanent-- even if the system crashes, or a disk dies.

To make a long story short, ACID compliant systems are provably correct. Non-ACID compliant systems will, under the right (wrong?) circumstances, corrupt themselves in any manner of ways. A site that requires large volumes of database queries is almost certain to make a non-ACID compliant db nuke.

Though I've got a good deal of programming experience, I'm not particularly familiar with Python or Zope. The ACID test is normally applied to Relational Database Management Systems (RDBMSs), which are based on set theory. Nevertheless, it's applicable to databases based on other paradigms, such as Object-Oriented Database Management Systems. Perhaps the ACID test is inapplicable to Squishdot's backend, but I'm betting it is.

<  |  >


Related Links
  • Articles on Newbies
  • Also by Daniel C. Silverstein
  • Contact author
  • File Attachment
  • Click to download attachment
    0KB (0 bytes)

  • The Fine Print: The following comments are owned by whoever posted them.
    ( Reply )

    by Chris Withers on Monday May 14, 01:36PM, 2001
    Zope is ACID compliant in the way you describe.

    Hence, Squishdot is too :-)


    [ Reply to this ]
    The Fine Print: The following comments are owned by whoever posted them.
    ( Reply )

    Powered by Zope  Squishdot Powered
      "Any system that depends on reliability is unreliable." -- Nogg's Postulate
    All trademarks and copyrights on this page are owned by their respective companies. Comments are owned by the Poster. The Rest ©1999 Butch Landingin, ©2000-2002 Chris Withers.