Re: [Vfs-devel] Directories

[Tony K. <tk...@ca...>]

> As for the techincal structure of the database. I had something like this
in
> mind:
>
... [Long bits of tech talk cut out :) ] ...
>
> If the user had an entry for a dir_id in read_dir he would be able to see
all
> files in that directory. Note, he would still need download permission to
> actually get any of the files so he might be able to see that a file
exists
> but not have permission to download it.
>
> Similarly for the write. If he had an entry he could create directories
and
> upload files into that directory.
>

This all sounds good to me. In fact it is exactly like my first of two ideas
for this. I'm using this same structure for the app I'm writing for the
company I work for. Using it to store tasks and sub-tasks for employees. It
works out very well unless you try to display the entire tree :). The SQL
behind that call (trying to let the server put the whole tree in order for
you) can be a pain to get working. I wonder if Postgres or MySQL has
functions to help out there. MSSQL7 doesn't. Besides sorting by $parent_id
then $child_id and then grouping here and there and... ARG!! bad flashback
to a late night working this out one night. OK, I'm over it now. :)

Regards,
Tony Kirk