[Dbix-class] Representing directory structures

2013-04-07 Thread Bill Moseley
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

Re: [Dbix-class] Representing directory structures

2013-04-07 Thread Peter Rabbitson
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 the

AW: [Dbix-class] WG: using DBIx::Class::Migration with Journal

2013-04-07 Thread Mario Minati
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

Re: [Dbix-class] Representing directory structures

2013-04-07 Thread Len Jaffe
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

Re: [Dbix-class] Representing directory structures

2013-04-07 Thread Bill Moseley
On Sun, Apr 7, 2013 at 12:40 PM, Len Jaffe lenja...@jaffesystems.comwrote: 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)

Re: [Dbix-class] Representing directory structures

2013-04-07 Thread Ben Tilly
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 mose...@hank.org wrote: Anyone using DBIC to represent