So I had been using Piwigo for a while but when I tried to upgrade PHP it blew up the instance. So I started looking around for something else that would support PHP 8+ and drifted into the docker\/podman world, and the first container I got working in production happened to be Lychee which is a neat little photo management software but, there is some major lack on Lychee, no user management, no size selection when viewing, no method of putting in a photo description. Then Piwigo version 14 drops and it fixes a lot of the issues that Lychee has and adds some pretty cool functionality so now I’m trying to migrate back to Piwigo, here is the script I’m using to pull out the info for transfer.<\/p>\n\n\n
\n--SELECT * FROM photos WHERE album_id = 'qVnjGzkaw25SvFRPek3TpULO'\n\nSELECT \n'move ".\\' || replace(sv.short_path, '\/', '\\') || '" ".\\breakout\\' || replace(a.title, '\/', '-') || '\\' || p.title || '.jpg"' as oFileName\nFROM size_variants sv\nJOIN photos p on (sv.photo_id = p.id)\nJOIN base_albums a on (p.album_id = a.id)\nWHERE sv.short_path like 'original%'\nAND p.album_id != 'qVnjGzkaw25SvFRPek3TpULO'\n\nSELECT 'mkdir "' || replace(a.title, '\/', '-') || '"' FROM base_albums\n\nSELECT * \nFROM size_variants sv\nJOIN photos p on (sv.photo_id = p.id)\nJOIN base_albums a on (p.album_id = a.id)\nWHERE sv.short_path like 'original%'\n\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"So I had been using Piwigo for a while but when I tried to upgrade PHP it blew up the instance. So I started looking around for something else that would support PHP 8+ and drifted into the docker\/podman world, and the first container I got working in production happened to be Lychee which is […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","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,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[28],"tags":[],"class_list":["post-1111","post","type-post","status-publish","format-standard","hentry","category-open-source","author-aron"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4bBkH-hV","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/1111","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1111"}],"version-history":[{"count":1,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/1111\/revisions"}],"predecessor-version":[{"id":1112,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/1111\/revisions\/1112"}],"wp:attachment":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}