Have all your applications with a fast, secure and reliable hosting service offered especially for Scriptcase and its applications.Learn more about our hosting plans Scriptcase is also a web system and runs within a browser, this allows the collaborative development, in other words, more than one person working at the same time with the same environment through local networks or in the cloud. Scriptcase evolves continuously by adopting major innovations in the technological market.Hierarchical data can be found in a variety of database applications, including forum and mailing list threads, business organization charts, content management categories, and product categories.For our purposes we will use the following product category hierarchy from an fictional electronics store: These categories form a hierarchy in much the same way as the other examples cited above.Scriptcase offers an XLS, CSV and ACCESS spreadsheet import and conversion features for the databases supported by Scriptcase.
The first common task when dealing with hierarchical data is the display of the entire tree, usually with some form of indentation.
Connect with your database (My SQL, Maria DB, Postgre SQL, SQLite, Interbase, SQL Azure, Amazon Aurora, Firebird, Access, Oracle, MS SQLServer, DB2, Sy Base, Informix or ODBC layer) and generate web applications based on your tables, simply and safely.
Make the data access and maintenance an uncomplicated step!
Before being able to see the full path of a category we have to know the level at which it resides.
In addition, special care must be taken when deleting nodes because of the potential for orphaning an entire sub-tree in the process (delete the portable electronics category and all of its children are orphaned).
Hierarchical data has a parent-child relationship that is not naturally represented in a relational database table.