This software implements Materialized Path, a hierarchical data storage technique, for SQLAlchemy. It allows for efficient navigation and manipulation of nested data structures in a SQL database.
With Sqlamp, you can save node roots and child nodes effortlessly. The utility fields are automatically set by the software, leaving you with less manual work to do. Fetching a node's descendants, ancestors, and children have never been more efficient. The software is designed to autocheck exhaustion of tree size limits during session flush, saving you from last-minute errors.
Sqlamp offers more features such as rebuilding all trees and any subtree on the basis of Adjacency Relations and collapsing a flat tree returned from queries to recursive structure. However, moving of nodes is not yet implemented.
The software has been tested and known-to-work with SQLite version 3.6.14, MySQL using both MyISAM and InnoDB with server version 5.1.34, and PostgreSQL version 8.3.7. Sqlamp is designed to work with any DBMS supported by SQLAlchemy.
Overall, Sqlamp is a great software for managing hierarchical data structures with ease and efficiency. Its comprehensive features and compatibility options make it a valuable addition to any project. Visit the project's homepage for more information.
Version 0.5: N/A