Wednesday, November 29, 2017

RE: Recursive Queries - CTEs

I've done more research.  The proper term of these Recursive Queries is Common Table Expressions (CTEs).  I learned that a developer had already worked on trying to get these in Django more towards the beginning of this year, but it doesn't look like it was taken.

 

Django-mptt looks like it will do I what I need it to do, but it's not what I really…want.  It adds all this extra overhead to traverse a tree, but modern databases can utilize the WITH RECURSIVE statement to get the same results.

 

From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] On Behalf Of Jason
Sent: Wednesday, November 29, 2017 1:44 PM
To: Django users
Subject: Re: Recursive Queries

 

If I understand you correctly, you're looking for something similar to a tree structure, but with a regular SQL db.

 

If so, there are two projects you can consider:

 

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/2eaf6b1e-984c-4e5b-9c0a-6f08211b3aef%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment