Lee Harr wrote:
On 2005-02-06, Brian Beck <[EMAIL PROTECTED]> wrote:
Refactoring a database on a live system is a giant pain in the ass,
simpler file-based approaches make incremental updates easier.
As much as I hate working with relational databases, I think you're
forgetting the reliability even the most poorly-designed database
provides. Continuing with the words example: assuming all words would
otherwise be stored in a table, consider the process of updating the
database schema--all entries are guaranteed to conform to the new
schema.
Not only that, but with a well-design RDBMS you can put your
schema changes inside of a transaction and make sure everything
is right before committing.
Bear in mind, however, that *most* common RDBMS will treat each DDL
statement as implicitly committing, so transactional change abilities
*don't* extend to schema changes.
Isn't there a saying like ... those who create file-based
databases are destined to re-create a relational database
management system poorly? ;o)
regards
Steve
--
Meet the Python developers and your c.l.py favorites March 23-25
Come to PyCon DC 2005 http://www.pycon.org/
Steve Holden http://www.holdenweb.com/
--
http://mail.python.org/mailman/listinfo/python-list
