Re: [Dbix-class] Representing directory structures

2013-04-08 Thread Len Jaffe
On Sun, Apr 7, 2013 at 6:19 PM, Bill Moseley mose...@hank.org wrote: 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

Re: [Dbix-class] Representing directory structures

2013-04-08 Thread Dave Howorth
Bill Moseley wrote: 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. Just a thought, and

Re: [Dbix-class] Representing directory structures

2013-04-08 Thread Peter Rabbitson
On Mon, Apr 08, 2013 at 02:43:12AM -0400, Len Jaffe wrote: On Sun, Apr 7, 2013 at 6:19 PM, Bill Moseley mose...@hank.org wrote: 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

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

2013-04-08 Thread Brendan Byrd
On Sun, Apr 7, 2013 at 3:21 PM, Mario Minati mario.min...@minati.de wrote: 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. I was going to

Re: [Dbix-class] Representing directory structures

2013-04-08 Thread Bill Moseley
On Mon, Apr 8, 2013 at 1:30 AM, Dave Howorth dhowo...@mrc-lmb.cam.ac.ukwrote: Bill Moseley wrote: 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