sequenceDiagram
    participant ModComp
    participant ResourceStream as ResourceStream_mcmod_buf
    participant GZip as GZipStream
    participant Memory as MemoryStream
    participant SHA1 as SHA1Provider
    participant FS as FileSystem
    participant Sqlite as SqliteConnection

    ModComp->>ResourceStream: GetResourceStream(Resources_mcmod_buf)
    ResourceStream-->>ModComp: compressedDbData
    ModComp->>GZip: new GZipStream(compressedDbData, Decompress)
    GZip->>Memory: CopyTo(ms)
    Memory->>SHA1: ComputeHash(ms)
    SHA1-->>ModComp: fileHash
    ModComp->>FS: Combine(PathTemp, Cache, ModData_fileHash_sqlite)
    FS-->>ModComp: dbPath

    ModComp->>FS: Exists(dbPath)
    alt dbPath exists
        ModComp->>ModComp: IsDatabaseValid(dbPath)
        alt database invalid
            ModComp->>FS: Delete(dbPath)
        end
    end

    ModComp->>FS: Exists(dbPath)
    alt dbPath does not exist
        ModComp->>Memory: Seek(0)
        ModComp->>ModComp: Deserialize entries from ms
        ModComp->>FS: CreateDirectory(dbDir)
        ModComp->>FS: Build tempPath = dbPath_tmp
        ModComp->>FS: Delete(tempPath) if exists

        ModComp->>Sqlite: Open(DataSource=tempPath)
        Sqlite->>Sqlite: BeginTransaction()
        Sqlite->>Sqlite: CREATE TABLE ModTranslation
        Sqlite->>Sqlite: CREATE INDEX idx_curseforge
        Sqlite->>Sqlite: CREATE INDEX idx_modrinth
        Sqlite->>Sqlite: CREATE INDEX idx_chinesename

        loop for each entry in entries
            ModComp->>Sqlite: INSERT INTO ModTranslation(entry)
        end

        Sqlite->>Sqlite: Commit transaction
        Sqlite-->>ModComp: Close

        ModComp->>FS: Move(tempPath, dbPath, overwrite=true)
    end

    ModComp-->>ModComp: return connection string for dbPath

classDiagram
    class ModComp {
        +String InitializeModDbAndGetConnectionString()
        -Boolean IsDatabaseValid(String dbPath)
        +SqliteConnection CompDB
        +String CompDBConnectionString
    }

    class SqliteConnection {
        +Open()
        +Close()
        +BeginTransaction()
        +Execute(String sql)
        +ExecuteScalar~T~(String sql)
    }

    class FileSystem {
        +Boolean Exists(String path)
        +Void Delete(String path)
        +Void Move(String source, String dest, Boolean overwrite)
        +Void CreateDirectory(String path)
        +String Combine(String path1, String path2)
    }

    class SHA1Provider {
        +Byte[] ComputeHash(Stream data)
    }

    class GZipStream {
        +Void CopyTo(Stream destination)
    }

    ModComp --> SqliteConnection : uses
    ModComp --> FileSystem : uses
    ModComp --> SHA1Provider : uses
    ModComp --> GZipStream : uses