public inbox for [email protected]  
help / color / mirror / Atom feed
Wanted: Volunteer web developer for small project on www.postgresql.org
7+ messages / 4 participants
[nested] [flat]

* Wanted: Volunteer web developer for small project on www.postgresql.org
@ 2005-09-28 20:07 Dave Page <[email protected]>
  2005-09-28 21:00 ` Re: Wanted: Volunteer web developer for small project on www.postgresql.org Gevik babakhani <[email protected]>
  0 siblings, 1 reply; 7+ messages in thread

From: Dave Page @ 2005-09-28 20:07 UTC (permalink / raw)
  To: pgsql-www

Hi all,

Thought I'd throw this out to the list - we're finding that the web
forms on www.postgresql.org are suffering more and more from the effects
of spam-bots which are inundating us with junk submissions. I think the
simplest solution would be to add a confirmation stage to all submission
forms that asks the user to enter a code from an image, much as many
blogs and other sites do.

So, if anyone has been looking for a small project, and would like to
investigate further and implement a solution, we'd love to hear from
you!

Regards, Dave.



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Wanted: Volunteer web developer for small project on www.postgresql.org
  2005-09-28 20:07 Wanted: Volunteer web developer for small project on www.postgresql.org Dave Page <[email protected]>
@ 2005-09-28 21:00 ` Gevik babakhani <[email protected]>
  2005-09-28 22:32   ` Re: Wanted: Volunteer web developer for small project on www.postgresql.org Gavin M. Roy <[email protected]>
  0 siblings, 1 reply; 7+ messages in thread

From: Gevik babakhani @ 2005-09-28 21:00 UTC (permalink / raw)
  To: 'Dave Page' <[email protected]>; pgsql-www

Dave,

Perhaps I can be of help as I am waiting for Gavin to update the
framework.org.

What do you think about having to type a random word generated in an image
before being able to submit anything?

Regards,
Gevik.

> -----Original Message-----
> From: [email protected] [mailto:pgsql-www-
> [email protected]] On Behalf Of Dave Page
> Sent: Wednesday, September 28, 2005 10:08 PM
> To: [email protected]
> Subject: [pgsql-www] Wanted: Volunteer web developer for small project on
> www.postgresql.org
> 
> Hi all,
> 
> Thought I'd throw this out to the list - we're finding that the web
> forms on www.postgresql.org are suffering more and more from the effects
> of spam-bots which are inundating us with junk submissions. I think the
> simplest solution would be to add a confirmation stage to all submission
> forms that asks the user to enter a code from an image, much as many
> blogs and other sites do.
> 
> So, if anyone has been looking for a small project, and would like to
> investigate further and implement a solution, we'd love to hear from
> you!
> 
> Regards, Dave.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Wanted: Volunteer web developer for small project on www.postgresql.org
  2005-09-28 20:07 Wanted: Volunteer web developer for small project on www.postgresql.org Dave Page <[email protected]>
  2005-09-28 21:00 ` Re: Wanted: Volunteer web developer for small project on www.postgresql.org Gevik babakhani <[email protected]>
@ 2005-09-28 22:32   ` Gavin M. Roy <[email protected]>
  2005-09-28 22:39     ` Re: Wanted: Volunteer web developer for small project on www.postgresql.org Gevik babakhani <[email protected]>
  0 siblings, 1 reply; 7+ messages in thread

From: Gavin M. Roy @ 2005-09-28 22:32 UTC (permalink / raw)
  To: Gevik babakhani <[email protected]>; +Cc: 'Dave Page' <[email protected]>; pgsql-www

http://sourceforge.net/projects/session-captcha/ is a GD based HIV  
app I wrote in PHP and PostgreSQL a few years back.  Could be of some  
use with some modification.

Gavin

On Sep 28, 2005, at 2:00 PM, Gevik babakhani wrote:

> Dave,
>
> Perhaps I can be of help as I am waiting for Gavin to update the
> framework.org.
>
> What do you think about having to type a random word generated in  
> an image
> before being able to submit anything?
>
> Regards,
> Gevik.
>
>
>> -----Original Message-----
>> From: [email protected] [mailto:pgsql-www-
>> [email protected]] On Behalf Of Dave Page
>> Sent: Wednesday, September 28, 2005 10:08 PM
>> To: [email protected]
>> Subject: [pgsql-www] Wanted: Volunteer web developer for small  
>> project on
>> www.postgresql.org
>>
>> Hi all,
>>
>> Thought I'd throw this out to the list - we're finding that the web
>> forms on www.postgresql.org are suffering more and more from the  
>> effects
>> of spam-bots which are inundating us with junk submissions. I  
>> think the
>> simplest solution would be to add a confirmation stage to all  
>> submission
>> forms that asks the user to enter a code from an image, much as many
>> blogs and other sites do.
>>
>> So, if anyone has been looking for a small project, and would like to
>> investigate further and implement a solution, we'd love to hear from
>> you!
>>
>> Regards, Dave.
>>
>> ---------------------------(end of  
>> broadcast)---------------------------
>> TIP 9: In versions below 8.0, the planner will ignore your desire to
>>        choose an index scan if your joining column's datatypes do not
>>        match
>>
>
>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

Gavin M. Roy
800 Pound Gorilla
[email protected]





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Wanted: Volunteer web developer for small project on www.postgresql.org
  2005-09-28 20:07 Wanted: Volunteer web developer for small project on www.postgresql.org Dave Page <[email protected]>
  2005-09-28 21:00 ` Re: Wanted: Volunteer web developer for small project on www.postgresql.org Gevik babakhani <[email protected]>
  2005-09-28 22:32   ` Re: Wanted: Volunteer web developer for small project on www.postgresql.org Gavin M. Roy <[email protected]>
@ 2005-09-28 22:39     ` Gevik babakhani <[email protected]>
  0 siblings, 0 replies; 7+ messages in thread

From: Gevik babakhani @ 2005-09-28 22:39 UTC (permalink / raw)
  To: 'Gavin M. Roy' <[email protected]>; +Cc: 'Dave Page' <[email protected]>; pgsql-www

Thanx Gavin, I will check the script :)

> -----Original Message-----
> From: [email protected] [mailto:pgsql-www-
> [email protected]] On Behalf Of Gavin M. Roy
> Sent: Thursday, September 29, 2005 12:32 AM
> To: Gevik babakhani
> Cc: 'Dave Page'; [email protected]
> Subject: Re: [pgsql-www] Wanted: Volunteer web developer for small project
> on www.postgresql.org
> 
> http://sourceforge.net/projects/session-captcha/ is a GD based HIV
> app I wrote in PHP and PostgreSQL a few years back.  Could be of some
> use with some modification.
> 
> Gavin
> 
> On Sep 28, 2005, at 2:00 PM, Gevik babakhani wrote:
> 
> > Dave,
> >
> > Perhaps I can be of help as I am waiting for Gavin to update the
> > framework.org.
> >
> > What do you think about having to type a random word generated in
> > an image
> > before being able to submit anything?
> >
> > Regards,
> > Gevik.
> >
> >
> >> -----Original Message-----
> >> From: [email protected] [mailto:pgsql-www-
> >> [email protected]] On Behalf Of Dave Page
> >> Sent: Wednesday, September 28, 2005 10:08 PM
> >> To: [email protected]
> >> Subject: [pgsql-www] Wanted: Volunteer web developer for small
> >> project on
> >> www.postgresql.org
> >>
> >> Hi all,
> >>
> >> Thought I'd throw this out to the list - we're finding that the web
> >> forms on www.postgresql.org are suffering more and more from the
> >> effects
> >> of spam-bots which are inundating us with junk submissions. I
> >> think the
> >> simplest solution would be to add a confirmation stage to all
> >> submission
> >> forms that asks the user to enter a code from an image, much as many
> >> blogs and other sites do.
> >>
> >> So, if anyone has been looking for a small project, and would like to
> >> investigate further and implement a solution, we'd love to hear from
> >> you!
> >>
> >> Regards, Dave.
> >>
> >> ---------------------------(end of
> >> broadcast)---------------------------
> >> TIP 9: In versions below 8.0, the planner will ignore your desire to
> >>        choose an index scan if your joining column's datatypes do not
> >>        match
> >>
> >
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 2: Don't 'kill -9' the postmaster
> >
> 
> Gavin M. Roy
> 800 Pound Gorilla
> [email protected]
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Wanted: Volunteer web developer for small project on www.postgresql.org
@ 2005-09-28 21:11 Dave Page <[email protected]>
  2005-09-28 22:21 ` Re: Wanted: Volunteer web developer for small project on www.postgresql.org Gevik babakhani <[email protected]>
  0 siblings, 1 reply; 7+ messages in thread

From: Dave Page @ 2005-09-28 21:11 UTC (permalink / raw)
  To: Gevik babakhani <[email protected]>; pgsql-www

 

> -----Original Message-----
> From: Gevik babakhani [mailto:[email protected]] 
> Sent: 28 September 2005 22:01
> To: Dave Page; [email protected]
> Subject: RE: [pgsql-www] Wanted: Volunteer web developer for 
> small project on www.postgresql.org
> 
> Dave,
> 
> Perhaps I can be of help as I am waiting for Gavin to update the
> framework.org.

Great, thanks Gevik.

> What do you think about having to type a random word 
> generated in an image
> before being able to submit anything?

Yes, that's exactly what I think we need, however, I think we need to
add that in a separate step, rather than on the initial form because
they will be served by the static servers:

- Static server serves form (in most cases this will be part of a doc
page, so serving forms from wwwmaster really isn't an option).
- User fills form and submits it to the script on wwwmaster.
- Server temporarily stores the submission - perhaps in a session
variable.
- wwwmaster generates the random word and sends it to the user on a
simple confirmation form.
- User submits confirmation form, and their original submission is
processed from the temporary storage.

Sound reasonable?

Regards Dave



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Wanted: Volunteer web developer for small project on www.postgresql.org
  2005-09-28 21:11 Re: Wanted: Volunteer web developer for small project on www.postgresql.org Dave Page <[email protected]>
@ 2005-09-28 22:21 ` Gevik babakhani <[email protected]>
  2005-09-28 22:25   ` Re: Wanted: Volunteer web developer for small project on www.postgresql.org Robert Bernier <[email protected]>
  0 siblings, 1 reply; 7+ messages in thread

From: Gevik babakhani @ 2005-09-28 22:21 UTC (permalink / raw)
  To: 'Dave Page' <[email protected]>; pgsql-www

Sounds very good. I will give it a start by gathering some info on this.


> -----Original Message-----
> From: Dave Page [mailto:[email protected]]
> Sent: Wednesday, September 28, 2005 11:12 PM
> To: Gevik babakhani; [email protected]
> Subject: RE: [pgsql-www] Wanted: Volunteer web developer for small project
> on www.postgresql.org
> 
> 
> 
> > -----Original Message-----
> > From: Gevik babakhani [mailto:[email protected]]
> > Sent: 28 September 2005 22:01
> > To: Dave Page; [email protected]
> > Subject: RE: [pgsql-www] Wanted: Volunteer web developer for
> > small project on www.postgresql.org
> >
> > Dave,
> >
> > Perhaps I can be of help as I am waiting for Gavin to update the
> > framework.org.
> 
> Great, thanks Gevik.
> 
> > What do you think about having to type a random word
> > generated in an image
> > before being able to submit anything?
> 
> Yes, that's exactly what I think we need, however, I think we need to
> add that in a separate step, rather than on the initial form because
> they will be served by the static servers:
> 
> - Static server serves form (in most cases this will be part of a doc
> page, so serving forms from wwwmaster really isn't an option).
> - User fills form and submits it to the script on wwwmaster.
> - Server temporarily stores the submission - perhaps in a session
> variable.
> - wwwmaster generates the random word and sends it to the user on a
> simple confirmation form.
> - User submits confirmation form, and their original submission is
> processed from the temporary storage.
> 
> Sound reasonable?
> 
> Regards Dave





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Wanted: Volunteer web developer for small project on www.postgresql.org
  2005-09-28 21:11 Re: Wanted: Volunteer web developer for small project on www.postgresql.org Dave Page <[email protected]>
  2005-09-28 22:21 ` Re: Wanted: Volunteer web developer for small project on www.postgresql.org Gevik babakhani <[email protected]>
@ 2005-09-28 22:25   ` Robert Bernier <[email protected]>
  0 siblings, 0 replies; 7+ messages in thread

From: Robert Bernier @ 2005-09-28 22:25 UTC (permalink / raw)
  To: pgsql-www

I suggest you research the ImageMagick suite. It should give you everything 
you need.

On Wednesday 28 September 2005 18:21, Gevik babakhani wrote:
> Sounds very good. I will give it a start by gathering some info on this.
>
> > -----Original Message-----
> > From: Dave Page [mailto:[email protected]]
> > Sent: Wednesday, September 28, 2005 11:12 PM
> > To: Gevik babakhani; [email protected]
> > Subject: RE: [pgsql-www] Wanted: Volunteer web developer for small
> > project on www.postgresql.org
> >
> > > -----Original Message-----
> > > From: Gevik babakhani [mailto:[email protected]]
> > > Sent: 28 September 2005 22:01
> > > To: Dave Page; [email protected]
> > > Subject: RE: [pgsql-www] Wanted: Volunteer web developer for
> > > small project on www.postgresql.org
> > >
> > > Dave,
> > >
> > > Perhaps I can be of help as I am waiting for Gavin to update the
> > > framework.org.
> >
> > Great, thanks Gevik.
> >
> > > What do you think about having to type a random word
> > > generated in an image
> > > before being able to submit anything?
> >
> > Yes, that's exactly what I think we need, however, I think we need to
> > add that in a separate step, rather than on the initial form because
> > they will be served by the static servers:
> >
> > - Static server serves form (in most cases this will be part of a doc
> > page, so serving forms from wwwmaster really isn't an option).
> > - User fills form and submits it to the script on wwwmaster.
> > - Server temporarily stores the submission - perhaps in a session
> > variable.
> > - wwwmaster generates the random word and sends it to the user on a
> > simple confirmation form.
> > - User submits confirmation form, and their original submission is
> > processed from the temporary storage.
> >
> > Sound reasonable?
> >
> > Regards Dave
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq




^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2005-09-28 22:39 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-09-28 20:07 Wanted: Volunteer web developer for small project on www.postgresql.org Dave Page <[email protected]>
2005-09-28 21:00 ` Gevik babakhani <[email protected]>
2005-09-28 22:32   ` Gavin M. Roy <[email protected]>
2005-09-28 22:39     ` Gevik babakhani <[email protected]>
2005-09-28 21:11 Re: Wanted: Volunteer web developer for small project on www.postgresql.org Dave Page <[email protected]>
2005-09-28 22:21 ` Gevik babakhani <[email protected]>
2005-09-28 22:25   ` Robert Bernier <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox