The Birth of dur.com and spbgu.ru

3.1 Addressing Campus Communication Fragmentation

During his studies at Saint Petersburg State University, Pavel observed that the university's various faculties were geographically fragmented across Saint Petersburg—with Philology and Law on Vasilievsky Island, Mathematics and Natural Sciences in Peterhof, and others near Smolny. Students in different faculties lacked a unified digital platform to share academic materials, collaborate, or communicate.

3.2 Launching dur.com and the Creation of spbgu.ru

To solve this information coordination failure, Pavel independently coded and launched `dur.com` (Durov's University Resource), an early web portal where students could upload and download lecture notes, translations of classical texts, and exam preparation materials.

Recognizing that students needed an interactive discussion medium rather than just a static file library, Pavel expanded the project in late 2005 by creating `spbgu.ru`, a comprehensive multi-threaded online forum configured as a virtual meeting ground for students across all university departments.

   [dur.com (2004-2005)]   ====> Centralized digital repository for course notes & exams
              |
              v
   [spbgu.ru (2005-2006)]  ====> Multi-faculty interactive student forum & discussion portal
              |
              v
   [VKontakte (Late 2006)] ====> Full-scale student social graph network

3.3 Forum Moderation, Community Dynamics, and Debates

As spbgu.ru expanded to tens of thousands of registered student accounts, Pavel managed both technical backend operations and community moderation. Biographies such as Nikolai Kononov's *The Durov Code* report that in the forum's early days, Durov actively stimulated discussions on controversial topics by writing under multiple pseudonyms, debating different sides of issues to encourage student participation.

These early projects served as practical laboratories for Durov, giving him firsthand experience in database optimization, server management, community moderation, and the dynamics of digital social graphs.

-- =========================================================================
-- CONCEPTUAL DATABASE SCHEMA: Multi-Threaded Forum Architecture
-- Illustrative relational schema showing forum taxonomy and thread indexing
-- =========================================================================
CREATE TABLE IF NOT EXISTS forum_users (
    user_id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL UNIQUE,
    email VARCHAR(100) NOT NULL UNIQUE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB;

CREATE TABLE IF NOT EXISTS forum_threads (
    thread_id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    creator_id INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (creator_id) REFERENCES forum_users(user_id) ON DELETE SET NULL,
    INDEX (created_at)
) ENGINE=InnoDB;

CREATE TABLE IF NOT EXISTS forum_posts (
    post_id INT AUTO_INCREMENT PRIMARY KEY,
    thread_id INT NOT NULL,
    author_id INT,
    post_content TEXT NOT NULL,
    posted_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (thread_id) REFERENCES forum_threads(thread_id) ON DELETE CASCADE,
    FOREIGN KEY (author_id) REFERENCES forum_users(user_id) ON DELETE SET NULL,
    INDEX (thread_id, posted_at)
) ENGINE=InnoDB;

The spbgu.ru University Forum Interface

Visual schematic reconstruction of the 2005 spbgu.ru university discussion forum interface layout and thread directory.