Thread: Archives / search
Guys, I came across fudforum, in case you've never heard of it. It is a discussion forum, but has support for mailing list integration/syncronisation and can even send incoming posts, be that from the lists or by online posts, to a newsgroup. (and can of course syncronize with a newsgroup too) It has a built in search engine, threaded tree views, and of course supports PostgreSQL. Might be worth going for this, as it is well maintained, and fairly easy to set up / configure. Supports themes too... ... John
> -----Original Message----- > From: pgsql-www-owner@postgresql.org > [mailto:pgsql-www-owner@postgresql.org] On Behalf Of John Hansen > Sent: 30 September 2004 14:26 > To: pgsql-www@postgresql.org > Subject: [pgsql-www] Archives / search > > It has a built in search engine, threaded tree views, and of > course supports PostgreSQL. > > Might be worth going for this, as it is well maintained, and > fairly easy to set up / configure. > > Supports themes too... Cool - is this something you have the time/inclination to investigate further? Regards, Dave
> > Cool - is this something you have the time/inclination to > investigate further? > Yes, it's currently running on 220.244.191.249 & 220.244.191.250 but on a vhost, so you need to set your proxy to one of those, or alternatively add forum.postgresql.org A records to DNS. pgsql-www only, and from today only.... Would need the mbox files to feed them to the forum :) ... John
John Hansen wrote: <snip> > Yes, it's currently running on 220.244.191.249 & 220.244.191.250 but on > a vhost, so you need to set your proxy to one of those, or alternatively > add forum.postgresql.org A records to DNS. Let's get that done, see if it works nicely, then ask a wider audience for feedback? :) Regards and best wishes, Justin Clift > pgsql-www only, and from today only.... > > Would need the mbox files to feed them to the forum :) > > ... John > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly
> >> 'k, first look and I know I wouldn't use it, so let's do it as an 'option' > >> vs a 'replacement' ... thing is, we have realtime right now also, and that > >> is the news groups, and, to be honest, I much prefer using a news reader > >> to read a group then a forum ... Second look, after importing just 1500 messages from -admin : search sucks big time, even browsing takes forever. No, I don't think this will work. I think i'll look for something else... :) ... John
John Hansen wrote: >>>>'k, first look and I know I wouldn't use it, so let's do it as an 'option' >>>>vs a 'replacement' ... thing is, we have realtime right now also, and that >>>>is the news groups, and, to be honest, I much prefer using a news reader >>>>to read a group then a forum ... > > > Second look, after importing just 1500 messages from -admin : search > sucks big time, even browsing takes forever. No, I don't think this will > work. I think i'll look for something else... :) Any chance that it's just badly optimised tables? i.e. missing indexes and such? Regards and best wishes, Justin Clift > ... John > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> Any chance that it's just badly optimised tables? i.e. missing indexes > and such? I'll have a look, but I don't think so.... ... John
> > Any chance that it's just badly optimised tables? i.e. > missing indexes and such? > Indeed, removing the varchar(x) limitations, and reindexing the database helped a lot. ... John