<html><body><div style="font-family:Calibri, Arial, Helvetica, sans-serif; font-size:12.0pt; line-height:1.3; color:#1F497D"><!-- ##### NINE BODY BEGIN ##### --><div>Personaly I would just store thumbnail in the database but having extra options is always nice. <br></div><div><br></div><div id="signature-x" style="-webkit-user-select:none; font-family:Calibri, Arial, Helvetica, sans-serif; font-size:12.0pt; color:#1F497D" class = "signature_editor"><br></div><!-- ##### NINE BODY END ##### --></div><div class="quoted_output_body"><div id="quoted_header" class="quoted_header_editor" style="clear:both;"><hr style="border:none; height:1px; color:#E1E1E1; background-color:#E1E1E1;"/><div style="border:none; padding:3.0pt 0cm 0cm 0cm"><span style="font-size:11.0pt;font-family:Calibri, Arial, Helvetica, sans-serif"><b>From:</b> Tac Tacelosky<br><b>Sent:</b> Wednesday, 10 April 2019 11:24 pm<br><b>To:</b> digiKam - Home Manage your photographs as a professional with the power of open source<br><b>Subject:</b> Re: [digiKam-users] Web based interface (in PHP etc)<br></span></div></div><br type='attribution'><div id="quoted_body" class="quoted_body_editor"><div dir="ltr"><div>Although it might seem like bad programming practice to put jpeg/png blob in a database instead of a filesystem, I'd love that option. In particular, it'd allow a cloud-based solution to not require an disk usage, making it cheaper to deploy.</div><div><br /></div><div>That is, pay for a cloud-based database, then use a free or low-cost deployment like heroku, create a dynamic site, and not need access to the original images to create the thumbnails, nor need access to a disk system in the heroku deployment.</div><div><br /></div><div>A second database could be used, or another table in the database with the image blob, but MUCH better would be an option for how you wanted in the images stored. PNG and JPG rendering will come from a library, so perhaps the developer would be open to this, even if it renders images differently than the current method.<br /></div><div><br /></div><div>Of course, the images could also be stored on s3, but that's considerably more complicated, since the images are de-coupled from the database. <br /></div><div><br /></div><div><br /></div></div><br /><div class="elided-text"><div dir="ltr">On Wed, Apr 10, 2019 at 4:41 AM Daniel Fenn <<a href="mailto:danielx386@gmail.com">danielx386@gmail.com</a>> wrote:<br /></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb( 204 , 204 , 204 );padding-left:1ex"><div><div style="font-family:'calibri' , 'arial' , 'helvetica' , sans-serif;font-size:12pt;line-height:1.3;color:rgb( 31 , 73 , 125 )"><div>I wonder if it would be possible to get that changed, not just for this Web project but to make everything accessible for future generations to come. <br /></div><div><br /></div><div style="font-family:'calibri' , 'arial' , 'helvetica' , sans-serif;font-size:12pt;color:rgb( 31 , 73 , 125 )"><br /></div></div><div><div><hr style="border:medium none;height:1px;color:rgb( 225 , 225 , 225 );background-color:rgb( 225 , 225 , 225 )" /><div style="border:medium none;padding:3pt 0cm 0cm"><span style="font-size:11pt;font-family:'calibri' , 'arial' , 'helvetica' , sans-serif"><b>From:</b> Tac Tacelosky<br /><b>Sent:</b> Tuesday, 9 April 2019 9:37 pm<br /><b>To:</b> digiKam - Home Manage your photographs as a professional with the power of open source<br /><b>Subject:</b> Re: [digiKam-users] Web based interface (in PHP etc)<br /></span></div></div><br type="attribution" /><div><div dir="ltr"><div>The thumbnails are stored in format that hardly anyone uses (blanking on the name of it now). In particular, there are no PHP libraries for reading it, even integrating GD, the popular and powerful image manipulation library.</div><div><br /></div><div>I wish there were an option for selecting the thumbnail format, which included jpg and png (and the associated quality and size options). Even if the database were bigger, it would allow much easier access to the thumbnails, without all the complications of re-creating thumbnails from somewhere else.</div><div><br /></div><div>Tac<br /></div></div><br /><div><div dir="ltr">On Mon, Apr 8, 2019 at 4:12 PM Daniel Fenn <<a href="mailto:danielx386@gmail.com">danielx386@gmail.com</a>> wrote:<br /></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb( 204 , 204 , 204 );padding-left:1ex"><div><div style="font-family:'calibri' , 'arial' , 'helvetica' , sans-serif;font-size:12pt;line-height:1.3;color:rgb( 31 , 73 , 125 )"><div>To answer a question about if thumbnails can be extracted from a database, it depends on the format. Is it an jpg file or something like that? <br /></div><div><br /></div><div style="font-family:'calibri' , 'arial' , 'helvetica' , sans-serif;font-size:12pt;color:rgb( 31 , 73 , 125 )"><br /></div></div><div><div><hr style="border:medium none;height:1px;color:rgb( 225 , 225 , 225 );background-color:rgb( 225 , 225 , 225 )" /><div style="border:medium none;padding:3pt 0cm 0cm"><span style="font-size:11pt;font-family:'calibri' , 'arial' , 'helvetica' , sans-serif"><b>From:</b> <a href="mailto:jdd@dodin.org">jdd@dodin.org</a><br /><b>Sent:</b> Tuesday, 9 April 2019 5:38 am<br /><b>To:</b> <a href="mailto:digikam-users@kde.org">digikam-users@kde.org</a><br /><b>Subject:</b> Re: [digiKam-users] Web based interface (in PHP etc)<br /></span></div></div><br type="attribution" /><div><p dir="ltr">Le 08/04/2019 à 21:07, woenx a écrit :
<br />
> Are we talking about the same piwigo?
<br />
<br />
I don't know what you expect. I use Piwigo for a lot of time now, with
<br />
success
<br />
<br />
<a href="http://dodin.org/piwigo/index.php">http://dodin.org/piwigo/index.php</a>
<br />
<br />
> serious rough edges that prevented normal usage, such as displaying any
<br />
> directory that had special characters such as aphostrophes
<br />
> (<a href="https://piwigo.org/bugs/view.php?id=3030">https://piwigo.org/bugs/view.php?id=3030</a>).
<br />
<br />
like any software it have syntax guidelines. I can use "?" in file names
<br />
(linux), when Windows wont like them... nor piwigo. use "detox" and voilà
<br />
<br />
<a href="http://www.dodin.org/wiki/pmwiki.php?n=Photo.GestionDesImages#toc8">http://www.dodin.org/wiki/pmwiki.php?n=Photo.GestionDesImages#toc8</a>
<br />
<br />
>
<br />
> Apart from that, I personally prefer to write the metadata in the same
<br />
> picture file instead of sidecar files
<br />
<br />
the problem is syncing metadata to/from web/local. It's not possible to
<br />
send or receive full image files only to sync metadata, when moving xml
<br />
files is easy and cheap. This do not prevent writing also to the images,
<br />
as I always do
<br />
<br />
jdd
<br />
<br />
<br />
--
<br />
<a href="http://dodin.org">http://dodin.org</a>
<br />
</p>
</div></div></div></blockquote></div>
</div></div></div></blockquote></div>
</div></div></div></body></html>