Gossamer Forum
(Advanced Search)
for
Home : General : Perl Programming :

Mailing list

Apr 25, 2002, 8:49 AM
Wil
Veteran / Moderator (4108 posts)
Apr 25, 2002, 8:49 AM
Post #1 of 7
Views: 4542
Shortcut
Quote Reply
Mailing list
Anyone know of a good, simple mailing list written in Perl? Basically I have a database which has the following strucutre (extremly simple):

Code:
CREATE TABLE rd_news (
id smallint(4) DEFAULT '' NOT NULL auto_increment,
name text ,
email text ,
PRIMARY KEY (id),
UNIQUE id (id)
);

And now I need to send out an email to the 1,000 or so entries I have. I would just go ahead and write a loop to just send them out to sendmail - is this OK or am I going to kill the server?

Cheers

- wil
Apr 25, 2002, 8:53 AM
Paul
Veteran (19537 posts)
Apr 25, 2002, 8:53 AM
Post #2 of 7
Views: 4378
Shortcut
Quote Reply
Re: [Wil] Mailing list In reply to
Other than using a loop how do you think other peoples scripts are going to do it? Wink

Btw...if thats the only table you have what use is the id field?

Im sure I remember you asking this a few weeks ago and Alex replied saying that qmail/sendmail handle the sending so you just need to generate the emails.
Apr 25, 2002, 9:02 AM
Wil
Veteran / Moderator (4108 posts)
Apr 25, 2002, 9:02 AM
Post #3 of 7
Views: 4390
Shortcut
Quote Reply
Re: [Paul] Mailing list In reply to
Yeah, I thought that too! I think I'm going crazy.

Ah well, I'll just loop through and send them all then. I'm just nervous about crashing the server, that's all!

What is the purpose of the id column? I have other relational tables with further information about each user.

- wil
Apr 25, 2002, 12:41 PM
yogi
Veteran (2199 posts)
Apr 25, 2002, 12:41 PM
Post #4 of 7
Views: 4375
Shortcut
Quote Reply
Re: [Wil] Mailing list In reply to
GT::Mail::BulkMail...

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Apr 25, 2002, 12:45 PM
Alex
Administrator (9387 posts)
Apr 25, 2002, 12:45 PM
Post #5 of 7
Views: 4364
Shortcut
Quote Reply
Re: [yogi] Mailing list In reply to
Actually, we are scrapping BulkMail. It was designed to use a single SMTP connection to send multiple messages, rather then opening sendmail, sending a message, closing sendmail.

However, in practice, if you make sure sendmail/qmail is queing the message rather then delivering it, you'll get faster delivery of messages.

Cheers,

Alex
--
Gossamer Threads Inc.
Apr 27, 2002, 8:04 AM
Wil
Veteran / Moderator (4108 posts)
Apr 27, 2002, 8:04 AM
Post #6 of 7
Views: 4360
Shortcut
Quote Reply
Re: [Alex] Mailing list In reply to
I'm sold. How can I make sure my qmail is queuing properly? :-)

- wil
May 1, 2002, 11:13 AM
Paul
Veteran (19537 posts)
May 1, 2002, 11:13 AM
Post #7 of 7
Views: 4309
Shortcut
Quote Reply
Re: [Wil] Mailing list In reply to
Ooo forgot this one the other day....

You can use something like:

open (MAIL, "| /usr/sbin/sendmail -odq") or die $!;

-odq tells sendmail/qmail to queue the messages.

Look at the -oi and -t switches too.

Then go here:

http://gd.tuwien.ac.at/...r/bulk_mailer.README

Last edited by:

Paul: May 1, 2002, 11:16 AM