[thesite] Tips Database

Seth Bienek seth at sethbienek.com
Mon Jul 23 12:23:46 CDT 2001

> Okay, all of the messages are in THELIST table now.

I couldn't connect to the datasource for thelist - I think it was a MYSQL table.

What is the structure of the Oracle table? Dan? Anyone?

> Not sure what the plan for tip extraction is.

The plan for tip extraction (not optimized for performance but should give you the idea):

Select id, fromemail, messagebody
from thelist

loop through results

   (parse messagebody for tips

    for each tip
      (insert into thetips (tipid, messageid, fromemail, attribauthor, attribtype, tipcontent)
       values...  etc..


"The statistics on sanity are that one out of every four Americans is suffering from some form of mental illness.  Think of your three best friends.  If they're okay, then it's you."  -Rita Mae Brown

Seth Bienek
Digitaris Technologies, Inc.
tel (972) 690-4131, ext. 103
fax (972) 690-0617
icq 7673959

More information about the thesite mailing list