That is all good :) I'm mostly aware of the possibilities I had offered to me the last time I set up my developing environmenta and the db design decision I had to make accordingly. I guess in less then a year, when 4.x will have some good mileage, I'll set myself a new developing environment and rethink my future database logics. Some of those features will help a lot.
> Please allow me to clarify a few items here, since we don't want > misunderstandings to linger around forever.... > > 1) MySQL supports transactions since 3.23.34a, with the InnoDB and BDB > table types. > Using the the InnoDB table handler you have commit, rollback, crash > recovery capabilities, row level locking, consistent non-locking read, > and much more... See http://www.mysql.com/doc/I/n/InnoDB.html and > elsewhere in the manual for heaps of info. > > 2) Foreign keys are supported by the InnoDB table handler from 3.23.44. > http://www.mysql.com/doc/S/E/SEC427.html > > 3) The other items you mentioned are already part of the 4.x development > track. > http://www.mysql.com/doc/N/u/Nutshell_4.1_development_release.html > For the curious: implementation of these new features should not > adversely affect your performance if you don't use the features. In > simple terms: trust Monty! ;-) > > 4) Finally, MySQL does in fact have a NO DEFAULT option. This was kindly > pointed out by Paul DuBois a few days ago. > The DONT_USE_DEFAULT_FIELDS compile time option has existed since as > early as version 3.20.14. > From the manual: > "You can configure MySQL not to use DEFAULT column values for non-NULL > columns (that is, columns that are not allowed to be NULL). This causes > INSERT statements to generate an error unless you explicitly specify > values for all columns that require a non-NULL value." > See http://www.mysql.com/doc/c/o/configure_options.html > I do believe this option addresses the issue put forward by Frank and > Shelby. > > > Regards, > Arjen. > > -- > MySQL Training Worldwide, http://www.mysql.com/training/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer > /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia > <___/ www.mysql.com > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
