I am a new django user, and so far, am loving the experience. I am still fairly new to web development as well, and was hoping someone might have the time to comment on an issue I have with django: the lack of composite key support. I know it's in the works, but I've noticed that it's an old issue, and has been a low priority for the developers. This fact is causing me to wonder if I place too much importance on having composite keys. I can easily emmulate the capabilities and behaviors of a db with composite keys within my app, but this is contrary to what I've learned to be good practice in school, at least from a db design perspective. I was wondering if someone could give their experience on the matter. I've been taught that it's good to utilize both the db and the app to maintain data integrity, but in some cases I'm coming across, it seems like the app's going to have to do all the lifting. Is this bad? Good? Neither?
The following gives an idea of the specific issue I'm having that led to these questions, but, for those whose time is short, probably isn't required reading to answer the above. With composite keys, I could attempt a write of dupicate data, and than catch the db exception to find out the data already exists. Without composite keys, it seems to me that I'll first have to perform a query to check if it's duplicate data, then another for the insert. Doubling queries seems like a bad idea. Also, it seems to me that the "where field=" query I'll have to run will be slower than it could, since it's not searching a primary key. I'm a newb though, so maybe there's something fundamental I'm missing. Thanks for any help! _________________________________________________________________ Windows Live™ SkyDrive™: Get 25 GB of free online storage. http://windowslive.com/online/skydrive?ocid=TXT_TAGLM_WL_SD_25GB_062009 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
