Method initialize

src/db/index.ts:103–160

* Initialize a new database at the given path

(dbPath: string)

   * Initialize a new database at the given path
   */
  static initialize(dbPath: string): DatabaseConnection {
    // Ensure parent directory exists
    const dir = path.dirname(dbPath);
    if (!fs.existsSync(dir)) {
      fs.mkdirSync(dir, { recursive: true });
    }

    // Create and configure database
    const { db, backend } = createDatabase(dbPath);

    configureConnection(db);

    // Run schema initialization, splitting FTS5 from the rest so
    // codegraph still works when Node.js was built without FTS5 (#1532).
    const schemaPath = path.join(__dirname, 'schema.sql');
    const schema = fs.readFileSync(schemaPath, 'utf-8');

    const FTS5_MARKER = '-- Full-text search index on node names, docstrings, and signatures';
    const ftsIdx = schema.indexOf(FTS5_MARKER);
    let fts5Available = true;

    if (ftsIdx >= 0) {
      const preFts = schema.slice(0, ftsIdx);
      // FTS ends after the update trigger; required tables and indexes follow
      // it in schema.sql and must still be created when FTS5 is unavailable.
      const ftsSection = schema.slice(ftsIdx).match(
        /^[\s\S]*?CREATE TRIGGER IF NOT EXISTS nodes_au\b[\s\S]*?END;/
      )?.[0];
      if (!ftsSection) throw new Error('schema.sql: FTS5 update trigger not found');
      // Execute everything before FTS5 first
      db.exec(preFts);
      // Try FTS5; if it fails, skip it and continue with LIKE-only search
      try {
        db.exec(ftsSection);
      } catch (err: any) {
        fts5Available = false;
        const msg = err?.message ?? String(err);
        console.warn(
          `[codegraph] FTS5 not available in this Node.js build (${msg}). ` +
          `Search will fall back to LIKE + fuzzy matching. ` +
          `For full-text search, use a Node.js build with FTS5 enabled.`
        );
      }
      db.exec(schema.slice(ftsIdx + ftsSection.length));
    } else {
      db.exec(schema);
    }

    // Record current schema version so migrations aren't re-applied on open
    const currentVersion = getCurrentVersion(db);
    if (currentVersion < CURRENT_SCHEMA_VERSION) {
      db.prepare(
        'INSERT OR IGNORE INTO schema_versions (version, applied_at, description) VALUES (?, ?, ?)'
      ).run(CURRENT_SCHEMA_VERSION, Date.now(), 'Initial schema includes all migrations');
    }

    return new DatabaseConnection(db, dbPath, backend, fts5Available);
  }