[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: seeking mailing list from SQL

On Thu, Oct 02, 2003 at 10:11:15PM +0200, martin f krafft wrote:
> also sprach Mark Ferlatte <ferlatte@cryptio.net> [2003.10.02.2156 +0200]:
> > remove_members --all mylist
> > mysql -h localhost -e "SELECT email from people" mydb | \
> > 	add_members -n - -c n -w n mylist
> I know about the script possibility, but what then if someone
> unsubscribes from the mailinglist a minute before a new mail is
> sent. People get annoyed about these things, trust me. And I can't
> run a cron script every minute. I'd much rather have the mailing
> list manager contact the database when it's needed.

How about a trigger in the database that runs the script ? I never tried
it, but it should work

> -- 
> Please do not CC me when replying to lists; I read them!
>  .''`.     martin f. krafft <madduck@debian.org>
> : :'  :    proud Debian developer, admin, and user
> `. `'`
>   `-  Debian - when you have better things to do than fixing a system
> Invalid/expired PGP subkeys? Use subkeys.pgp.net as keyserver!

Reply to: