petrounias/django-cte-trees

SQLite Support

Opened this issue · 1 comments

It would be great to have SQLite support even if that layer is emulated inefficiently.

According to this: http://en.wikipedia.org/wiki/Hierarchical_and_recursive_queries_in_SQL#Common_table_expression SQLite should support CTEs.

See "Quick note on recursion" in: http://charlesleifer.com/blog/querying-tree-structures-in-sqlite-using-python-and-the-transitive-closure-extension/

django-tree-queries is a small library inspired by django-cte-trees; it has less features, a smaller API surface but on the upside it does support sqlite and mariadb too, not only postgres

https://github.com/matthiask/django-tree-queries