Re: silly quesiton [ot]

2022-01-31 Thread Sam Kuper
On Mon, Jan 31, 2022 at 12:04:57PM +0100, Wojciech Puchar wrote: >>> mbox is multiple emails in single file, maildir is single email in >>> single file >> >> Exactly my point! > > which is good (mbox) in mail archiving. And not much else. Exactly. -- A: When it messes up the order in which

Re: silly quesiton [ot]

2022-01-31 Thread Wojciech Puchar
files". mbox is multiple emails in single file, maildir is single email in single file Exactly my point! which is good (mbox) in mail archiving. And not much else.

Re: silly quesiton [ot]

2022-01-31 Thread Sam Kuper
On Mon, Jan 31, 2022 at 11:26:26AM +0100, Benny Pedersen wrote: > On 2022-01-31 07:23, Sam Kuper wrote: >>DJB developed Maildir to gain performance and reliability improvements >>over mbox files. Unlike Maildirs, mbox files *are* "large flat >>files". > > mbox is multiple emails in single file,

RE: silly quesiton [ot]

2022-01-31 Thread Marc
> > Commercial Dovecot has had the ability to store mails & indexes in > > Object Storage for years now, we are not "working on it" anymore. > > so no one is using dovecot-pro ? (dead sources) :D

Re: silly quesiton [ot]

2022-01-31 Thread Benny Pedersen
On 2022-01-31 11:29, Marc wrote: This 'performance statement' is not even correct under some conditions. I have tested mbox against mdbox, and mbox performed better in those tests. so you are now ready to make a postfix patch ? its called progress on make ...

Re: silly quesiton [ot]

2022-01-31 Thread Aki Tuomi
> On 31/01/2022 12:29 Benny Pedersen wrote: > > > On 2022-01-31 10:45, Aki Tuomi wrote: > > > Commercial Dovecot has had the ability to store mails & indexes in > > Object Storage for years now, we are not "working on it" anymore. > > so no one is using dovecot-pro ? (dead sources) Ha ha.

Re: silly quesiton [ot]

2022-01-31 Thread Benny Pedersen
On 2022-01-31 10:45, Aki Tuomi wrote: Commercial Dovecot has had the ability to store mails & indexes in Object Storage for years now, we are not "working on it" anymore. so no one is using dovecot-pro ? (dead sources)

RE: silly quesiton [ot]

2022-01-31 Thread Marc
> > Removing or deleting a single message from near the beginning of a > > large flat file takes an inordinate amount of time because the > > remainder of the flat file has to be rewritten all the way from the > > point of the deleted message to the end of the file and then > > truncated. > >

Re: silly quesiton [ot]

2022-01-31 Thread Benny Pedersen
On 2022-01-31 07:23, Sam Kuper wrote: DJB developed Maildir to gain performance and reliability improvements over mbox files. Unlike Maildirs, mbox files *are* "large flat files". mbox is multiple emails in single file, maildir is single email in single file

Re: silly quesiton [ot]

2022-01-31 Thread Benny Pedersen
On 2022-01-31 05:49, justina colmena ~biz wrote: Just ideas. Removing or deleting a single message from near the beginning of a large flat file takes an inordinate amount of time because the remainder of the flat file has to be rewritten all the way from the point of the deleted message to the

RE: silly quesiton [ot]

2022-01-31 Thread Marc
> > I see. People make money outsourcing, consulting, and hooking up companies > with the best solutions for email, office collaboration, CRM, etc., etc., > which is great, but I didn't quite realize that look like a paid offering > on the table and this isn't the right list to discuss potential

RE: silly quesiton [ot]

2022-01-31 Thread justina colmena ~biz
I see. People make money outsourcing, consulting, and hooking up companies with the best solutions for email, office collaboration, CRM, etc., etc., which is great, but I didn't quite realize that look like a paid offering on the table and this isn't the right list to discuss potential free

RE: silly quesiton [ot]

2022-01-31 Thread Aki Tuomi
> On 31/01/2022 10:36 Marc wrote: > > > > > > Just ideas. > > Maybe an idea to participate on a Microsoft forum? They like to use db's for > email, and they are removing everything what is nice in order to push people > into their cloud. So lots to change for the better there. > > It's

RE: silly quesiton [ot]

2022-01-31 Thread Marc
> > Just ideas. Maybe an idea to participate on a Microsoft forum? They like to use db's for email, and they are removing everything what is nice in order to push people into their cloud. So lots to change for the better there. It's so crappy that I recently wrote Bill Gates that he should

Re: silly quesiton [ot]

2022-01-31 Thread Chris Bennett
On Mon, Jan 31, 2022 at 06:23:28AM +, Sam Kuper wrote: > On Sun, Jan 30, 2022 at 07:49:56PM -0900, justina colmena ~biz wrote: > > On January 30, 2022 6:30:44 PM AKST, Sam Kuper wrote: > >> On Sun, Jan 30, 2022 at 06:17:49PM -0900, justina colmena ~biz wrote: > >>> On January 30, 2022 5:46:53

Re: silly quesiton [ot]

2022-01-30 Thread Sam Kuper
On Sun, Jan 30, 2022 at 07:49:56PM -0900, justina colmena ~biz wrote: > On January 30, 2022 6:30:44 PM AKST, Sam Kuper wrote: >> On Sun, Jan 30, 2022 at 06:17:49PM -0900, justina colmena ~biz wrote: >>> On January 30, 2022 5:46:53 PM AKST, dove...@ptld.com wrote: Storing mail in a db... at

Re: silly quesiton [ot]

2022-01-30 Thread justina colmena ~biz
Just ideas. Removing or deleting a single message from near the beginning of a large flat file takes an inordinate amount of time because the remainder of the flat file has to be rewritten all the way from the point of the deleted message to the end of the file and then truncated. On January

Re: silly quesiton [ot]

2022-01-30 Thread Chris Bennett
On Sun, Jan 30, 2022 at 09:46:53PM -0500, dove...@ptld.com wrote: > Storing mail in a db... at the end of the day isn't it still just a file (.db > file) on the drive? > Aren't you just adding bloat and complexity vs just storing the mail directly > (maildir format) to a file on the drive? > >

Re: silly quesiton [ot]

2022-01-30 Thread Sam Kuper
On Sun, Jan 30, 2022 at 06:17:49PM -0900, justina colmena ~biz wrote: > On January 30, 2022 5:46:53 PM AKST, dove...@ptld.com wrote: >> Storing mail in a db... at the end of the day isn't it still just a >> file (.db file) on the drive? >> >> Aren't you just adding bloat and complexity vs just

Re: silly quesiton [ot]

2022-01-30 Thread justina colmena ~biz
You'll get better indexing and fast full text search by storing your emails in a database rather than a flat file, hopefully after decoding any attachments. Especially for spam scoring, analysis, and classification. Much better performance deleting or moving specific messages, too. On January

Re: silly quesiton [ot]

2022-01-30 Thread dovecot
Storing mail in a db... at the end of the day isn't it still just a file (.db file) on the drive? Aren't you just adding bloat and complexity vs just storing the mail directly (maildir format) to a file on the drive? What do you think you are saving? Security? If someone can read files on your

Re: silly quesiton [ot]

2022-01-30 Thread Benny Pedersen
On 2022-01-31 02:30, Sean Kamath wrote: On Jan 30, 2022, at 10:55, Chris Bennett wrote: On Tue, Jan 25, 2022 at 03:50:12AM -0900, justina colmena ~biz wrote: Maybe a future programming project idea: I want a system that will store all mail messages and user account info in, say, a postgresql

Re: silly quesiton [ot]

2022-01-30 Thread Sean Kamath
> On Jan 30, 2022, at 10:55, Chris Bennett > wrote: > > On Tue, Jan 25, 2022 at 03:50:12AM -0900, justina colmena ~biz wrote: >> Maybe a future programming project idea: I want a system that will store all >> mail messages and user account info in, say, a postgresql transactional >> database,