dbrobins Wrote:Unless there's a good reason why this is infeasibleIt's definitely feasible.
dbrobins Wrote:Things are already being done quietly by firnsy or othersIndeed things are happening in the background, though these are focussed towards a completely revised schema. You'll be happy to know that FOREIGN keys are leveraged heavily in it. Currently I'm benchmarking an EAV/CR schema that will provide foundation for all content (eg. audio, video, pictures, etc).
dbrobins Wrote:I will attempt to add foreign keys in my database (using SQLite), and, all going well, make a patch to create them in the table creation/update code and add it to a Trac ticket. (And perhaps implement some of the other ideas above too.)
CC me on the trac patch and I'll review it for inclusion.