Opened 11 years ago

Closed 11 years ago

Last modified 10 years ago

#593 closed enhancement (fixed)

[patch] Fulltext search support in Django

Reported by: anonymous Owned by: Adrian Holovaty
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@… 11 years ago.
Patch adding a "match" keyword that does full-text searching on mysql
matchoperator.diff (3.6 KB) - added by Tim Keating 11 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 11 years ago.
DB API doc updated with match operator.

Download all attachments as: .zip

Change History (12)

comment:1 Changed 11 years ago by Adrian Holovaty

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

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

Attachment: fulltext.patch added

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

comment:4 Changed 11 years ago by Tim Keating

Owner: changed from Adrian Holovaty to anonymous
Status: newassigned
Summary: Fulltext search support in Django[patch] Fulltext search support in Django

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

Changed 11 years ago by Tim Keating

Attachment: matchoperator.diff added

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

Changed 11 years ago by Tim Keating

Attachment: match_operator_doc.diff added

DB API doc updated with match operator.

comment:5 Changed 11 years ago by Adrian Holovaty

Owner: anonymous deleted
Status: assignednew

comment:6 Changed 11 years ago by Adrian Holovaty

priority: normallowest
Severity: normalminor
Type: defectenhancement

comment:7 Changed 11 years ago by Adrian Holovaty

Owner: set to Adrian Holovaty
Status: newassigned

comment:8 Changed 11 years ago by Adrian Holovaty

Resolution: fixed
Status: assignedclosed

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

comment:9 Changed 10 years ago by Seer

Hi all
im fine, gl all!

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