Opened 18 years ago

Closed 18 years ago

Last modified 17 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: no UI/UX: no

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

Download all attachments as: .zip

Change History (12)

comment:1 by Adrian Holovaty, 18 years ago

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

comment:2 by wojtek@…, 18 years ago

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 by anonymous, 18 years ago

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.

by mrtact@…, 18 years ago

Attachment: fulltext.patch added

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

comment:4 by Tim Keating, 18 years ago

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.

by Tim Keating, 18 years ago

Attachment: matchoperator.diff added

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

by Tim Keating, 18 years ago

Attachment: match_operator_doc.diff added

DB API doc updated with match operator.

comment:5 by Adrian Holovaty, 18 years ago

Owner: anonymous removed
Status: assignednew

comment:6 by Adrian Holovaty, 18 years ago

priority: normallowest
Severity: normalminor
Type: defectenhancement

comment:7 by Adrian Holovaty, 18 years ago

Owner: set to Adrian Holovaty
Status: newassigned

comment:8 by Adrian Holovaty, 18 years ago

Resolution: fixed
Status: assignedclosed

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

comment:9 by Seer, 18 years ago

Hi all
im fine, gl all!

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