On Mon, Jul 5, 2010 at 3:08 PM, hinnack <henrik.gens...@miadi.net> wrote: > Thats interesting. > Can you explain, how the search keyword made it into the source? > Entry.objects.filter(headline__search="+Django -jazz Python") > SELECT ... WHERE MATCH(tablename, headline) AGAINST (+Django -jazz > Python IN BOOLEAN MODE); > Seems to be very MySQL specific...
Yes; As implemented, __search is MySQL specific, and the API is covered by our backwards compatibility policy, so we will continue to support it. However, that doesn't mean it should be used as an example or excuse for other database-specific features in the ORM. The only explanation I can give for this particular feature is age. The __search keyword was added over 4 years ago (Revision r3073, ticket #573). Django was still in a period of rapid growth at that time. Some of the features that were added at that time might not survive if they were proposed today (either because of hindsight, or because of changes in the perceived role of the ORM over time). If a fulltext search operator were proposed today, it might still be accepted -- after all, a query of text data using a rich full-text search syntax is something that transcends SQL and could be considered a primitive operation on object data. However, before I would accept such a proposal, I would need to be convinced that the proposed syntax would be supported on other backends. Postgres 8.3, for instance, has fulltext search indexing capabilities. I would also need to be convinced that the proposed syntax was rich enough to potentially cover the range of features provided by MySQL. As it stands, we only support queries "IN BOOLEAN MODE", not "IN NATURAL LANGUAGE MODE" or "WITH QUERY EXPANSION". Yours, Russ Magee %-) -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to django-develop...@googlegroups.com. To unsubscribe from this group, send email to django-developers+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-developers?hl=en.
