[Vmail-discuss] popboxes MAX

Odhiambo Washington wash@xxxxxxxxxxxx
Wed, 9 Jan 2002 20:28:28 +0300


* Paul Warren <pdw@ex-parrot.com> [20020109 20:17]: wrote:
> On Wed, Jan 09, 2002 at 07:59:45PM +0300, Odhiambo Washington wrote:
> > > > This sort of things should really be implemented as a DB level
> > > > constraint, but I suspect that MySQL doesn't support this (future TODO:
> > > > move to postgres :-)
> > 
> > Jesus!... I just learnt the little bits about MySQL from our webmaster so that
> > I can implement this and he's still training me. He's not into PostgreSQL.
> > Does that mean I am sunk this early????
> > Sorry...I hope it can be possible with MySQL, even..
> 
> It can be done (and was done previously) when based on MySQL, but it
> needs to be implemented by the code before changes are committed to the
> database.
> 
> Having used both MySQL and PostgreSQL, I prefer Postgres, by MySQL use
> is certainly more widespread.
> 
> > > It's a possibility....
> > 
> > Only it cannot be right away, in the form of a patch or something??
> 
> Changing to Postgres would be a fair amount of work.  Implementing a
> limit on POP boxes in Perl can be done with a relatively simple patch.
> 
> NB This limit was only ever implemented in the web interface - it was
> never in the command line scripts, on the grounds that if you have
> access to the command line scripts you can change the pop box limit
> anyway...
> 
> Paul

Since I am still a beginner, I am now quite divided whether to go the
PostgreSQL or MySQL way. I also just wanted this limitation on the 
web interface. Is that also painful to get working with MySQL? I hate
to put you guys to work when you've not planned it. It's just a humble
request but I sincerely feel you should ignore it if it calls for so
much work. Is PostgreSQL the chosen backend for tpop3d/vmail? If so
then I have no alternative ;-)


TIA


-Wash

S y s t e m s   A d m i n.

-- 
Odhiambo Washington  <wash@wananchi.com>    "The box said 'Requires
Wananchi Online Ltd.  www.wananchi.com      Windows 95, NT, or better,'
Tel: 254 2 313985-9   Fax: 254 2 313922     so I installed FreeBSD."   
GSM: 254 72 743 223   GSM: 254 733 744 121  This sig is McQ!  :-)

++
If this is timesharing, give me my share right now.