Bug #2445 for Wiki-Toolkit: support for reqular SQL queries (case insensitive title search...)

Mon Apr 28 04:28:11 2003 Guest - Ticket created

Subject:

support for reqular SQL queries (case insensitive title search...)

support for reqular SQL queries (case insensitive title search...) under the guise of Wiki::Search::Simple or something like that. I don't think applications should need to write select * from node where name like "%node%"; cheers

Fri May 02 18:15:27 2003 KAKE [...] cpan.org - Status changed from 'new' to 'resolved'

Fri May 02 18:15:27 2003 KAKE [...] cpan.org - Correspondence added

[guest - Mon Apr 28 04:28:11 2003]: Show quoted text

> support for reqular SQL queries (case insensitive title search...) > under the guise of > Wiki::Search::Simple or something like that. > I don't think applications should need to write > select * from node where name like "%node%";

That's quite a broad request - can you email me at kake@earth.li and we can discuss your precise requirements. Thanks! Kake

Fri May 02 18:15:27 2003 KAKE [...] cpan.org - Given to KAKE

Sat May 03 14:48:31 2003 KAKE [...] cpan.org - Correspondence added

I needed a fuzzy match on the title so I added it to the Search::InvertedIndex backend (not the DBIx::FullTextSearch one though) in 0.33 - is this any use to you?

Sat May 03 14:48:32 2003 The RT System itself - Status changed from 'resolved' to 'open'

Sun May 04 06:22:13 2003 Guest - Correspondence added

[KAKE - Sat May 3 14:48:31 2003]: Show quoted text

> I needed a fuzzy match on the title so I added it to the > Search::InvertedIndex backend (not the DBIx::FullTextSearch one

though) Show quoted text

> in 0.33 - is this any use to you?

That would be nice if I could take advantage of FullTExtSearch or InvertedIndex. Maybe a CGI::Wiki::Search::Generic is in order?

Sun May 04 07:24:56 2003 KAKE [...] cpan.org - Correspondence added

[guest - Sun May 4 06:22:13 2003]: Show quoted text

> That would be nice if I could take advantage > of FullTExtSearch or InvertedIndex.

Why can't you use the Search::InvertedIndex backend? Kake

Wed May 07 09:29:46 2003 Guest - Correspondence added

[KAKE - Sun May 4 07:24:56 2003]: Show quoted text

> [guest - Sun May 4 06:22:13 2003]:

> > That would be nice if I could take advantage > > of FullTExtSearch or InvertedIndex.

> > Why can't you use the Search::InvertedIndex backend? > > Kake

Because it is not portable (it doesn't work) and more importantly, because this is as basic as list_all_nodes.

Wed May 07 09:40:25 2003 KAKE [...] cpan.org - Correspondence added

[guest - Sun May 4 06:22:13 2003]: Show quoted text

> > > That would be nice if I could take advantage > > > of FullTExtSearch or InvertedIndex.

[KAKE - Sun May 4 07:24:56 2003]: Show quoted text

> > Why can't you use the Search::InvertedIndex backend?

[guest - Wed May 7 09:29:46 2003]: Show quoted text

> Because it is not portable (it doesn't work)

I can't help you to get it working unless you give me some more information. What errors are you getting when you try to use it? What operating system are you running? Which version of Perl? Which version of Search::InvertedIndex? Which version of CGI::Wiki? I can't even start to debug your problem until you answer those questions. Show quoted text

> and more importantly, > because this is as basic as list_all_nodes.

list_all_nodes is provided by CGI::Wiki::Store::Database and fuzzy_title_match is provided by CGI::Wiki::Search::SII, so I'm not sure I understand this point. Kake

Wed May 07 14:11:00 2003 Guest - Correspondence added

There is no problem to debug. That feature should be core. I will never use SII, and don't care to even attempt to debug it.

Wed May 07 14:16:17 2003 Guest - Correspondence added

[guest - Wed May 7 14:11:00 2003]: Show quoted text

> There is no problem to debug. > That feature should be core. > I will never use SII, and don't care to even attempt to debug it.

In case the above wasn't clear fuzzy title match should be a part of CGI::Wiki::Store::Database

Thu May 08 11:23:35 2003 KAKE [...] cpan.org - Correspondence added

[guest - Wed May 7 14:16:17 2003]: Show quoted text

> fuzzy title match should be a part of CGI::Wiki::Store::Database

I can see where you're coming from, and I would like to slightly simplify things in the future so there's no need to explicitly instantiate a search object. However, (a) this is not going to happen until Search::InvertedIndex has Postgres and SQLite backends (the latter is written and has been sent to the maintainer; I won't start work on the former until he's caught up with patches and stuff) and (b) it is going to be backed by Search::InvertedIndex anyway. So it really is in your best interests to give me as much information as possible about why you feel unable to use CGI::Wiki::Search::SII, because that is the basis for the code that I would use to put fuzzy title match into CGI::Wiki::Store::Database. Kake

Sun Jul 13 11:16:20 2003 Guest - Correspondence added

http://testers.cpan.org/search?request=dist&dist=Search- InvertedIndex#1.12+MSWin32+4.0+MSWin32-x86-multi-thread

Thu Jul 17 11:40:40 2003 KAKE [...] cpan.org - Correspondence added

[guest - Sun Jul 13 11:16:20 2003]: Show quoted text

> http://testers.cpan.org/search?request=dist&dist=Search- > InvertedIndex#1.12+MSWin32+4.0+MSWin32-x86-multi-thread

Thanks! I've mailed the maintainer about this and with any luck we should be able to get it sorted, assuming one of us can get hold of a Windows box to play with it on. Kake

Thu Jan 28 17:22:53 2010 The RT System itself - Owner forcibly changed from KAKE to Nobody

Thu Jan 28 17:22:54 2010 dom [...] cpan.org - Queue changed from CGI-Wiki to Wiki-Toolkit