Opened 10 years ago

Closed 9 years ago

Last modified 9 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@… 10 years ago.
Patch adding a "match" keyword that does full-text searching on mysql
matchoperator.diff (3.6 KB) - added by Tim Keating 10 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 10 years ago.
DB API doc updated with match operator.

Download all attachments as: .zip

Change History (12)

comment:1 Changed 10 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 10 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 10 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 10 years ago by mrtact@…

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

comment:4 Changed 10 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 10 years ago by Tim Keating

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

Changed 10 years ago by Tim Keating

DB API doc updated with match operator.

comment:5 Changed 10 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