You should be able to see the edit link as you can see here, http://take.ms/Cvj93

Hi Mark.
If I just post an update on the page, then I do indeed see the edit option. However, if I share a link, or a photo etc, then the edit option is removed (see attached image)
Dave

Ah... OK! At least I know it's not me going bonkers then
Are there plans to allow this in the future? Only from the point of view of correctly spelling mistakes etc?
Dave

Editing a rich media post is extremely complicated because it's not just about throwing a texteditor there. For instance, when you post a photo on the stream, we need to rewrite the entire form to upload photos to be able to "edit". In other words, previously uploaded photos needs to be there in the editor and it involves a very tricky process like:

1. What if the photo was deleted?
2. What if the privacy of the photo changed?
3. If you have edited the photo and removed it, shouldn't it also then remove the photo from the album?
4. If the photo is removed, what about the likes / albums
5. a lot of other complications, points / achievements / notifications etc.

I see! Yes, I can see why that would be complicated. I had just assumed ES stored the text for a post in one table and the rich content in another and where joined with SQL which would then allow you to let people edit the text but not the rich content itself. But thinking about it, I guess that would put the system under a lot of stress having to perform SQL queries to load each post and thus slowing down the system as a whole. That's why you guys are master coders, and I'm not
Dave

Yes, that is right. Joining tables like this is going to crash your MySQL server and your hosting company will hate us for it. The concept of a database is to normalize your data so that it'll be easy to relate from one table to another.

However, in complex operations like this, we have to denormalize some of the data to reduce overheads joining huge tables. Here's one good explanation (If you are interested in finding out more about this process), http://venkatdwh.blogspot.my/p/normalized-vs-denormalized.html

This is also one of the reasons why some feature requests may sound or look pretty easy to be implemented but there are a million reasons behind not implementing them.

Thanks for that explanation Mark!

You are most welcome Dave, and thank you for understanding our pain