Hi folks,

I had a discussion with TAsn on #openmoko-cdevel about telephone number 
normalization in opimd. The discussion was triggered by my inspection of the 
sqlite database, where I saw that it's impossible to index on a telephone 
number.

TAsn argued that queying for a number is difficult, and that always storing the 
number in normalized form is not possible. For example, an Israeli could enter 
& use a local French phone number while on holiday in France. TAsn argued that 
it should be stored as a local number, because otherwise  it would be stored 
as a number with the Israel country prefix from the SIM.

I think a simple solution would be to ask the user the correct country (for 
example the choice "the country you're in now" and "your own country") before 
storing the contact. That would allow OPIM to always have the correct country 
prefix.

Some people may think this is a pain, to have to answer such a question every 
time a number is added. However, ask yourself how often do you add a new 
number, and how often do you have to query for one?

I have near 200 contacts in my database, and text messages of up to 15 
different people in my message box. It takes a long time to fetch all the names 
for those numbers, and I have to wait for it every time I open the messages 
window. As new SMS messages are not shown in the window as soon as they arrive 
(running shr-testing) I have to close and re-open the window every time I 
receive a message. My guess is that per month the total number of queries is 
at least 100x more than the number of times I add a new contact.

Wondering what your opinions on this are,
-- 
Sybren A. Stüvel
[email protected]
http://stuvel.eu/

Attachment: signature.asc
Description: This is a digitally signed message part.

_______________________________________________
Shr-devel mailing list
[email protected]
http://lists.shr-project.org/mailman/listinfo/shr-devel

Reply via email to