phpgedview-talk

[Phpgedview-talk] Places Hierarchy

[Nathan S. H. <nat...@uk...>]

I'm pretty new to phpgedview, but I have some experience with PHP and
MySQL. I may have some input to the way places are stored, but first I
have a few questions:

1) What's the difference between the pgv_places and pgv_placelocation
tables?
2) Does the hierarchical structure have to be stored using a parent_id
to link the child to it's parent?
    a) Is anyone aware of the nested sets model for storing hierarchies?
I believe there are several features that would make this implementation
of a hierarchy beneficial to PGV. I have some PHP code that I use for
doing hierarchy manipulations, e.g. adding/deleting nodes etc

Anyway, I'll await responses from those more in the known about PGV.

Cheers
Nathan

[Phpgedview-talk] Places Hierarchy

[Nathan S. H. <nat...@uk...>]

I'm pretty new to phpgedview, but I have some experience with PHP and
MySQL. I may have some input to the way places are stored, but first I
have a few questions:

1) What's the difference between the pgv_places and pgv_placelocation
tables?
2) Does the hierarchical structure have to be stored using a parent_id
to link the child to it's parent?
    a) Is anyone aware of the nested sets model for storing hierarchies?
I believe there are several features that would make this implementation
of a hierarchy beneficial to PGV. I have some PHP code that I use for
doing hierarchy manipulations, e.g. adding/deleting nodes etc

Anyway, I'll await responses from those more in the known about PGV.

Cheers
Nathan

Re: [Phpgedview-talk] Places Hierarchy

[John F. <Joh...@ne...>]

PiAxKSBXaGF0J3MgdGhlIGRpZmZlcmVuY2UgYmV0d2VlbiB0aGUgcGd2X3BsYWNlcyBhbmQgcGd2
X3BsYWNlbG9jYXRpb24NCj4gdGFibGVzPw0KDQpwZ3ZfcGxhY2VzIGNvbnRhaW5zIHRoZSBwbGFj
ZXMgYXMgdGhleSB3ZXJlIHJlY29yZGVkIGluIHlvdXIgZ2VkY29tIGZpbGUuDQoNCnBndl9wbGFj
ZWxvY2F0aW9uIGlzIHVzZWQgYnkgdGhlIGdvb2dsZW1hcCBtb2R1bGUgdG8gbWFwIHBsYWNlcyBm
cm9tIHlvdXIgZ2VkY29tIGZpbGUgdG8gbGF0aS9sb25nIGNvcmRzIGZvciB0aGUgbWFwLg0KDQpU
aGVyZSBoYXMgYmVlbiBkaXNjdXNzaW9uIGFib3V0IHRoaXMsIGFuZCBwcm9iYWJseSBpbiB0aGUg
ZnV0dXJlIHlvdSB3aWxsIHNlZSB0aGUgdGFibGVzIG1lcmdlZC4gIFJlZmVyIHRvIHRoaXMgZm9y
dW0gdGhyZWFkOg0KaHR0cHM6Ly9zb3VyY2Vmb3JnZS5uZXQvZm9ydW0vZm9ydW0ucGhwP3RocmVh
ZF9pZD0xNjYzNTQ1JmZvcnVtX2lkPTE4NTE2NQ0KDQoNCj4gMikgRG9lcyB0aGUgaGllcmFyY2hp
Y2FsIHN0cnVjdHVyZSBoYXZlIHRvIGJlIHN0b3JlZCB1c2luZyBhIHBhcmVudF9pZA0KPiB0byBs
aW5rIHRoZSBjaGlsZCB0byBpdCdzIHBhcmVudD8NCj4gICAgIGEpIElzIGFueW9uZSBhd2FyZSBv
ZiB0aGUgbmVzdGVkIHNldHMgbW9kZWwgZm9yIHN0b3JpbmcgaGllcmFyY2hpZXM/DQo+IEkgYmVs
aWV2ZSB0aGVyZSBhcmUgc2V2ZXJhbCBmZWF0dXJlcyB0aGF0IHdvdWxkIG1ha2UgdGhpcyBpbXBs
ZW1lbnRhdGlvbg0KPiBvZiBhIGhpZXJhcmNoeSBiZW5lZmljaWFsIHRvIFBHVi4gSSBoYXZlIHNv
bWUgUEhQIGNvZGUgdGhhdCBJIHVzZSBmb3INCj4gZG9pbmcgaGllcmFyY2h5IG1hbmlwdWxhdGlv
bnMsIGUuZy4gYWRkaW5nL2RlbGV0aW5nIG5vZGVzIGV0Yw0KDQpZZXMsIEkgYW0gYXdhcmUgb2Yg
dGhlIG5lc3RlZCBzZXRzIG1vZGVsLiAgSSd2ZSBhY3R1YWxseSB0cmllZCB0byBhcHBseSBpdCB0
byB0aGUgcGVvcGxlIHNvIHRoYXQgeW91IGNvdWxkIGVhc2lseSBmaW5kIGFsbCB0aGUgZGVzY2Vu
ZGVudHMgb2YgYSBwZXJzb24uICBCdXQgaXQgYmVjb21lcyB0b28gY29tcGxpY2F0ZWQgd2l0aCBw
ZW9wbGUuICBJdCB3b3VsZCBwcm9iYWJseSB3b3JrIHdpdGggdGhlIHBsYWNlcy4NCg0KQnV0LCB0
aGUgZnV0dXJlIGRpcmVjdGlvbiBvZiBwbGFjZXMgaXMgdG8gYWxsb3cgdGhlbSB0byBoYXZlIHRo
ZWlyIG93biBsZXZlbCAwIHJlY29yZC4gIFNvIHBsYWNlcyB3aWxsIGJlIGNoYW5naW5nIHF1aXRl
IGEgYml0IGluIGZ1dHVyZSByZXZpc2lvbnMgb2YgUEdWLg0KDQpUaGFua3MsDQotLUpvaG4NCg==