Bradley
DTDrizzle Team
•Created by Bradley on 2/9/2024 in #help
How to define schemas (any dialect) with full text search column types?
The Drizzle docs clearly show an example of using full text search in where queries using the
sql() syntax in the sql in where documentation.
Given this one would assume there is a way to define your schema to include both the appropriate column type (e.g. ts_vector Postgresql, FULLTEXT MySQL, etc.) and indexes for those columns. However there doesn't seem to be any documentation of this or indication that it is on their radar.
I understand that there are issues open for these things like Add Full-Text Search capability and workarounds like https://github.com/drizzle-team/drizzle-orm/issues/247#issuecomment-1726743672.
How are people here implementing this kind of thing themselves?3 replies