pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Mark Stosberg <mark@summersault.com>
To: Madison Kelly <linux@alteeve.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Writting a "search engine" for a pgsql DB
Date: Mon, 26 Feb 2007 14:46:18 -0500
Message-ID: <45E3390A.9000908@summersault.com> (raw)
In-Reply-To: <45E32E21.9090901@alteeve.com>
References: <45E30ADA.2050700@alteeve.com>
	<45E31300.4070701@commandprompt.com>
	<erv5jn$2l1b$1@news.hub.org>
	<45E31D28.2020402@alteeve.com>
	<45E323AB.1040009@summersault.com>
	<45E32E21.9090901@alteeve.com>

>
> Now see, this is exactly the kind of sagely advice I was hoping for! :)
> 
> I'll look into tsearch2, and failing that for some reason, I love the
> keyword table idea.

For example keyword search code, you can try this package:

http://downloads.sourceforge.net/cascade/cascade-devel-pieces-1.1.tgz?modtime=999556617&big_mirr...

There is a "keywords" subdirectory with the Perl and SQL. I'm sure this
code is not ideal in a number of ways:

1. It's from 2001.
2. It doesn't actually function on it's own anymore. However, you can
read the code and get ideas.
3. I'm sure someone has a better looking/functioning example!

Anyway, it's there if you want to take a look.

  Mark

view thread (21+ messages)  latest in thread

Message-ID: <45E3390A.9000908@summersault.com>
Permalink:  ../45E3390A.9000908@summersault.com/
Also on:    postgresql.org/message-id/45E3390A.9000908@summersault.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: mark@summersault.com, linux@alteeve.com
  Subject: Re: Writting a "search engine" for a pgsql DB
  In-Reply-To: <45E3390A.9000908@summersault.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox