Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I spent ages messing with this same sort of thing a while back. First of all PNG and JPG formates i found to be quite awkward in guessing the results. JPG photos generally wont convert well to PNG, but vector jpg images will, vector png generally dont convert well to JPG, but photos will. You will find it very hard to ensure that the images get just under 1mb especially if you are not resizing them as well. If you do not resize them you will also hit more troubles - the quality will become less and less the larger the image is (kind of ironic).</p> <p>You need a few versions of each image. Let me explain.</p> <ol> <li><p>You want to keep the original, so you can refresh the images based on the original at any time in the future to lets say, increase the quality of the images later on or even get some new dimentions.</p></li> <li><p>Using the original image with lightbox would generally be a bad idea. You would be better to resize it to fit inside say 1024 x 1024. That would more than satisfy most, and would usually give a reasonable file size. You could then offer the original to be downloaded if you wish. Using the largest file possible would usually result from unhappy visitors when the image takes ages to load and could even cost them a lot after some time through bandwidth usage (and you for the same reason).</p></li> </ol> <p>The only way i can think of to do what you are asking is to create some horrible code performance wise that loops through, gradually decreasing the quality and checking the resulting image size. Once it finds the image size that is below 1mb it comes out the loop and uses that quality setting. I would really advise against this though.</p> <p>P.S. Outside the scope of this answer i have mentioned in the comments the methodology of a solution i used.</p>
    singulars
    1. This table or related slice is empty.
    1. POPHP Reducing Image Quality until filesize is upto say 1mb
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USVBAssassin
    1. USVBAssassin
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POPHP Reducing Image Quality until filesize is upto say 1mb
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks VBAssassin, I will go for it.
      singulars
      1. PO
      1. USKalpesh Patel
    2. COgood answer, definitely store the original and scale for each use case. this is how wordpress deals with image uploads IIRC
      singulars
      1. PO
      1. UStotallyNotLizards
    3. COJust so you know, i settled with creating a php daemon process to process image resizes from a queue (daemon process can process 1 image at a time preventing a huge spike in memory usage from concurrent user requests uploading images). You may also want to check the image can be loaded into memory ok (i wrote a function somewhere, but dunno where i put it, you have to do a bit of maths on the dimentions and colour depth etc) before you manipulate it. If you don't check, it can crash your server from to much memory usage. Also, try using a file based resized image "cache". Works perfectly :)
      singulars
      1. PO
      1. USVBAssassin
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload