what jan posted is basically just a convoluted replacement for median(SESSION.lastChange - SESSION.creationTime) , since it is not a built-in function in postgres
makes me think, i have to double-check if lastChance stops updating after the trade is finshed and chatting continues

Does it copy the key to clipboard unencrypted or encrypted? 

When individual private keys are exported they are in plain text using the SIPA format (The UI warns you about copying it to clipboard)
When making a PDF backup all keys are exported in one go and encrypted with a password you write down from the display.

Sounds very good! Looking forward to the new versions

I just completed a buy on local trader - totally great and serves a very valuable purpose.

Some comments on user experience:

• It's not clear what the different alerts mean - there are two types of alert. 1) The dot on the localtrader button inside the app seems to come and go at random and has different colours and I wasn't sure what it indicated - presumably new activity but it didn't seem to correlate with new activity. It would turn up when there was no activity and it would not go away when I expected it should. 2) The status-bar notification at the top of the OS can only be cleared from the status bar, not from doing some action in the mycelium app. It wasn't clear what that icon was indicating, although I assume it was 'new activity' even though it didn't seem to correlate very well with that. In general I felt that the alerts for 'new activity' were not timely, had unclear meanings, and were consistent with my expectations.
• The 'final' screen after opening a new buy shows a chat window and accept/abort buttons. I felt that it was not clear what I should be doing next on this screen. I think the accept/abort buttons should be below the chat, since logically the user will chat first and only later press the buttons. Moving the buttons allows the user to clearly interact from the top first, then end interaction at the bottom. Chat first, then use the accept button. I initially wondered when to press the accept button and what I would be accepting (was I accepting the rate or was I accepting that the trade was complete or what?) Putting the buttons below the chat makes it clear to chat first, then once the chat is resolved (ie you are meeting with each other) the users should use the accept button.
• Response time to actions such as chat and accept was not very fast, in the order of tens of seconds. The UI just seemed a lot slower to respond than I would have expected from a normal internet-connected app

Overall the experience was fantastic and I would gladly recommend anyone to use local trader. With a bit of polish it will be more clear which actions the user should be performing (and in which order) to complete the process.

That's the next thing after LocalTrader.

Yes. I'll make a link with XML data available.

I know Mycelium Bitcoin Wallet is not new and not fool-proof but it workout nice as an easy way to check out the probability of valid transactions for all my purchases.

I read jgarzik's points here: http://blog.bitpay.com/2014/05/02/bitpay-bitcoin-and-where-to-put-that-decimal-point.html
... and I tend to agree

Andreas and I are discussing it and the bottom line right now: I am more or less for it, and he is more or less against it 
However it seems to me that none of us have a very hard opinion on it.

The thing is that it is very hard to get a good picture about where the trend is heading. There is a very active bitcoin group in Vienna, we will start a live discussion there tomorrow evening, let's see what they come up with.

I think this is bad idea. I think that general public should get used to mili-, micro-, nano- prefixes and adapt to Bitcoin and its basic rules, not the other way around (Bitcoin rules adapting to general public or to psychological discomfort of "owning a fraction of something"). There are far too many "convenient" alternatives. Maybe when 1 µBTC = 1 USD, but it would still be quite confusing with cent in my opinion.
Edit: After reading jgarziks's post, I see the point. Well, I still think that "existing financial software and many popular accounting and finance packages" should adapt to Bitcoin not the other way around. But I admit, this view of mine is probably not very realistic one.

Unrelated... I have realized my first trade through LocalTrader today and it was great experience. We met and talked about Bitcoin for about 15 minutes and even tried opposite transaction for small amount of mBTC. However, I am little bit puzzled about notification behavior of Mycelium. For me, I got update (sound and vibration) only when I launched application. My counterpart (seller) on the other way got notification in action bar as some icon. I might take quite a while to notice buy request or update, therefore increase in "expected trade time". But overall, I liked functionality very much.