On Jan 4, 9:16 am, Venkatraman S <venka...@gmail.com> wrote: > On Wed, Jan 4, 2012 at 6:50 PM, Andre Terra <andrete...@gmail.com> wrote: > > You won't need to write raw SQL in Django until you've reached a big > > bottleneck, and one that can't be solved in any other way. Writing raw SQL > > is exactly what Django wants you to *stop* doing. The ORM doesn't only > > exist in order to speed up development. It provides a layer of abstraction > > that also allows for easy refactoring and code improvement. SQL is not as > > flexible. > > I havent read the rest of the thread; but I agree with what you mentioned > in your reply, with suitable reservations on the above comment. > > SQL is highly flexible provided you know to write good sql (its like the > way Russell mentions 'It Depends' :P ); atleast i have been writing sqls > for the past 8 years and i find it easy to write them when the > relationships are complex. I come from a database family, and writing > highly database cohesive apps is what i have been doing for quiet sometime. > And it is very much given that, if you are writing a reporting app with > 30-40 tables, then you would end up writing raw sqls(this is NOT the norm > for a non-reporting app). > > But when i mention the above, i also see that django ORM produces some > really nice SQLs for mediocre usecases, i.e, i am yet to stumble on a case > wherein the SQL produced by the ORM wouldnt be the same(tuned) as what i > would write. So Kudos over there. In my spare time, i always mess around > with hierarchical queries and what not to see what the django-orm produces > and i must say that it has been a good learning experience. > > To cut verbiage/or to summarize...and...Not to confuse the OP : yes, as > Andre mentions, if you do not have any advance use cases; go ahead with > django orm. It wouldnt give you any sleepless nights. > > -Venkat
Thanks for the advice Venkat. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
