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
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?
sql()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?
GitHub
This is a feature request for Full-Text Search functionality to perform a fulltext search on specific fields. Ideally with support for using GIN/GIST indexes to speed up full text search.
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,959Members
Resources
Was this page helpful?
