Re: Proposed SMS design schema

> msg_id: unique message id (hexstring sha encoded (ESN+folder+datetime))

One thing to consider is what if I have two phones(*) and read from
one and then write to another.  Is it the same message or a different
one?

When placing the message into an IMAP folder, I would want to replace
the numbers with email addresses (eg a from of 1234567890 becomes a
from of [email protected])

Messages should be immutable.  I'd be inclined to sha only the timestamp
and the message content itself.  Even that gets a little tricky as some
times the same message is in muliple messages.  Eg if someone sends
you a message from a BlackBerry, the BB will split it into multiple
messages 160 characters long.  I don't know if it is apparent to
anyone except a human that it is all one long message.

Has anyone found a reliable automated way to work out what carrier
a number is on?  As a fallback we can use @teleflip.com 

Roger


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click