From mboxrd@z Thu Jan 1 00:00:00 1970 X-Msuck: nntp://news.gmane.io/gmane.emacs.gnus.general/26528 Path: main.gmane.org!not-for-mail From: john s anderson Newsgroups: gmane.emacs.gnus.general Subject: Re: mysql as a backend Date: Tue, 9 Nov 1999 10:48:26 -0700 (MST) Sender: owner-ding@hpc.uh.edu Message-ID: References: NNTP-Posting-Host: coloc-standby.netfonds.no Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Trace: main.gmane.org 1035163720 19876 80.91.224.250 (21 Oct 2002 01:28:40 GMT) X-Complaints-To: usenet@main.gmane.org NNTP-Posting-Date: Mon, 21 Oct 2002 01:28:40 +0000 (UTC) Cc: ding@gnus.org Return-Path: Original-Received: from lisa.math.uh.edu (lisa.math.uh.edu [129.7.128.49]) by sclp3.sclp.com (8.8.5/8.8.5) with ESMTP id MAA20029 for ; Tue, 9 Nov 1999 12:49:51 -0500 (EST) Original-Received: from sina.hpc.uh.edu (lists@Sina.HPC.UH.EDU [129.7.3.5]) by lisa.math.uh.edu (8.9.1/8.9.1) with ESMTP id LAB00314; Tue, 9 Nov 1999 11:49:49 -0600 (CST) Original-Received: by sina.hpc.uh.edu (TLB v0.09a (1.20 tibbs 1996/10/09 22:03:07)); Tue, 09 Nov 1999 11:49:46 -0600 (CST) Original-Received: from sclp3.sclp.com (root@sclp3.sclp.com [204.252.123.139]) by sina.hpc.uh.edu (8.9.3/8.9.3) with ESMTP id LAA03177 for ; Tue, 9 Nov 1999 11:49:32 -0600 (CST) Original-Received: from cepheus.azstarnet.com (cepheus.azstarnet.com [169.197.56.195]) by sclp3.sclp.com (8.8.5/8.8.5) with ESMTP id MAA20006 for ; Tue, 9 Nov 1999 12:49:02 -0500 (EST) Original-Received: from andromeda.azstarnet.com (jacobs@andromeda.azstarnet.com [169.197.53.210]) by cepheus.azstarnet.com (8.9.3+blt.Beta0/8.9.3) with ESMTP id KAA16177; Tue, 9 Nov 1999 10:48:55 -0700 (MST) Original-Received: from localhost (jacobs@localhost) by andromeda.azstarnet.com (8.8.5-nerd/8.8.5) with SMTP id KAA23805; Tue, 9 Nov 1999 10:48:27 -0700 (MST) X-Sent-via: StarNet http://www.azstarnet.com/ X-Authentication-Warning: andromeda.azstarnet.com: jacobs owned process doing -bs Original-To: "Randal L. Schwartz" In-Reply-To: Precedence: list X-Majordomo: 1.94.jlt7 Xref: main.gmane.org gmane.emacs.gnus.general:26528 X-Report-Spam: http://spam.gmane.org/gmane.emacs.gnus.general:26528 On 9 Nov 1999, Randal L. Schwartz wrote: > has anyone done any work on hooking up a database like mysql as a back end? I've done a small bit of preliminary noodling on implementing a SQL-based mail archive. I was planning on making it non-MUA-specific, so that if something better than Gnus came along (inconceivable!), switching my MUA wouldn't affect my mail archiving. (I've been burned on that before, with the Postilion->Gnus switch I did some months ago.) I was planning on providing hooks to tie into in the archiving and searching interfaces, and hoping that eventually someone would tie it into Gnus. > I was thinking of a few approaches: > 2) write a Perl program that would ensure clean input/output using DBI/DBD > but with an easily parseable command interface, then wrap that This was the approach I was planning on; I've got some Perl that slurps mail folders, parses headers, and does a half-ass intertwingle thing. (That's mostly in the design of the SQL database, actually.) That's about as far as I've gotten; my hacking time has been pretty limited of late. > Any thoughts? Am I crazy? This is something I would _love_ to have; finding old stored mail is starting to become a real PITA. Please let me know if you do start working on something, if there's any way I can help, if you'd like my pitiful code, etc. john. -- ---------------------------------------------------------------- John S Jacobs Anderson jacobs@genehack.org www.genehack.org <----- GeneHack (bioinfo*linux*opinion)