Moon
24-05-2010, 10:34 PM
Hello everyone.
I recently created a MySQL database to store information about all my images. I have listed the fields I created below. Do you think I missed anything? I would be interested to know what information you record for each image you take, and how you do it. I guess I could record some info about the weather or the seeing?
Object Name
Filename
Thumbnail File Name
Type (galaxy/cluster/nebula etc)
Messier object number (optional)
NGC object number (optional)
Camera
Scope
Mount
Guiding
Exposure
Location
Date(s)
Notes
Corrector / field flattener used
Anyhow, once I created this database and populated it, I wrote some simple php scripts to automate my website and make it easier to maintain. I'm sure there are still a few little glitches to work out but it mostly done.
Here is a link to the updated page:
http://deepspaceplace.com/images.php
James
I recently created a MySQL database to store information about all my images. I have listed the fields I created below. Do you think I missed anything? I would be interested to know what information you record for each image you take, and how you do it. I guess I could record some info about the weather or the seeing?
Object Name
Filename
Thumbnail File Name
Type (galaxy/cluster/nebula etc)
Messier object number (optional)
NGC object number (optional)
Camera
Scope
Mount
Guiding
Exposure
Location
Date(s)
Notes
Corrector / field flattener used
Anyhow, once I created this database and populated it, I wrote some simple php scripts to automate my website and make it easier to maintain. I'm sure there are still a few little glitches to work out but it mostly done.
Here is a link to the updated page:
http://deepspaceplace.com/images.php
James