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@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.)
Reply to: