FUDforum: FUDforum Suggestions » Implement postgresql ts

Home » FUDforum » FUDforum Suggestions » Implement postgresql ts_query

Show: Today's Messages :: Polls :: Message Navigator

Implement postgresql ts_query [message #164892]

Tue, 29 March 2011 19:41

simonlnu

Messages: 19
Registered: March 2011
Location: Tiohtiake

Karma: 0

Junior Member

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]

Wed, 30 March 2011 02:12

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

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]

Wed, 30 March 2011 02:34

simonlnu

Messages: 19
Registered: March 2011
Location: Tiohtiake

Karma: 0

Junior Member

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

Previous Topic:	Modernize the design and look
Next Topic:	Unread messages

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 12:59:02 GMT 2024

Total time taken to generate the page: 0.02436 seconds