On Mon, 2003-12-01 at 13:13, Chris Mason wrote: > On Mon, 2003-12-01 at 05:39, Ilja Booij wrote: > > > We'd like to use transactions, and make better use of foreign keys. It > > would be easiest to ditch MySQL ISAM tables completely, so that the we > > can use those features, and let > > the database handle the integrity of the tables. The less db-handling > > code in DBMail, the better. > > > > I guess we need some discussions about this in this list and here at > > IC&S. > > Transactions will make things faster overall, and could really reduce > code complexity. I would suggest dropping the ISAM support, people that > really need it can stay at 1.2
I couldn't agree more. Use the database as a database, not as just some type of fancy flat file. Use it to guarantee data integrity and reduce code complexity.