[thesite] thetips database

Seth Bienek seth at sethbienek.com
Mon Jun 18 10:47:49 CDT 2001


Hi Dean,

I have written a process to do this.. The only problem thus far is reading in the 50+ MB mail archive file and processing the whole thing without any exceptions.

I guess I should explain that.  I wrote a custom tag to parse the tips, and another to parse the mail archive into a the database.  The idea is to archive the messages first, then roll through the message bodies from the database (instead of parsing throughbt that huge mail archive file) and archiving the tips into a second database.  This will also allow us to relate the tips, messages, and author records to each other (which is a very cool thing)..

The process runs fine against a sample file and then bombs against the full archive.  It's something I have been working on incrementally and have been planning on finishing; I will put some time into it today and let you know where it stands this evening.  Should give me a little time to fully evaluate the situation.

Coolio?

Seth

> -----Original Message-----
> From: thesite-admin at lists.evolt.org
> [mailto:thesite-admin at lists.evolt.org]On Behalf Of Dean Mah
> Sent: Monday, June 18, 2001 10:39 AM
> To: thesite at lists.evolt.org
> Subject: [thesite] thetips database
> 
> 
> What's the status of getting thetips into the database?
> 
> What needs to be done?
> 
> Where are thetips going to be stored?  I see that there is a table
> called 'thetips' in the database, are they going to be stored there,
> or is there going to be a separate category put in place.  Are we
> sync'ing thelist membership and weo membership?  Or does someone
> providing a tip get inserting into the weo database if they don't
> already exist?
> 
> This has been outstanding for a while now, a lot of that my fault, so
> let's fast track this through the process.  :)  Or at least give me
> enough information so that I can get something done on it.
> 
> Dean
> 
> _______________________________________________
> http://lists.evolt.org/thesitearchive/
> and new & improved kentucky fried old archives:
> http://lists.evolt.org/thesitearchive/old/
> 
> 






More information about the thesite mailing list