Forum Moderators: open
I'm developing a groupware site from scratch and will be using MySQL to track all the URLs and documents. It's on an intranet, and actual site pages/content are documents secured at the folder level based on company logins which are changed company-wide every 3 months (thus not using a site registration). The database will just have links to the docs in the db.
There will be as many as 3 levels of categories for the documents and I have reviewed both the hierarchical style and the relational style of db, but not sure which to use.
The issue I have is that once this site is done, I won't be here and someone else who doesn't have a lot of time or web background will be administering the site. They'd be adding new projects, folders, documents, categories, etc. through a form I'll provide. Therefore, I'm leaning more towards Relational because it is more well-understood and someone else could walk in and more easily manage the database if needed.
Does anybody have any recommendations or ideas?
Thanks
:)
On a Windows server you would use Active Directory and Index Server for managing all the permissions, categories and storage and just write a script to search and display them.
The script would talk to Active Directory and Index Server objects rather than the File system directly.
