Add support for MariaDB vector type
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
@derrabus FYI -> https://forge.typo3.org/issues/106585
Request reached us too. Just wanna let you know about that.
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.
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