That's exactly how I do it.

IWETHEY v. 0.3.0 | TODO

1,095 registered users | 1 active user | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #158,628

by admin

6/6/04 7:19:32 AM

That's exactly how I do it.

Each thread (top level message) is its own tree.

This version separates the tree data from the content data, but it's a pain in the ass to deal with. The new one keeps them in the same table.

Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."

Post #158,646

by ChrisR

6/6/04 2:12:53 PM

Guess I'll have to try it for myself

I figure a view would be in order for the times I need to merge the tree data with the data itself. The problem in my case is that I have to keep historical data on the values (similar to you keeping the edit history on the messages), but the tree data only needs to be current (or if it needs to be kept, it needs to have it's own archive seperate from the rest).

How to store a tree structure in a relational db? - (bluke) - (20) - June 3, 2004, 04:21:24 PM EDT

Ask Bryce! - (folkert) - (1) - June 3, 2004, 04:25:06 PM EDT

wiki links - (tablizer) - June 3, 2004, 11:57:01 PM EDT

Which database engine? - (admin) - (2) - June 3, 2004, 05:43:22 PM EDT

Re: Which database engine? - (bluke) - (1) - June 4, 2004, 01:46:02 AM EDT

CONNECT BY is out then. :-) - (admin) - June 4, 2004, 08:06:33 AM EDT

why not store it in a document - (boxley) - (1) - June 3, 2004, 05:47:47 PM EDT

We want to move away from LDAP ... - (bluke) - June 4, 2004, 02:06:02 AM EDT

Just use Windows Server 2003 and Active Directory! - (pwhysall) - (1) - June 3, 2004, 05:54:38 PM EDT

**thwak!** -NT - (jb4) - June 4, 2004, 02:10:53 PM EDT

See what Scott said - (ben_tilly) - (2) - June 3, 2004, 08:02:09 PM EDT

Before 9i - (admin) - (1) - June 3, 2004, 10:27:08 PM EDT

I don't use it, so I wouldn't know. Correction appreciated. -NT - (ben_tilly) - June 3, 2004, 10:45:47 PM EDT

Re: How to store a tree structure in a relational db? - (johnu) - (7) - June 4, 2004, 08:16:45 AM EDT

AKA Nested Set Trees. :-) -NT - (admin) - (6) - June 4, 2004, 08:54:08 AM EDT

After reading about nested sets ... - (bluke) - (5) - June 5, 2004, 02:29:53 PM EDT

Updates aren't an issue. - (admin) - (3) - June 5, 2004, 04:48:38 PM EDT

If I had to do it over.... - (ChrisR) - (2) - June 5, 2004, 11:27:30 PM EDT

That's exactly how I do it. - (admin) - (1) - June 6, 2004, 07:19:32 AM EDT

Guess I'll have to try it for myself - (ChrisR) - June 6, 2004, 02:12:53 PM EDT

We have a lot of inserts - (bluke) - June 6, 2004, 05:24:23 AM EDT

iwethey.org