On Wednesday, April 04, 2018 08:26:41 AM Greg Wooledge wrote: > On Wed, Apr 04, 2018 at 01:23:25PM +0200, Nicolas George wrote: > > rhkra...@gmail.com (2018-04-03): > > > and the data is stored in mbox formatted files. > > > > DO NOT DO THAT. > > > > This is the only good advice you can have for that project. Store your > > data in a decent format. > > Perhaps an sqlite database. At least, that is my first thought. > You might come up with a better solution depending on your specific > needs. That solution won't be "an mbox folder".
Past experience with "databases" (before I switched to LInux)--things like dBase (III, III+, IV), Microsoft Access, and others that I can't recall atm made the fixed (and even variable) length fields. The key thing for me was making something that worked reasonably like askSam, which is / was free format, fully searchable, and other things I can't recall atm. I don't know enough about sqlite to know what capabilities it has for variable length fields (if any--how many are possible per record, is the content fully searchable, etc.) But, it really doesn't matter, I am not interested in changing the data format. (Besides, with the current design, almost any email client is a client for my mashup.)
