Skip to content

NJdevPro/Closure-Table

Folders and files

NameName
Last commit message
Last commit date

Latest commit

f81afae · Nov 13, 2022

History

15 Commits
Nov 13, 2022
Oct 12, 2020
Dec 16, 2021
Oct 22, 2020
Mar 14, 2019

Repository files navigation

Closure-Table

An implementation of the closure table pattern in Python + SQL

A closure table is a table that permits to represent hierarchical data or a tree structure in a SQL table and query them efficiently without having to create recursive queries.

See for instance: https://technobytz.com/closure_table_store_hierarchical_data.html

This particular program was written for use with SQLite but the SQL is standard and thus adaptation to other databases should be straightforward.

Published under MIT license

About

An implementation of the closure table pattern in Python + SQL

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages