Bagaimana cara mengaplikasikan module postgres trigram (pg_trgm) di aplikasi Rails?
https://stackoverflow.com/questions/18725081/rails-4-pgsql-add-index-with-type-gin-or-gist
https://scoutapm.com/blog/how-to-make-text-searches-in-postgresql-faster-with-trigram-similarity
https://www.sitepoint.com/awesome-autocomplete-trigram-search-in-rails-and-postgresql/
Singkatnya:
#psql #postgresql #postgres #gin #index
https://stackoverflow.com/questions/18725081/rails-4-pgsql-add-index-with-type-gin-or-gist
https://scoutapm.com/blog/how-to-make-text-searches-in-postgresql-faster-with-trigram-similarity
https://www.sitepoint.com/awesome-autocomplete-trigram-search-in-rails-and-postgresql/
Singkatnya:
rails generate migration AddPgTrgmExtensionToDB
rails generate migration AddIndexColumnToTables
class AddPgTrgmExtensionToDb < ActiveRecord::Migration[5.0]
def change
enable_extension :pg_trgm
enable_extension :btree_gin
end
end
class AddIndexColumnToTables < ActiveRecord::Migration[5.0]
def change
add_index :tables, :column, using: :gin
end
end
#psql #postgresql #postgres #gin #index
Stack Overflow
Rails 4 pgsql add_index with type GIN or GiST
In Rails it is possible to do:
add_index :table, :column_name, :using => 'btree'
Is it possible in Rails 4 with PGSQL to add a GIN or GiST index like:
add_index :students, :name, :using =>...
add_index :table, :column_name, :using => 'btree'
Is it possible in Rails 4 with PGSQL to add a GIN or GiST index like:
add_index :students, :name, :using =>...
Ruby Indonesia Channel
Channel berisi seputar informasi, berita, dan tutorial Ruby dan framework seperti Rails
https://t.me/rubyidchan
Channel berisi seputar informasi, berita, dan tutorial Ruby dan framework seperti Rails
https://t.me/rubyidchan
Telegram
Ruby Indonesia Channel
Channel berisi seputar informasi, berita, dan tutorial Ruby dan framework seperti Rails