On Sun, Apr 7, 2013 at 6:19 PM, Bill Moseley wrote:
>
> On Sun, Apr 7, 2013 at 12:40 PM, Len Jaffe wrote:
>
>> In my opinion, the best way to model a tree in an RDBMS is to use
>> Materialized Path.
>>
>> I found the amount of work involved in each insert/delete of a nested set
>> to be too great
http://www.ibase.ru/devinfo/DBMSTrees/sqltrees.html is a good read for
anyone who wants to construct hierarchical data structures. It would
need some modification to handle "shared folders."
On Sun, Apr 7, 2013 at 11:42 AM, Bill Moseley wrote:
> Anyone using DBIC to represent hierarchal director
On Sun, Apr 7, 2013 at 12:40 PM, Len Jaffe wrote:
> In my opinion, the best way to model a tree in an RDBMS is to use
> Materialized Path.
>
> I found the amount of work involved in each insert/delete of a nested set
> to be too great, and adjacency lists (parent pointer) fails to allow for
> retr
In my opinion, the best way to model a tree in an RDBMS is to use
Materialized Path.
I found the amount of work involved in each insert/delete of a nested set
to be too great, and adjacency lists (parent pointer) fails to allow for
retrieving all of a tree or subtree with one round-trip to the db.
Further investigations let my understand that DBIx::Class::Journal keeps a
special journaling schema for all journaled records.
I'll try to extend DBIx::Class::Migration to handle this.
Best greets,
Mario
Von: Mario Minati [mailto:mario.min...@minati.de]
Gesendet: Samstag, 6. April 2013 12:46
On Sun, Apr 07, 2013 at 11:42:01AM -0700, Bill Moseley wrote:
>
> Postgresql has "WITH RECURSIVE" which DBIC has no support for (other than
> virtual views):
>
I do not have a coherent opinion/advice on your actual question, however
some pointers on the above statement. Perhaps you can cleanup t
Anyone using DBIC to represent hierarchal directory (folder) structures?
Essentially just like a file system, except users each have their own root.
To add to the complexity, I need to be able to "share" folders and all
child elements to other users.
My assumption is this would involve a single