👋 Hello everyone! I'm yet again asking for some opinions on another feature idea for Prisma Util: Support for

pg_trgm

in the Prisma client! For those who don't know,

pg_trgm

allows fuzzy matching in PostgreSQL databases. As for implementation ideas, Prisma Util will generate an SQL query to support this feature, then run your migrations. Then, it will add

@Unsupported("TSVECTOR")

to your fields and create GIN or GiST (configured per field) indexes, as well as install

pg_trgm

. As for usage, I'd need some suggestions for it.

Hey David 👋 this sounds great as well! If you want to get feedback specifically for your idea about a possible

pg_trgm

implementation, I’d recommend you to post your idea also in the respective GitHub issue since that’s where you find the people who have a vested interest in this feature 😄

Thanks! I've taken a look at Prisma and I guess that my best bet would be to make a middleware than runs $queryRaw?

$queryRaw in a middleware is the way to go for now👍