{"library":"pg-search-sequelize","type":"library","category":null,"description":"pg-search-sequelize (v0.0.10) provides PostgreSQL full-text search in Node.js using Sequelize as the ORM. It automatically creates materialized views that combine searchable fields into ts_vector columns and adds `searchByText`, `search`, and `refresh` class methods to your models. Supports weighted search, filtering, ordering, and inclusion of associated model fields. The package is stable but has not been updated frequently; it requires Sequelize v4 (v5+ compatibility is unclear). Use it if you need simple, model-centric full-text search without raw queries, but be aware of limited maintenance and potential migration issues with newer Sequelize versions.","language":"javascript","status":"active","version":"0.0.10","tags":["javascript","fulltext","full-text","full","text","postgresql","node","psql","materialized"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install pg-search-sequelize","imports":["const SearchModel = require('pg-search-sequelize');\nMyModel = new SearchModel(MyModel);","const results = await MyModel.searchByText('query');","const { createMaterializedView } = require('pg-search-sequelize');\nawait createMaterializedView('view_name', Model, { fields: {...} });"]},{"cmd":"yarn add pg-search-sequelize","imports":[]},{"cmd":"pnpm add pg-search-sequelize","imports":[]}],"homepage":"https://github.com/mujz/pg-search-sequelize#readme","github":"https://github.com/mujz/pg-search-sequelize","docs":null,"changelog":null,"pypi":null,"npm":"pg-search-sequelize","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}