{"id":21682,"date":"2025-12-18T14:17:12","date_gmt":"2025-12-18T14:17:12","guid":{"rendered":"https:\/\/johnjohnston.info\/blog\/?p=21682"},"modified":"2025-12-18T14:18:24","modified_gmt":"2025-12-18T14:18:24","slug":"on-this-flickr-day","status":"publish","type":"post","link":"https:\/\/johnjohnston.info\/blog\/on-this-flickr-day\/","title":{"rendered":"On This Flickr Day"},"content":{"rendered":"\n<p><a href=\"https:\/\/pi.johnj.info\/onthisflickrday\/\">On This Flickr Day<\/a> There is a bit more work on making this look nice, but it is a start.<\/p>\n\n\n\n<p>I&#8217;ve been thinking about this for a while. A way to show Flickr photos taken &#8220;on this day&#8221;.<\/p>\n\n\n\n<p>I&#8217;ve used the Flickr API occasionally over the years, but calling it directly would take too much time. You would need to page through all the photos 500 at a time until you had all the photos.<\/p>\n\n\n\n<p>So I thought I might build a personal database with the information I needed. This could be updated weekly. I then could pull the information from that in one go. Especially if I store the days and months individually for each photo.<\/p>\n\n\n\n<p>This is somewhat outside my skill set. I&#8217;ve used the Flickr Api but do not really know much about databases. In the dim past I think I&#8217;ve created them once or twice and used from PHP but with lots of searching.<\/p>\n\n\n\n<p>I planned:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create a local sqlite database on my mac<\/li>\n\n\n\n<li>Move it to a server<\/li>\n\n\n\n<li>access it from a web page with JavaScript via a PHP file to read the database.<\/li>\n<\/ul>\n\n\n\n<p>I&#8217;ve got some way toward that. I did need a bit of help from claude.ai to get the bash sorted. I&#8217;ve just used simple PHP on the webpage so far and managed that with the odd search when I&#8217;ve hit an error.<\/p>\n\n\n\n<p>I&#8217;ve been thinking a bit about using AI for this sort of thing. My current approach is to use it for specific questions. For example, asking is this a sensible approach, or asking for hep with a line. Rather than write me a whole script to do x, y or z. So I start a script then ask for help when stuck. In the same way I&#8217;d have to look up docs or search for the answer to a problem.<\/p>\n\n\n\n<p>Hopefully my next step will be to, after a short interval, go through any files and comment as to what is going on to reinforce my learning.<\/p>\n\n\n\n<p>As I am a complete amateur and do not have anyone to chat about this with, I find using AI quite good fun if I make sure to tell it not to give me whole solutions.<\/p>\n\n\n\n<p>The other thing I&#8217;ve been trying with AI is to run any files through asking for them to give any security recommendations.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Next Steps<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create a way to produce JSON rather than a web page with PHP. I could then bring the thumbnails into this site using JavaScript.<\/li>\n\n\n\n<li>Add some sort of lightbox to see the images larger, change the layout &amp; appearance.<\/li>\n\n\n\n<li>Figure out a simple way to update the database without completely rebuilding it.<\/li>\n\n\n\n<li>Decide on any extra fields and recreate the database. <\/li>\n\n\n\n<li>Figure out why I can&#8217;t get location information from the database with PHP I can with bash.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>On This Flickr Day is a webpage that show the flickr photos I&#8217;ve taken on a particular day over the years.<\/p>\n","protected":false},"author":1,"featured_media":21683,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"mf2_syndication":["https:\/\/social.ds106.us\/@johnjohnston\/115740995895008146","https:\/\/bsky.app\/profile\/johnjohnston.info\/post\/3mabejerw2f2w"],"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"webmentions_disabled_pings":false,"webmentions_disabled":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[953],"tags":[957,443,88,38],"post_format":[],"class_list":{"0":"post-21682","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-posse","8":"tag-ai","9":"tag-bash","10":"tag-flickr","11":"tag-javascript","12":"kind-article","14":"h-entry","15":"hentry"},"better_featured_image":{"id":21683,"alt_text":"Screenshot of On This Flickr Day webpage","caption":"","description":"","media_type":"image","media_details":{"width":1200,"height":830,"file":"2025\/12\/screenshot-of-on-this-flick-day.jpg","filesize":291239,"sizes":{"medium":{"file":"screenshot-of-on-this-flick-day-620x429.jpg","width":620,"height":429,"mime-type":"image\/jpeg","filesize":63980,"source_url":"https:\/\/johnjohnston.info\/blog\/wp-content\/uploads\/2025\/12\/screenshot-of-on-this-flick-day-620x429.jpg"},"large":{"file":"screenshot-of-on-this-flick-day-1024x708.jpg","width":1024,"height":708,"mime-type":"image\/jpeg","filesize":139898,"source_url":"https:\/\/johnjohnston.info\/blog\/wp-content\/uploads\/2025\/12\/screenshot-of-on-this-flick-day-1024x708.jpg"},"thumbnail":{"file":"screenshot-of-on-this-flick-day-150x150.jpg","width":150,"height":150,"mime-type":"image\/jpeg","filesize":8257,"source_url":"https:\/\/johnjohnston.info\/blog\/wp-content\/uploads\/2025\/12\/screenshot-of-on-this-flick-day-150x150.jpg"},"medium_large":{"file":"screenshot-of-on-this-flick-day-768x531.jpg","width":768,"height":531,"mime-type":"image\/jpeg","filesize":90842,"source_url":"https:\/\/johnjohnston.info\/blog\/wp-content\/uploads\/2025\/12\/screenshot-of-on-this-flick-day-768x531.jpg"},"post-thumbnail":{"file":"screenshot-of-on-this-flick-day-668x462.jpg","width":668,"height":462,"mime-type":"image\/jpeg","filesize":70995,"source_url":"https:\/\/johnjohnston.info\/blog\/wp-content\/uploads\/2025\/12\/screenshot-of-on-this-flick-day-668x462.jpg"},"sempress-image-post":{"file":"screenshot-of-on-this-flick-day-668x462.jpg","width":668,"height":462,"mime-type":"image\/jpeg","filesize":70995,"source_url":"https:\/\/johnjohnston.info\/blog\/wp-content\/uploads\/2025\/12\/screenshot-of-on-this-flick-day-668x462.jpg"},"jetpack-portfolio-admin-thumb":{"file":"screenshot-of-on-this-flick-day-50x50.jpg","width":50,"height":50,"mime-type":"image\/jpeg","filesize":1897,"source_url":"https:\/\/johnjohnston.info\/blog\/wp-content\/uploads\/2025\/12\/screenshot-of-on-this-flick-day-50x50.jpg"}},"image_meta":{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0","keywords":[]}},"post":21682,"source_url":"https:\/\/johnjohnston.info\/blog\/wp-content\/uploads\/2025\/12\/screenshot-of-on-this-flick-day.jpg"},"jetpack_featured_media_url":"https:\/\/johnjohnston.info\/blog\/wp-content\/uploads\/2025\/12\/screenshot-of-on-this-flick-day.jpg","jetpack_shortlink":"https:\/\/wp.me\/p57zFQ-5DI","jetpack_likes_enabled":false,"jetpack_sharing_enabled":true,"kind":false,"_links":{"self":[{"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/posts\/21682","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/comments?post=21682"}],"version-history":[{"count":2,"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/posts\/21682\/revisions"}],"predecessor-version":[{"id":21685,"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/posts\/21682\/revisions\/21685"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/media\/21683"}],"wp:attachment":[{"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/media?parent=21682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/categories?post=21682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/tags?post=21682"},{"taxonomy":"post_format","embeddable":true,"href":"https:\/\/johnjohnston.info\/blog\/wp-json\/wp\/v2\/post_format?post=21682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}