Is there a roadmap of major planned features in upcoming releases? I didn't see anything on the wiki or site..
Thanks, Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----Original Message----- From: Darren Duncan [mailto:[EMAIL PROTECTED] Sent: Thursday, August 02, 2007 8:44 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Implementation of ANSI SQL-92 FOREIGN KEY and referential integrity At 2:11 PM -0700 8/2/07, Mikey C wrote: >Does anyone know if there is a plan to implement the enforcement of the >SQL-92 FOREIGN KEY constraints? > >Seems to me the No.1 missing feature. After all, data integrity, even in an >embedded DB is very important and bugs in client code can easily mess up the >referential integrity. I believe that this is planned; however, some other planned upates have higher priority and are being done first. Note also that traditional foreign key constraints can only implement some kinds of business rules, and there are lots of others whose violation could cause problems, that foreign keys wouldn't help with; in theory, the more generic format of triggers is a more complete solution, or more specifically, free-form check constraints that can be comprised of any query are a more complete solution. -- Darren Duncan ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
