On 10/19/08, circ ular <[EMAIL PROTECTED]> wrote: > I am writing a mini-search engine. > > I have a bunch of posts from a forum that I want to index so I can search it. > > So I want to be able to do lookups on words and then get every post it > has been seen in(I have parsed all this already). > > So when I do : > quickQuery' conn "SELECT * from proglangs where id == 'java'" [] > it should return a list of the posts. > > or should i have one table for each keyword!? seems expensive. > > is it possible to have table-elements that point to other tables?
I would use the right tool for the right job. For the kind of job described above, full-text search would be appropriated, and wait, it has already been built by folks from that small search company out West. Implement FTS3. -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
