@nickname and change nicknames

a status/notice/post/tweet is stored as a 140-char plain text document without any HREF links in it

so, the link has to be calculated at notice-render-time, thus, it's impossible to store the "deep link"

maybe I will add a field to the posts table, it could store a nickname->deeplink lookup table for that status/notice/post/tweet

that lookup table could be created when the tweet is posted

the other way to go is store a rendered copy of the original tweet, that would be a lot more simple. I believe Laconica does it like this

Second way sounds good :)

Tested your commits.

It works if username has changed and is not in use by another user.

If another user takes the (now available) name, posts are redirecting to the new name-owner. Is it possible to assign the posting-id to the user-id?

The reason I did it this way so far, is because it will work the same whether you click a copy of the status on a remote server or if you click on the original on its original server.

If I save a rendered version, or create a database of posting-id to user-id (for all mentioned @nicknames in each notice) then it's hard to keep the click-behavior consistent for remote users of the Notice and local users of the Notice

or something like that

OMB 0.2 http://openmicroblogging.org might offer some help with this