Complex searches - SQL

[Chao]

I've seen quite a few requests and such to allow for some detailed searches (eg single anime only, only multiple anime vids, excluding these anime etc). Would it be possible to allow SQL statements as searches? This would mean the admins wouldn't have to consider and queue up potential new searches that few people would use, and allow those that want to be more detailed to do so.

[derobert]

I've seen quite a few requests and such to allow for some detailed searches (eg single anime only, only multiple anime vids, excluding these anime etc). Would it be possible to allow SQL statements as searches? This would mean the admins wouldn't have to consider and queue up potential new searches that few people would use, and allow those that want to be more detailed to do so.

Filtering those SQL statements would be hard. We'd need to somehow prevent statements like:

Code: Select all

SELECT * FROM
  videos v, members m, videos_anime va, songs s, videos_songs vs,
  categories c, videos_categories vc
 WHERE 1=1

[Phade]

Hey Chao,

With the Super Search switching over to a boolean mode fulltext search, you will soon be able to do all of those using the fulltext boolean operators. In this current implementation, the queries are set to maximum restrictiveness. Soon there will be better input string parsing to allow users more flexability in their searches.

Having members construct and execute their own SQL statements would generally be a Bad Thing.

I hope this helps.

Phade.

[trythil]

Code: Select all

SELECT * FROM
  videos v, members m, videos_anime va, songs s, videos_songs vs,
  categories c, videos_categories vc
 WHERE 1=1

You should also throw in joins on the anime and music tables, just to highlight the inanity of the idea.

With all the time it'd take to design, implement, debug, and test the filtering code, it'd most likely have been more efficient to just make new searches on request.