Celestial Bodies Database - Data Collecting

Maybe I’m being dense but I’ve been working on this for a couple of days and 100% of my time is being taken up with cosmological research!

Whilst this is interesting in itself, it’s hardly a valuable use of my very limited available time as a budding developer.

Am I missing something? Is there some obvious dataset which I’m supposed to use for this project? I’m currently wrestling with all kinds of units of measurement which I’ve never even heard of (or have very little understanding of).

I’ve just about figured out parsec minutes, apparent magnitudes, solar masses et al, for various galaxies, but then I haven’t even started on stars, planets, moons…

Feels like it could take another several days of data-collecting before I’m even ready to start building a database.

Which use case are you trying to satisfy? In theory you can make up all sorts of things unrelated to real life facts?

That is certainly true but - with my limited knowledge of cosmology - I was struggling even to think of useful data columns which could fulfil the data types specified in the user stories. Maybe it’s just lack of imagination on my part!

Anyhow, I’ve now put this together for my galaxies, though I can’t attest to its accuracy:

Just need to build it all in psql now… Could you advise how I might name a column which is for ‘diameter in thousands of light years’? Is diameter_1000s_ly appropriate?

I wouldn’t bother putting my units in the name of the column. (That would be something you would have written in a design document somewhere or a readme file)

1 Like