Received: from slip3.raccoon.com (slip3.raccoon.com [165.90.134.130]) by hub.org (8.9.1/8.9.1) with ESMTP id MAA27092 for ; Sun, 24 Jan 1999 12:34:55 -0500 (EST) (envelope-from tim@dmcity.net) Received: from timnt (tim.desmoinesnet.com [165.90.140.11]) by slip3.raccoon.com (8.8.7/8.8.7) with SMTP id LAA03094; Sun, 24 Jan 1999 11:36:57 -0600 Message-ID: <002001be47be$607807f0$0b8c5aa5@timnt.weather.net> Reply-To: "Tim Perdue, The Des Moines City.net" From: "Tim Perdue, The Des Moines City.net" To: "Peter Garner" , "Herouth Maoz" , "JAVAMAIL - Fabrice Scemama" , Subject: Re: [SQL] Java/JDBC/PGSQL Mailing List Archiver Date: Sun, 24 Jan 1999 11:24:14 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 The first raw implementation of this is viewable at my web site, PHPBuilder.com. You can browse articles, threads, and messages, but I don't have the search page up yet. Only 1/200 or so messages is over 8k, so I just truncate those messages when I drop them in the database. I also put in some logic that strips out HTML attachments (for those messages that contain both a plain text message and an HTML message). Take a look at it and let me know what you think. I'll release the source code soon. Thanks, Tim