[Qt-interest] Qt 4.6 SQLite version

[Ed Smith-Rowland]

Thiago Macieira wrote:
> Em Sábado 17. Outubro 2009, às 12.15.51, Jan escreveu:
>   
>> SQLite version in 4.6 is still (since 4.4?) 3.5.9. Maybe there are some
>> reasons, that I do not understand to not update it. Why is 4.6 not
>> released with the latest SQLite version?
>>     
>
> Because we forgot to upgrade it.
>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> Qt-interest mailing list
> Qt-interest at trolltech.com
> http://lists.trolltech.com/mailman/listinfo/qt-interest
>   
SQLite-3.6.19 just came out with support for foreign key constraints - 
cascaded delete and update with multi-part keys.

This would make Qt-4.6 a game changer for me at least.  That means I 
don't have to fake cascade deletes with extra delete calls all the way 
down the database hierarchy.

I noticed in the source for the SQLite library under 3rdparty that you 
just had sqlite3.c sqlite3.h and, I think console.c or something.  
Whatever they have in he sqlite amalgamation tarballs.  Does that mean 
someone could just dump those three files from say sqlite-3.6.19 and 
recompile or are there Qt hooks?

If SQLite can now have multi-part keys can QSqlRelationalTableModel have 
multi-part keys?  Perhaps that is a separate question not really related 
to foreign keys.

QSqlRelation( const QString & /tableName/,
                        const QString*List* & /indexColumn/, const 
QString*List* & /displayColumn/ )
or maybe a list of pairs would be better.

I don't think QSqlRelationalDelegate would need to change in terms of 
interface.

Thanks,

Ed