[geeklog-devel] Draft of schema for GL2
Tony Bibbs
tony at tonybibbs.com
Thu Dec 16 15:00:12 EST 2004
Excellent, looks like Vinny more than did his homework on this one (not
that I doubted him). I say because of this we should make the comments
part of the core...that way we can hide the complexity of the
inserts/deletes from plugin authors.
--Tony
dwight at trumbower.com wrote:
>SQL Trees and such,"comments"
>
>One of the "fathers" of SQL trees - Joe Celko.
>http://www.ibase.ru/devinfo/DBMSTrees/sqltrees.html
>
>Another decent article.
>http://www.sqlteam.com/item.asp?ItemID=8866
>
>
>
>
>>I didn't look at slashcode. But most other CMSs I looked at just grab
>>all the comments from the DB and use a recursive php algorithm. I
>>didn't see any that had an efficient (or smart) way of grabbing
>>comments.
>>
>>The implementation is original, the algorithm was spelled out in a
>>couple different places with slight variations in the details.
>>
>>-Vinny
>>
>>
>>On Thu, 16 Dec 2004 13:35:07 -0600, Tony Bibbs <tony at tonybibbs.com> wrote:
>>
>>
>>>Vincent Furia wrote:
>>>
>>>
>>>
>>>>Yes. If you look in the geeklog code for calls to SEC_inGroup() it is
>>>>really only used for the Root group. Most of the other instance
>>>>where it is used it is used against a group id variable. The
>>>>remainder I would argue are redundant if we better respected
>>>>privileges in 1.3.x. I'd recommend a "isRoot" function, but I think
>>>>"inGroup" is really not needed except when actually administering
>>>>group membership.
>>>>
>>>>
>>>>
>>>>
>>>Ok, I say we yank it...adding that column in if deemed appropriate isn't
>>>too hard.
>>>
>>>
>>>
>>>>Better names for those columns wouldn't hurt, I just couldn't come up
>>>>with anything better when I was implementing it in 1.3.x. I looked
>>>>around at other algorithms when I was first looking into improving the
>>>>performance of comments and didn't find anything better. If you do
>>>>find something let me know. This was, by far, the best I found. The
>>>>biggest downside is that I had to lock the table during inserts, but
>>>>that is really OBE since we can use transactions.
>>>>
>>>>
>>>>
>>>>
>>>Was this an original implementation or was it one you borrowed from
>>>someplace? WTF does slashcode use...you'd think they'd have to have
>>>this issue nailed down by now.
>>>
>>>--Tony
>>>_______________________________________________
>>>geeklog-devel mailing list
>>>geeklog-devel at lists.geeklog.net
>>>http://lists.geeklog.net/listinfo/geeklog-devel
>>>
>>>
>>>
>>_______________________________________________
>>geeklog-devel mailing list
>>geeklog-devel at lists.geeklog.net
>>http://lists.geeklog.net/listinfo/geeklog-devel
>>
>>
>>
>
>_______________________________________________
>geeklog-devel mailing list
>geeklog-devel at lists.geeklog.net
>http://lists.geeklog.net/listinfo/geeklog-devel
>
>
More information about the geeklog-devel
mailing list