Re: Help with designing threaded discussion group

Jakobo wrote:
> Im trying to design a threaded discussion group in an intranet
> application. Basicly i want to design the database and the subsequent
> sql statements so that i put a minimum of workload on the server/client
> handling the application, avoiding looping through large arrays. I want
> to be able to get all the root posts of the group, and unfold one of
> these root posts showing all the underlaying posts in a hierarchical
> tree structure. Have so far planned for following properties of a table
> design (holding a single discussion group); field0 - post id (auto
> number), thread - (post id of root), answer (post id of parent)
> together with other fields reg. the post itself (author, date, subject,
> mess. text).

Having performed this task from scratch several times myself, I have
one recommendation to you above all else: look at someone else's code.
I once was naive enough to think i could reinvent the wheel (but better
of course, superior road traction maybe), and it was only when I
downloaded PHPBB and had a look at their source code that I realised
just how much I had to learn about engineering even something as
relatively simple as a bulletin board.

While I don't use the software any long, head to
www.phpbb.net/downloads and take a look at their source. Its free, and
it's a good clear structure.

all best, Jim.

> Can anybody please help with idears about how I should design the table
> and/or construct sql statements so that i can retrieve data from a
> record set and put them in a hierarchical structure without having to
> loop through large arrays. Im working in a windows invironment, using
> IIS, mysql, vbscript serverside, jscript clientside.
> regards
> Jakob Outzen

.

Relevant Pages

  • Help with designing threaded discussion group
    ... Im trying to design a threaded discussion group in an intranet ... sql statements so that i put a minimum of workload on the server/client ... these root posts showing all the underlaying posts in a hierarchical ... tree structure. ...
    (comp.databases.theory)
  • Re: CPU recommendations?
    ... done well, classes, templates, and stronger typing can give you a better development environment (clearer and safer source code and at least as small and fast object code). ... C has so many design faults there is no space to list them here. ... inheritance will make an AVR run like an 8051, and multiple inheritance will turn your source code into Greek). ...
    (comp.arch.embedded)
  • Re: Report from the LuxAsm mailing list for Betov
    ... You will be able to use LuxAsm as a command-line tool - like any other - ... for use with, for example, "makefiles" and so forth...if the editor crashes ... I've thought of this...and it was a _DELIBRATE_ design decision ... the assembler's "assemble" service and then pass it source code and it'll ...
    (alt.lang.asm)
  • Re: Embedded processor (and OS, tools) selection for long-life product
    ... This is industrial safety monitoring equipment that also has to meet some minimal radiation rating. ... The biggest change is to add an ethernet port which could be satisfied by some kind of separate serial to ethernet adaptor design as long as all the IP were available. ... The original system design used the Intel i960 running the Intel iRMK kernel. ... You need to make sure that you get the source code for the entire design as well as the source code for the entire toolchain. ...
    (comp.arch.embedded)
  • Re: Interested about number crunching in Ada
    ... Honeywell Bull had to pay DEC for the source code of those close ... source code libraries. ... Honeywell Bull under contract to the US DOD in 77. ... The Design is a far cry from the true copyright, ...
    (comp.lang.ada)