Skip to content

An implementation of the closure table pattern in Python + SQL

License

Notifications You must be signed in to change notification settings

NJdevPro/Closure-Table

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 
 
 
 
 

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

Releases

No releases published

Packages

No packages published

Languages