FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Suggestions » Implement postgresql ts_query
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Implement postgresql ts_query [message #164892] Tue, 29 March 2011 15:41 Go to next message
simonlnu is currently offline  simonlnu   Canada
Messages: 19
Registered: March 2011
Location: Tiohtiake
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
ts_query supports whatever language you have on your forum, has been standard since 8.4 (IIRC), and is fast.

(I'm also having problems "rebuilding the search index" due to the migration, but that's another issue.)

I think it would be a plus to have this - mysql has similar functions, "full text search" or such.
Re: Implement postgresql ts_query [message #164893 is a reply to message #164892] Tue, 29 March 2011 22:12 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
Sounds interesting. However, it will probably only work when messages are stored inside the database (possible with FUDforum, but the default is files).

How difficult would it be to implement ts_query and full text search?
Where can we find examples/ documentation?
Re: Implement postgresql ts_query [message #164894 is a reply to message #164893] Tue, 29 March 2011 22:34 Go to previous message
simonlnu is currently offline  simonlnu   Canada
Messages: 19
Registered: March 2011
Location: Tiohtiake
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
That's a good point, hadn't thought of the messages in files not db. If this was implemented, it would have to have to have an indirect link that points to the wanted file(s). Or something Wink. Probably better to leave it as-is for now, and maybe keep it as a third-party plugin idea instead, for now.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Modernize the design and look
Next Topic: Unread messages
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Oct 20 12:23:28 EDT 2017

Total time taken to generate the page: 0.00550 seconds