Function create_user_indexes

src/store/store.c:373–391

}

static int create_user_indexes(cbm_store_t *s) {
    const char *sql =
        "CREATE INDEX IF NOT EXISTS idx_nodes_label ON nodes(project, label);"
        "CREATE INDEX IF NOT EXISTS idx_nodes_name ON nodes(project, name);"
        "CREATE INDEX IF NOT EXISTS idx_nodes_file ON nodes(project, file_path);"
        "CREATE INDEX IF NOT EXISTS idx_edges_source ON edges(source_id, type);"
        "CREATE INDEX IF NOT EXISTS idx_edges_target ON edges(target_id, type);"
        "CREATE INDEX IF NOT EXISTS idx_edges_type ON edges(project, type);"
        "CREATE INDEX IF NOT EXISTS idx_edges_target_type ON edges(project, target_id, type);"
        "CREATE INDEX IF NOT EXISTS idx_edges_source_type ON edges(project, source_id, type);"
        "CREATE INDEX IF NOT EXISTS idx_edges_url_path ON edges(project, url_path_gen);";
    /* NOTE: a partial expression index on json_extract(properties,'$.is_entry_point')
     * was tried for arch_entry_points and REVERTED: json_extract in an index WHERE
     * aborts CREATE INDEX (and thus store open) on any row whose properties JSON is
     * malformed — and pre-fix databases contain such rows (see
     * pipeline_def_props_valid_json_when_oversized). Revisit only with a
     * json_valid()-guarded expression once legacy DBs have aged out. */
    return exec_sql(s, sql);
}

int64_t cbm_store_resolve_mmap_size(void) {
    enum { MMAP_DEFAULT = 67108864, BASE_10 = 10 }; /* default 64 MB; decimal radix */