{"id":6072,"date":"2012-10-30T01:00:36","date_gmt":"2012-10-30T11:00:36","guid":{"rendered":"http:\/\/darkerview.com\/wordpress\/?p=6072"},"modified":"2012-10-28T20:11:56","modified_gmt":"2012-10-29T06:11:56","slug":"database-work","status":"publish","type":"post","link":"https:\/\/darkerview.com\/wordpress\/?p=6072","title":{"rendered":"Database Work"},"content":{"rendered":"<p>I have spent quite a few hours lately revamping my <a href=\"http:\/\/www.darkerview.com\/scripts\/aboutObsDB.php\">observation database<\/a>.  The whole thing had been quite neglected as of late, never being properly updated since I changed over to WordPress on the main blog.  The appearance had been left in a halfway state that didn&#8217;t match anything, never mind some serious bugs.<\/p>\n<p><figure id=\"attachment_6073\" aria-describedby=\"caption-attachment-6073\" style=\"width: 300px\" class=\"wp-caption alignright\"><a href=\"https:\/\/darkerview.com\/wordpress\/?attachment_id=6073\" rel=\"attachment wp-att-6073\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/darkerview.com\/wordpress\/wp-content\/uploads\/2012\/10\/HCG88dss10P2UKr.gif\" alt=\"HCG88\" title=\"HCG88\" width=\"300\" height=\"300\" class=\"size-full wp-image-6073\" srcset=\"https:\/\/darkerview.com\/wordpress\/wp-content\/uploads\/2012\/10\/HCG88dss10P2UKr.gif 300w, https:\/\/darkerview.com\/wordpress\/wp-content\/uploads\/2012\/10\/HCG88dss10P2UKr-150x150.gif 150w\" sizes=\"(max-width: 300px) 85vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-6073\" class=\"wp-caption-text\">Overlayed <a href=\"http:\/\/stdatu.stsci.edu\/dss\/\" target=\"_blank\">DSS image<\/a> of <a href=\"http:\/\/www.darkerview.com\/scripts\/query.php?HCG88\">HCG88<\/a>.  These overlays are generated on-the-fly using the object data.<\/figcaption><\/figure>In addition to adding all of my <a href=\"https:\/\/darkerview.com\/wordpress\/?p=5979\">recent observations<\/a> at the telescope, I have redone the style sheets.  You can now select white-on-black, black-on-white, or night vision red, just look for the pull-down menu on the object page.<\/p>\n<p>The printable version is still there, a clean black-on-white layout including inverted DSS images for printing.  I took a cue from that printed version and kept the other new layouts very clean and uncluttered in appearance.<\/p>\n<p>There is a nearby object section that picks up any close by objects for quick reference.  Some attention has been paid to the search routines for better usability.<\/p>\n<p>Those are just the visible changes, much of the work has gone into the back end to improve the quality of the underlying data.  The whole thing uses Python and Tk on my local machine, this gets converted to SQL and PHP for the webserver.  Most of the tools are automated at this point, and getting less buggy as I hunt down the little issues that I find with use.<\/p>\n<p>I put the whole thing together for my own use, a place to organize my observing notes.  But as it is online, anyone can use it.  Let me know if you ever find it useful.  <\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have spent quite a few hours lately revamping my observation database. The whole thing had been quite neglected as of late, never being properly updated since I changed over to WordPress on the main blog. The appearance had been left in a halfway state that didn&#8217;t match anything, never mind some serious bugs. In &hellip; <a href=\"https:\/\/darkerview.com\/wordpress\/?p=6072\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Database Work&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[22,331],"tags":[82,683,357,60,684,83],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/darkerview.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/6072"}],"collection":[{"href":"https:\/\/darkerview.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/darkerview.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/darkerview.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/darkerview.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6072"}],"version-history":[{"count":0,"href":"https:\/\/darkerview.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/6072\/revisions"}],"wp:attachment":[{"href":"https:\/\/darkerview.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6072"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/darkerview.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6072"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/darkerview.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}