Forum/Discussion System for LMS

Development of Forums/Discussions System for LMS

A forum in an LMS is not just a place for questions. Well-organized discussions reduce support burden: students search for answers in the forum before contacting instructors. The key difference from regular forums—threads are tied to specific lessons, assignments, and courses.

Forum Architecture

Three levels of discussions:

1. General course forum—questions, communication, announcements
2. Lesson forum—questions about specific lessons (embedded in lesson page)
3. Assignment forum—discussion of homework assignments

CREATE TABLE forum_categories (
  id          UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  course_id   UUID REFERENCES courses(id),
  lesson_id   UUID REFERENCES lessons(id),       -- NULL = general course forum
  assignment_id UUID REFERENCES assignments(id),  -- NULL if not assignment forum
  name        VARCHAR(200) NOT NULL,
  type        VARCHAR(50),   -- 'general', 'qa', 'announcements'
  sort_order  INT DEFAULT 0
);

CREATE TABLE forum_threads (
  id              UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  category_id     UUID REFERENCES forum_categories(id),
  author_id       UUID REFERENCES users(id),
  title           VARCHAR(500) NOT NULL,
  is_pinned       BOOLEAN DEFAULT FALSE,
  is_locked       BOOLEAN DEFAULT FALSE,
  is_answered     BOOLEAN DEFAULT FALSE,     -- For Q&A: accepted answer exists
  views_count     INT DEFAULT 0,
  replies_count   INT DEFAULT 0,
  last_reply_at   TIMESTAMPTZ,
  created_at      TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE forum_posts (
  id              UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  thread_id       UUID REFERENCES forum_threads(id) ON DELETE CASCADE,
  parent_id       UUID REFERENCES forum_posts(id),  -- NULL = root post
  author_id       UUID REFERENCES users(id),
  content         TEXT NOT NULL,         -- HTML or Markdown
  is_accepted     BOOLEAN DEFAULT FALSE, -- Accepted answer in Q&A
  upvotes_count   INT DEFAULT 0,
  edited_at       TIMESTAMPTZ,
  created_at      TIMESTAMPTZ DEFAULT NOW()
);

-- Performance indexes
CREATE INDEX ON forum_threads (category_id, last_reply_at DESC);
CREATE INDEX ON forum_posts (thread_id, created_at);

Editor and Formatting

Students need to format text, insert code and images. Minimum features:

• Markdown with preview—simple approach, code blocks with syntax highlighting
• WYSIWYG (Quill, Tiptap)—more familiar for non-technical users

For programming courses, code block support with highlighting (highlight.js or Prism) is important.

// Tiptap configuration for forum
import { useEditor } from '@tiptap/react';
import StarterKit from '@tiptap/starter-kit';
import CodeBlockLowlight from '@tiptap/extension-code-block-lowlight';
import Image from '@tiptap/extension-image';

const editor = useEditor({
  extensions: [
    StarterKit,
    CodeBlockLowlight.configure({ lowlight }),
    Image.configure({ uploadUrl: '/api/forum/upload-image' }),
  ],
});

Notifications

// Events triggering notifications
const notificationEvents = {
  'thread.reply': {
    notify: ['thread_author', 'thread_followers'],
    channels: ['in_app', 'email'],
    digestWindow: 30 * 60 * 1000, // Email digest every 30 minutes
  },
  'post.mention': {
    notify: ['mentioned_user'],
    channels: ['in_app', 'email'],
    immediate: true,
  },
  'post.accepted': {
    notify: ['post_author'],
    channels: ['in_app', 'email'],
    immediate: true,
  },
  'thread.pinned': {
    notify: ['all_enrolled_students'],
    channels: ['in_app'],
  },
};

Email digest is critical—without it, a student in an active forum receives 50+ emails per day.

Moderation

Moderation roles: student, assistant (can edit/delete), instructor (full rights). Moderator functions:

• Close thread (no new posts allowed)
• Move thread to different category
• Mark post as "accepted answer"
• Delete/hide spam
• Pin important threads

Forum Search

-- Full-text search across course forum
SELECT t.id, t.title, p.content,
       ts_rank(search_vector, query) AS rank
FROM forum_threads t
JOIN forum_posts p ON p.thread_id = t.id AND p.parent_id IS NULL
JOIN forum_categories c ON c.id = t.category_id,
     websearch_to_tsquery('english', $1) query
WHERE c.course_id = $2
  AND (t.search_vector @@ query OR p.search_vector @@ query)
ORDER BY rank DESC
LIMIT 20;

Forum Gamification

"Helpful" mark on posts plus leaderboard by helpful answers. High-rated students can earn "Community TA" status with extended rights.

Timeline

Basic forum with threads, posts, notifications, moderation—7–10 days. Binding to lessons/assignments, Q&A mode with accepted answers—another 3–4 days. Search, digest notifications, participant ratings—another 3–4 days.