Pimoroni's adjustable Pi Camera mount is a great accessory for Pi shutterbugs. Little screws attach the Pi Camera solidly and the design allows for multiple positions. There's also a 1/4" hole that you can use to attach the camera to a standard camera tripod mount.
This mount works with the Pi Camera version 1 (5 MegaPixel) and version 2 (8 MegaPixel) both plain & NoIR.
Comes with a two-piece plastic bracket and 5 mini screws + 7 hexnuts. Pi Camera is not included. Tripod not included. 1/4"-20 hexnut is not included (check your local hardware store!)