eclipse-vertx / eclipse-vertx/vertx-sql-client

Add support for vector types

Open
#1,526 3 comments 0 reactions 1 assignee Claimed by @tsegismont View on GitHub
enhancement
Dominant language
Java
Stars
912
Forks
212
Avg merge
17h 30m
Merged PRs (30d)
3

Description

#### Read me

Read this first before creating an issue:

- do not use this issue tracker to ask questions, instead use one of these [channels](https://vertx.io/community/). Questions will likely be closed without notice.
- you shall create a feature request only when it is general purpose enough.
- make sure that the feature is not already

#### Describe the feature

With vector search becoming available in most RDBMS, can we get native support for the vector embedding types in mysql, postgres, oracle, maria, etc?

#### Use cases

Right now, we have to pull down the embedding as a string type which adds unnecessary overhead and mem copies for the conversions back and forth.

Also, writing the embedding is extremely problematic since there doesn't appear a way to package it in a way that will work across all DBs. I.e. you have to use a dialect specific `ColumnTransformer` to wrap the string in `STRING_TO_VECTOR`, `VEC_FromText`, or `''::vector` for postgres.

#### Contribution

Who should implement this feature ? are you volunteering for implementing this feature or
do you know that is able and willing implement this feature ?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.