Re: [Django] #8946: Denormalisation built in to the ORM

[Django]

#8946: Denormalisation built in to the ORM
-+-
 Reporter:  simon|Owner:  nobody
 Type:  New feature  |   Status:  closed
Component:  Database layer   |  Version:  1.0
  (models, ORM)  |   Resolution:  wontfix
 Severity:  Normal   | Triage Stage:
 Keywords:  djangocon|  Someday/Maybe
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by akaariai):

 * status:  new => closed
 * resolution:   => wontfix


Comment:

 I'm going to close this. Reasons:
   - It seems this could be implemented perfectly well in 3rd party apps
 (with maybe some added hooks in core)
   - This seems really, really hard to do in cross-db compliant way,
 supporting all the different ORM queries we have (update() etc), and with
 concurrency tackled. Raw SQL would get past us in any case
   - There are different use cases which would benefit from different
 approaches, again pointing to 3rd party apps
   - No action in 4 years
   - This ticket doesn't have much useful information

 If somebody has plans do something about this, please reopen.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [Django] #8946: Denormalisation built in to the ORM

[Django]

#8946: Denormalisation built in to the ORM
---+
  Reporter:  simon | Owner:  nobody   
Status:  new   | Milestone:   
 Component:  Database layer (models, ORM)  |   Version:  1.0  
Resolution:|  Keywords:  djangocon
 Stage:  Someday/Maybe | Has_patch:  0
Needs_docs:  0 |   Needs_tests:  0
Needs_better_patch:  0 |  
---+
Changes (by thejaswi_puthraya):

  * component:  Uncategorized => Database layer (models, ORM)

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #8946: Denormalisation built in to the ORM

[Django]

#8946: Denormalisation built in to the ORM
+---
  Reporter:  simon  | Owner:  nobody   
Status:  new| Milestone:   
 Component:  Uncategorized  |   Version:  1.0  
Resolution: |  Keywords:  djangocon
 Stage:  Someday/Maybe  | Has_patch:  0
Needs_docs:  0  |   Needs_tests:  0
Needs_better_patch:  0  |  
+---
Changes (by jacob):

  * stage:  Unreviewed => Someday/Maybe

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #8946: Denormalisation built in to the ORM

[Django]

#8946: Denormalisation built in to the ORM
+---
  Reporter:  simon  | Owner:  nobody   
Status:  new| Milestone:   
 Component:  Uncategorized  |   Version:  1.0  
Resolution: |  Keywords:  djangocon
 Stage:  Unreviewed | Has_patch:  0
Needs_docs:  0  |   Needs_tests:  0
Needs_better_patch:  0  |  
+---
Changes (by alexkoshelev):

 * cc: [EMAIL PROTECTED] (added)

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #8946: Denormalisation built in to the ORM

[Django]

#8946: Denormalisation built in to the ORM
+---
  Reporter:  simon  | Owner:  nobody   
Status:  new| Milestone:   
 Component:  Uncategorized  |   Version:  1.0  
Resolution: |  Keywords:  djangocon
 Stage:  Unreviewed | Has_patch:  0
Needs_docs:  0  |   Needs_tests:  0
Needs_better_patch:  0  |  
+---
Comment (by mtredinnick):

 Contrary to Simon's request, let's please keep design discussion on the
 mailing list, as per normal. That way everybody can participate and
 there's a record. Tickets are terrible for design discussions. Yes, it
 might have to wait for a lull in other active conversations. Thankfully,
 we don't have to solve every problem in the next week or even the next
 month.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #8946: Denormalisation built in to the ORM

[Django]

#8946: Denormalisation built in to the ORM
+---
  Reporter:  simon  | Owner:  nobody   
Status:  new| Milestone:   
 Component:  Uncategorized  |   Version:  1.0  
Resolution: |  Keywords:  djangocon
 Stage:  Unreviewed | Has_patch:  0
Needs_docs:  0  |   Needs_tests:  0
Needs_better_patch:  0  |  
+---
Comment (by Erik Allik <[EMAIL PROTECTED]>):

 In addition to the count of a set of related fields, also max/min/avg. For
 example one would want to store the creation date of the newest comment of
 an article because articles are often sorted by activity.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #8946: Denormalisation built in to the ORM

[Django]

#8946: Denormalisation built in to the ORM
+---
  Reporter:  simon  | Owner:  nobody   
Status:  new| Milestone:   
 Component:  Uncategorized  |   Version:  1.0  
Resolution: |  Keywords:  djangocon
 Stage:  Unreviewed | Has_patch:  0
Needs_docs:  0  |   Needs_tests:  0
Needs_better_patch:  0  |  
+---
Changes (by simon):

  * needs_better_patch:  => 0
  * needs_tests:  => 0
  * needs_docs:  => 0

Comment:

 Some common denormalisations:

 * A field maintains the count of a set of related fields, e.g. a forum
 Thread storing the number of Replies belonging to that thread.
 * A field is calculated from another field using an expensive operation.
 For example, rendering HTML using markdown.
 * A field from a joined table is frequently used for lookups, so is copied
 to the parent table to avoid having to make a join.

 Please add more!

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---