Native Implementation of Full Text Search and Vector Data Types

[NicFT]

Hello
I would like to know if there is any prospect of implementing VECTORIZED data types as well as Full Text Search.

With the advent of AI, it will be crucial for systems to provide these two items directly in the database; otherwise, we will be forced to create parallel databases to maintain our information, such as PostgreSQL or similar systems.

[mrotteveel]

You may want to be more specific about you want and need. As an aside, although badly supported and not very accessible in SQL, the array support is already in many ways such a datatype (though it would probably need some rethinking and redesign).

[NicFT]

I'm referring to how most RDBMS like SQL Server, PostgreSQL, and SQLite offer built-in full-text search capabilities, which can be sufficient for simpler search requirements and better integrated with existing database queries.

Just as pgvector for PostgreSQL is an extension that transforms PostgreSQL into a vector database.

[aafemt]

Something like this?