let length: number =
    dbColumn["CHARACTER_MAXIMUM_LENGTH"]
if (tableColumn.type === "vector") {
    // MySQL and MariaDb store the vector length in bytes, not in number of dimensions.
    length = length / 4
}

to: (value: number[]) => {
    const length = value.length
    const arrayBuffer = new ArrayBuffer(length * 4)
    const dataView = new DataView(arrayBuffer)

    for (let index = 0; index < length; index++) {
        dataView.setFloat32(index * 4, value[index], true)
    }

    return Buffer.from(arrayBuffer)
},

@Column("real_vector", {
    transformer: vectorTransformer,
})
realVector: number[]

// In user's entity file: Embedding.ts
const vectorTransformer: ValueTransformer = {
    to: (value: number[]) => {
        // Manual conversion from number[] to Buffer
        const buffer = new ArrayBuffer(value.length * 4);
        // ... fill buffer
        return Buffer.from(buffer);
    },
    from: (value: Buffer | number[]) => {
        // Manual conversion from Buffer to number[]
        // ... logic to read buffer
        return array;
    },
};

@Entity()
export class Embedding {
    @Column("vector", {
        transformer: vectorTransformer,
    })
    vector: number[];
}

// In user's entity file: Embedding.ts
// No manual transformer is needed.

@Entity()
export class Embedding {
    @Column("vector")
    vector: number[]; // The driver handles the transformation automatically.
}

// In src/driver/mysql/MysqlDriver.ts (conceptual)
class MysqlDriver {
    // ...
    // The driver would override methods like `preparePersistentValue`
    // and `prepareHydratedValue` to automatically handle the
    // Buffer <-> number[] conversion for the 'vector' type.
}