Scoop || Smart Searching

Front Page · Everything · News · Code · Help! · Wishlist · Project · Scoop Sites · Dev Notes · Latest CVS changes · Development Activities

Smart Searching
By hurstdog , Section Code [] Posted on Fri Nov 30, 2001 at 12:00:00 PM PST

After many long months/days/years/eons of the scoop searching engine lacking, hillct has jumped to the rescue. By alerting us to MySQL's ability to do Fulltext Searches and then coding up a patch for it, we now have really cool searching in scoop. All with just a small bit of additions and a lot of sql work by hillct.

This hasn't been checked into cvs yet, as we're still working out a few of the bugs (some might argue thats what cvs is for ;-) but we installed it here on scoop.k5 to see if we can get some people to pound on it a bit. Its rather useless to test on a database with very few comments, so thats why its not in cvs for people to download and test.

Fulltext searching will do searching the way it is supposed to be done, not by exact string (though there is a button for that in our search page), but by how well something matches the whole string, and each part of it, case insensitively. Its really cool.

So, once again, pound on the searching here. See what you can break. And much much thanks to hillct for all of his hard work.

< Story preview time minimum | Backup strategies? >

Menu

· create account
· faq
· search
· report bugs
· Scoop Administrators Guide
· Scoop Box Exchange

Login

Make a new account

Username:

Password:

Poll

New Searching

· really cool 100%

· kinda cool 0%

· indifferent 0%

· lame 0%

· I like /.'s search engine better 0%

Votes: 1
Results | Other Polls

Related Links

· Scoop
· hillct
· Fulltext Searches
· More on Announcements
· Also by hurstdog

Story Views

81 Scoop users have viewed this story.

Smart Searching | 13 comments (13 topical, 0 hidden)

Replies fix? (none / 0) (#1)
by rusty on Fri Nov 30, 2001 at 01:58:52 PM PST

Did you add our tweak to the queries on here?

And another question, about relevance by rusty, 11/30/2001 02:07:53 PM PST (none / 0)

I fixed it. by hurstdog, 11/30/2001 04:41:37 PM PST (5.00 / 1)
test by ip4noman, 01/06/2002 10:59:23 AM PST (5.00 / 1)
This is another test by Vladinator, 01/06/2002 11:01:59 AM PST (none / 0)

A bit about searching 'Comments By' (5.00 / 1) (#4)
by hillct on Fri Nov 30, 2001 at 07:22:53 PM PST

In the spirit of giving credit where credit is due, I have to thank Vectro and Defect for strategies and ideas on how comments should really be sorted, when you choose to search for comments by a particular user. You can now sort by date (the old behavior) or by relevance, which is not quite the same as relevance with regard to searches of Stories, Diaries, or Comments. In the case of 'Comments By', relevance means relevance to other users as measured by the date of replies to that user's comments. This allows rusty, for example to view his own comments and imediately be able to identify those to which other users have replied most reently. This is useful for the reasons that Vectro outlines in his story, linked above. This is the new default behavior, although users have the option to select sort by Date to get the old behavior.

Whether or not this is the proper behavior is, I suppose, up for debate, but the main reason I wanted to explain this is first to thank Defect and second to detail the fact that the 'Sort By Relevance' radio button has slightly different behaviors based on the type of search being performed. While it's generally a bad practice to change the behavior of GUI elements under different conditions, I think this case is an exception.

--CTH

--
ScoopHost.com - Premier Scoop Hosting and custom development from the lead developers.

Aww, Man! (none / 0) (#5)
by mahonri on Sat Dec 01, 2001 at 01:58:51 PM PST

Just when I was starting to be really happy with 0.8, you guys go and add something cool like this to CVS. It wouldn't be so bad, if I didn't have 6 scoop sites on my server.

so track CVS, then... by janra, 12/01/2001 02:52:49 PM PST (none / 0)

What about using ANSI SQL? (5.00 / 1) (#7)
by Dries on Tue Dec 04, 2001 at 06:17:14 AM PST

I don't want to spoil the fun - and Scoop is not Drupal - but in Drupal we try to use ANSI SQL. Like that, you can run Drupal on any SQL server. Especially because MySQL is losing territory compared with other open source SQL servers.

-- Dries
drop.org weblog - drupal engine

We thought about that... by hurstdog, 12/04/2001 09:43:22 AM PST (none / 0)

I saw those posts but havn't seen update issues by hillct, 12/04/2001 03:11:59 PM PST (none / 0)

usacheckcashingstore.com/Lemon-Grove (none / 0) (#12)
by Pervez on Sun Apr 15, 2018 at 03:43:15 PM PST

Top-quality website page! Nowadays I'm particularly articles and other content to study this unique. Longer backwards I just discovered an internet site in the region of chiropractic improves and also needed to indicate Article for me personally have nearly dear store shopping your website articles and other content not to mention content pieces. Right this moment adopt here usacheckcashingstore.com/Lemon-Grove Fantastic located, most likely revealing. Remain. All the best for the purpose of terrific be a success.

Best General Contractor (none / 0) (#13)
by Pervez on Sun Apr 07, 2019 at 05:36:24 AM PST

Were satisfied you only go through this kind of. This may be a way of guidebook e-book which in turn should be naturally and not your current hit-or-miss untruths this is while using other sorts of internet sites. Now just click this specific Best General Contractor Delight in your providing this kind of excellent placing.

Smart Searching | 13 comments (13 topical, 0 hidden)

create account | faq | search