FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » FUDforum Suggestions » Implement postgresql ts_query
Show: Today's Messages :: Unread Messages :: 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
 remove from 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.

Report message to a moderator

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: 3775
Registered: December 2004
Karma: 28
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?

Report message to a moderator

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
 remove from 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.

Report message to a moderator

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: Mon May 19 11:56:01 EDT 2025

Total time taken to generate the page: 0.03931 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.2.0.
Copyright ©2001-2025 FUDforum Bulletin Board Software