I had tried this at some point using my n800. Gphoto2 was never stable enough (at that time at least) to use more than a few times and than it would reboot the tablet.

On the other hand I used succesfully the s10sh:
http://talk.maemo.org/showthread.php?t=18143

This would be a nice starting point for the n900 I think...