For your mixed drinks you can use canned pineapple juice and have excellent results. I recommend Dole pineapple juice as it is 100% juice, widely available, and not from concentrate. The 6 packs of 6 oz cans are very handy if you don't need all that much at a time (which is most of the time for me). You won't have to try to keep opened cans fresh (just pound what remains). Dole does make a 46 oz can that is great if you need a lot of pineapple juice.
Trader Joes's has a pineapple juice in larger cans. I tried it hoping it would be even better or fresher than Dole but I was disappointed. It was pretty thin. Also beware of some brands (especially Hispanic brands) that add sugar or other ingredients. Stay away from these - you want 100% pure pineapple juice for the drink recipes on this site.
You can try to juice a fresh pineapple if you wish but it is quite a mess. The juice is great but for me not worth the effort.
Pineapple juice is used in a huge variety of drink recipes most of which are Tiki, tropical, or Caribbean style drinks. You will also find pineapple juice in some classic cocktails such as the Algonquin.
But the most common combination you will see is rum and pineapple juice - they just seem to have an affinity for each other (and it helps that they are both plentiful in a lot of the same places in the world). Pineapple juice also has a curious affinity for chocolate - more specifically creme de cacao. Some Tiki drinks have a small amount of creme de cacao along with the base spirits and pineapple juice.
As with all juices you want to shake pineapple juice drinks (or mix with a stand mixer). Unlike other juices pineapple juice will develop a frothy head when shaken. This is quite desirable and leads to an attractive drink.
Do you enjoy your pineapple juice with base spirits other than rum? Let's hear about it...