Thanks for the great info Will. To summarize, the size of the MySQL database will remain pretty small. The images are resized and stored on the filesystem, so its really about making sure you have disk space available which is not typically an issue with most hosting plans these days.
-justin