On Wednesday 25 October 2006 17:36, Oleg Broytmann wrote:
> On Wed, Oct 25, 2006 at 02:18:40PM +0000, Matthew Wilson wrote:
> > I created the following two tables, ran the sql, and then discovered
> > that the foreign keys were not in the database:
> Foreign key constraints will be implemented in SQLObject 0.8. You
> can try SQLObject from the SVN trunk.
Will it be possible to still use the current capability of SQLObject to
use foreign keys even on tables that are not capable of such thing
internally (like with mysql's myisam tables)?
In other words my question is if this new database key constraint
implementation will replace the current behavior or will they both be
I agree that the current behavior is less efficient as it has to do all
the work internally and involves a lot of sql queries to perform a
cascaded delete for example but it works on any type of database even if
it doesn't support key constrains, so having it around for such cases
would still be useful.