Web lists-archives.com

Re: Invalid UTF-8 byte? (was: Re: utf)




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:
> > rhkramer@xxxxxxxxx (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.)