Task: Implement generated text-search vector column system

[iolyd]

Task description

To enable a text-search feature on the platform requires us to first establish a concise vectorization flow. Since text search vectors are constructed with language-specific stemming (to_tsvector([regconfig],...)), we need to ensure easy access to a text row's corresponding language regconfig.

List of actions

No response

[iolyd]

Mostly completed through drizzle-orm-helpers support for tsvector/ tsquery types and helpers. Pending on drizzle-team/drizzle-orm#1471

[iolyd]

Implementation using our own generated column trick ended up introducing a slew of challenges with migrations as it required some manual patching and is currently too error prone when used with drizzle-kit. GIN indices are now supported so we can try a partial implementation, but we likely also need generatedColumns support, which is currently a pending issue in drizzle-orm and drizzle-kit.

[iolyd]

Generated columns are now freshly out (in beta): https://github.com/drizzle-team/drizzle-orm/releases/tag/v0.32.0-beta