dev:proposal:search_modifications
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| dev:proposal:search_modifications [2012/11/12 14:05] – jbond | dev:proposal:search_modifications [2022/02/10 13:34] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 67: | Line 67: | ||
| Remaining changes will be to the database, they include adding 5 tables of normalized text fields that are created from triggers from the field_entry tables. The text fields will be indexed using an extension called Pg_trgm. | Remaining changes will be to the database, they include adding 5 tables of normalized text fields that are created from triggers from the field_entry tables. The text fields will be indexed using an extension called Pg_trgm. | ||
| - | - Added 5 new tables, these tables are mapped to the *_field_entry tables. Each table contains an id which is one to one with the matching *_field_entry table. The other two columns contain the source and a value, which is a normalized value of the value field in the *_field_entry table. | + | * Added 5 new tables, these tables are mapped to the *_field_entry tables. Each table contains an id which is one to one with the matching *_field_entry table. The other two columns contain the source and a value, which is a normalized value of the value field in the *_field_entry table. |
| - | - Added an extension to index the normalized_*_field_entry tables. The index allows searching using the LIKE operator and is optimized for phrase matching as well as fuzzy matching. For more information on pg_trgm visit this site [[http:// | + | * Added an extension to index the normalized_*_field_entry tables. The index allows searching using the LIKE operator and is optimized for phrase matching as well as fuzzy matching. For more information on pg_trgm visit this site [[http:// |
| - | - Added a trigger to populate the normalized_*_field_entry tables from the *_field_entry tables. | + | * Added a trigger to populate the normalized_*_field_entry tables from the *_field_entry tables. |
| + | ==== Pull Request ==== | ||
| + | https:// | ||
| + | ==== Blue Print ==== | ||
| + | https:// | ||
| ==== Deliverable ==== | ==== Deliverable ==== | ||
dev/proposal/search_modifications.1352747115.txt.gz · Last modified: 2022/02/10 13:34 (external edit)