dbal icon indicating copy to clipboard operation
dbal copied to clipboard

Add support for MariaDB vector type

Open f-lombardo opened this issue 1 year ago • 3 comments

Feature Request

What

I'd like to handle vector columns in MariaDB (https://mariadb.com/kb/en/vector-overview/)

Why

It would be useful for handling vector searches on Doctrine entities

f-lombardo avatar Jan 12 '25 15:01 f-lombardo

@derrabus FYI -> https://forge.typo3.org/issues/106585

Request reached us too. Just wanna let you know about that.

sbuerk avatar May 23 '25 15:05 sbuerk

There's no broad support for vector types yet, as far as I can tell. If it's about supporting the vector type supported by MariaDB specifically, it might be better to build that type as a standalone package because we can hardly build an abstraction with only a single implementation in mind.

derrabus avatar Aug 17 '25 21:08 derrabus

Apart from MariaDB, I've found the following resources on vector types. Looks like there is a common feature set after all. So, if someone wants to work on a type abstraction for vectors, please give it a try.

  • SQL Server (beta release only): https://learn.microsoft.com/en-us/sql/t-sql/data-types/vector-data-type
  • MySQL: https://dev.mysql.com/doc/refman/9.4/en/vector.html
  • Postgres via extension pgvector

derrabus avatar Aug 17 '25 21:08 derrabus