Adam Robertson

Results 26 comments of Adam Robertson

+1 to this... I've had to fork it to make it a module! Thanks!

We have the same issue. I'm trying to understand though, is pod on node A -> pod on node B still encrypted with `encryption=true` and `nodeEncryption=false`? One would assume not,...

Seems to me it would be safer to have the `searchable_id` column be `varchar` and just use typecasting on index? I definitely don't have integers nor UUIDs for my records...

I've created a class that inherits from `ActiveRecord::Migration[5.0]` that has methods to easily remove and re-add triggers and update functions, it's proven invaluable when updating indexed columns or fulltext weighting.

Implementation looks like the following: ```ruby class SwapTsvUpdateTriggerForUsersV2 < SearchTsvectorMigration def change reversible do |dir| dir.up do remove_trigger_and_index(User) add_users_trigger_and_index_v2 end dir.down do remove_trigger_and_index(User) add_users_trigger_and_index_v1 end end say_with_time 'Executing triggers for...

Unfortunately I don’t (all proprietary), but I can post a more complete class for you in a bit.

@nertzy Any possibility the parser could recognize quoted phrases when separating search terms? I don't think we need full lucene or anything, but some of the native functions of PG...

That's not something you would want to do with fulltext search. I use the following concern for my projects: ```ruby module DateScopes extend ActiveSupport::Concern included do scope :starts_between, ->(from, to,...

Just a friendly 4-year checkup... wondering if this is a possibility?! Also requested this in #420.

I'm wondering if there's a particular reason that the `pg_search_documents.content` field isn't of `tsvector` type? Haven't dug into it too deep, but seems to me that keeping this as a...