Re: [GENERAL] PG Email Client

2007-02-21 Thread Michelle Konzack
Am 2007-01-30 07:56:32, schrieb Sim Zacks: > In the traditional imap server the mail is stored in folders on the server > that are accessed by the client. Therefore you are limited to one indexed > location per email. Lets say you want to look at your email by customer. > You would want to have

Re: [GENERAL] PG Email Client

2007-02-21 Thread Michelle Konzack
Hello Sim, Am 2007-01-29 14:29:27, schrieb Sim Zacks: > For example, instead of saving a copy of an email in 1 folder, the same > email could be indexed to multiple folders. Current email clients mimic > file cabinets too much in that the system considers an email to be a > physical entity that

Re: [GENERAL] PG Email Client

2007-02-05 Thread Alban Hertroys
Tom Allison wrote: > I would be careful about using dspam. > > I have documented cases where it lost email and even with posting all > the debug and other logs on the mailing lists I've never received any > indication that they recognize this as a dspam problem. > > dspam will lose your mail. Th

Re: [GENERAL] PG Email Client

2007-02-03 Thread Joshua D. Drake
> I would be careful about using dspam. > > I have documented cases where it lost email and even with posting all > the debug and other logs on the mailing lists I've never received any > indication that they recognize this as a dspam problem. > > dspam will lose your mail. *ahem* I have severa

Re: [GENERAL] PG Email Client

2007-02-03 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/03/07 07:17, Tom Allison wrote: > Alban Hertroys wrote: >> Jean-Gérard Pailloncy wrote: [snip] > The *one* feature I did like about dspam is they quarantine spam and you > can sort it out later. That can be done easily enough and won't > interfe

Re: [GENERAL] PG Email Client

2007-02-03 Thread Tom Allison
Alban Hertroys wrote: Jean-Gérard Pailloncy wrote: I do not have test numbers rigth now, because I need first to configure the box for virtual hosting, then dspam. It would be really wonderful if someone managed to combine this with dspams own database. Maybe it'd be possible to pull dspam's a

Re: [GENERAL] PG Email Client

2007-02-01 Thread Jean-Gérard Pailloncy
> Jean-Gérard Pailloncy wrote: >> I do not have test numbers rigth now, because I need first to configure >> the box for virtual hosting, then dspam. > > It would be really wonderful if someone managed to combine this with > dspams own database. Maybe it'd be possible to pull dspam's algorithms > a

Re: [GENERAL] PG Email Client

2007-02-01 Thread Alban Hertroys
Jean-Gérard Pailloncy wrote: > I do not have test numbers rigth now, because I need first to configure > the box for virtual hosting, then dspam. It would be really wonderful if someone managed to combine this with dspams own database. Maybe it'd be possible to pull dspam's algorithms as a lib int

Re: [GENERAL] PG Email Client

2007-02-01 Thread Jean-Gérard Pailloncy
> Please keep us posted on your archiveopteryx experience! I just install aox on a soekris ! with openbsd 4.0 with a remote postgresl db and setup sendmail to forward by lmtp. Really nice. No problem to compile (just a postgresql.h in a obsd specific location). The installer (wich cretae the databa

Re: [GENERAL] PG Email Client

2007-01-31 Thread Michael Slattery
Please keep us posted on your archiveopteryx experience! Thanks and Cheers. They may have fixed this in the meantime. I did look at the schema for archiveopteryx, and it looked to me to be much better thought out. I got as far as compiling archiveopteryx on my OS of choice (OpenBSD, no f

Re: [GENERAL] PG Email Client

2007-01-31 Thread Jim Rosenberg
dbmail isn't as fast as dovecot for a single user, single event. But not by much. However, it scales *much* better into the 100's and 1000's of actions. <$.02> I came within an eyelash of going live with dbmail, and then pulled back. This was a year or so ago, I don't remember exactly. The p

Re: [GENERAL] PG Email Client

2007-01-30 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/30/07 00:32, Hakan Kocaman wrote: > Hi, > > you can find a nice virtual folder implementation in the > Opera-Mailclient M2. Not sure if this also works with IMAP (don't > use IMAP yet). > > Virtual folders are based on regexes over various fiel

Re: [GENERAL] PG Email Client

2007-01-29 Thread Hakan Kocaman
neat. Just my 0,02€ Hakan > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Sim Zacks > Sent: Tuesday, January 30, 2007 6:57 AM > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] PG Email Client > > > >

Re: [GENERAL] PG Email Client

2007-01-29 Thread Sim Zacks
> Err... I do not understand "copy an email in 1 folder" - I use IMAP which stores all the mail on the server. (That is what dbmail does too) In the traditional imap server the mail is stored in folders on the server that are accessed by the client. Therefore you are limited to one indexed lo

Re: [GENERAL] PG Email Client

2007-01-29 Thread Christopher Browne
Sim Zacks <[EMAIL PROTECTED]> wrote: > DBMail is an interesting concept, but I think the real advantage would > be if there were a client that could take advantage of the power of a > database backend. > > For example, instead of saving a copy of an email in 1 folder, the > same email could be inde

Re: [GENERAL] PG Email Client

2007-01-29 Thread tom
Might I suggest you consider using dbmail as an IMAP server. This indexing you speak of is exactly what it will do. But the additional advantage with IMAP is that you can have multiple clients attached to the same folders (especially useful if shared) or be able to attach from multiple sources (

Re: [GENERAL] PG Email Client

2007-01-29 Thread Tino Wildenhain
Sim Zacks schrieb: DBMail is an interesting concept, but I think the real advantage would be if there were a client that could take advantage of the power of a database backend. For example, instead of saving a copy of an email in 1 folder, the same email could be indexed to multiple folders.

Re: [GENERAL] PG Email Client

2007-01-29 Thread Michael Slattery
Hello list, Has anyone checked out http://www.archiveopteryx.org/ looks very promising! Cheers, Mike ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] PG Email Client

2007-01-29 Thread Tom Allison
Tino Wildenhain wrote: Sim Zacks schrieb: Are there any postgresql based email clients that anyone has experience with? Well "client" would be the wrong approach imho, but there is for example dbmail which can use postgres as storage for mail and opens a lot of the usecases above. You would c

Re: [GENERAL] PG Email Client

2007-01-29 Thread Sim Zacks
DBMail is an interesting concept, but I think the real advantage would be if there were a client that could take advantage of the power of a database backend. For example, instead of saving a copy of an email in 1 folder, the same email could be indexed to multiple folders. Current email client

Re: [GENERAL] PG Email Client

2007-01-29 Thread Tino Wildenhain
Sim Zacks schrieb: Are there any postgresql based email clients that anyone has experience with? Is there a good technical reason why everyone is not doing this? It would seem to me to be a super CRM/ERP enhancement. I am toying with the idea of fully integrating email into our ERP system so