Opened 9 years ago

Closed 9 years ago

Last modified 8 years ago

#593 closed enhancement (fixed)

[patch] Fulltext search support in Django

Reported by: anonymous Owned by: adrian
Component: Database layer (models, ORM) Version:
Severity: minor Keywords: fulltext search
Cc: Triage Stage: Unreviewed
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: UI/UX:

Description

If possible, django should provide a way of selecting fields to conduct fulltext search upon.

MySQL supports this in default distribuition, PostgreSQL needs extensions, I don't know about SqLite.

Attachments (3)

fulltext.patch (3.5 KB) - added by mrtact@… 9 years ago.
Patch adding a "match" keyword that does full-text searching on mysql
matchoperator.diff (3.6 KB) - added by Tim Keating 9 years ago.
Match operator implementation for full text search (on MySQL only, other backends raise NotImplemented)
match_operator_doc.diff (841 bytes) - added by Tim Keating 9 years ago.
DB API doc updated with match operator.

Download all attachments as: .zip

Change History (12)

comment:1 Changed 9 years ago by adrian

Can you give more specifics? Where would it need to provide full-text search support? Please give concrete examples.

comment:2 Changed 9 years ago by wojtek@…

Actually it would be nice to be able to do automatic indexing in _pre_save and removing from the index on _pre_delete on a given model with some class for converting the model to an index object provided to you.

And then there could be a generic view for searches on models.

I'm actually going to implement it using http://hyperestraier.sourceforge.net/

Any hints are welcome

comment:3 Changed 9 years ago by anonymous

Fulltext search would come handy on custom made portals. Flatfiles can have a lot of content, and it's not searchable. Also django user could want a way to search his content, so it should probably be a field specific option, eg. 'fulltext=True' just like 'blank=True'.

It's just that search is such a powerful feature, that can not be left unimplemented. But sadly i'm not so deep into python to know how to make this happen.

Changed 9 years ago by mrtact@…

Patch adding a "match" keyword that does full-text searching on mysql

comment:4 Changed 9 years ago by Tim Keating

  • Owner changed from adrian to anonymous
  • Status changed from new to assigned
  • Summary changed from Fulltext search support in Django to [patch] Fulltext search support in Django

Re-submitting this patch, since I didn't previously abide by the proper guidelines.

Changed 9 years ago by Tim Keating

Match operator implementation for full text search (on MySQL only, other backends raise NotImplemented)

Changed 9 years ago by Tim Keating

DB API doc updated with match operator.

comment:5 Changed 9 years ago by adrian

  • Owner anonymous deleted
  • Status changed from assigned to new

comment:6 Changed 9 years ago by adrian

  • priority changed from normal to lowest
  • Severity changed from normal to minor
  • Type changed from defect to enhancement

comment:7 Changed 9 years ago by adrian

  • Owner set to adrian
  • Status changed from new to assigned

comment:8 Changed 9 years ago by adrian

  • Resolution set to fixed
  • Status changed from assigned to closed

(In [3073]) Fixed #593 -- Added 'search' DB-API lookup type, which does full-text index searches in MySQL

comment:9 Changed 9 years ago by Seer

Hi all
im fine, gl all!

Note: See TracTickets for help on using tickets.
Back to Top