I love fresh pineapple but often use tinned in cooking.
Also, many places where you buy fruit, have awful pineapples, so unless I do my shopping at a "good" and expensive shop which I go to every few weeks - their pineapples are mostly sweet and last for weeks however I would rarely buy one from a supermarket or a cheap fruit shop, of which there are many. They also often have a lot of brown marks which my expensive shop does not!