Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><a href="http://httpd.apache.org/docs/current/mod/mod_expires.html" rel="nofollow noreferrer">Expires</a> module in Apache solves this - it needs to be loaded in server config, and set up in <code>.htaccess</code> (or in server config).</p> <p>With an <a href="http://www.w3.org/Protocols/rfc2616/rfc2616-sec14.html#sec14.21" rel="nofollow noreferrer">Expires</a> header, the resource is only requested the first time. Before the expiration date, subsequent requests are fulfilled from browser cache. After the specified time expires and the resource is needed, only then it is requested again (conditionally - a 304 will be returned for an unchanged resource). The only reliable way to clear it from the cache before it expires is manually, or by forcing a refresh (usually Ctrl-F5). (This could be an issue if the resource changes in the meantime, but statical images don't change very often.)</p> <pre><code># enable the directives - assuming they're not enabled globally ExpiresActive on # send an Expires: header for each of these mimetypes (as defined by server) ExpiresByType image/png "access plus 1 month" ExpiresByType image/gif "access plus 1 month" ExpiresByType image/jpeg "access plus 1 month" # css may change a bit sometimes, so define shorter expiration ExpiresByType text/css "access plus 1 days" </code></pre> <p>For favicon.ico, a bit more work is needed (Apache normally does not recognize Windows icon files, and sends this as the default text/plain).</p> <pre><code># special MIME type for icons - see http://www.iana.org/assignments/media-types/image/vnd.microsoft.icon AddType image/vnd.microsoft.icon .ico # now we have icon MIME type, we can use it # my favicon doesn't change much ExpiresByType image/vnd.microsoft.icon "access plus 3 months" </code></pre> <p>And voila, It Works™!</p>
    singulars
    1. This table or related slice is empty.
    1. POWebsite image caching with Apache
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMatt Clark
    1. USPiskvor
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWebsite image caching with Apache
      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. COI have specified my favicon to have a MIME type of "image/x-icon" - and I can't seem to get Apache to set Expires headers on it. Any idea why this is? do i NEED to use image/vnd.microsoft.icon ?
      singulars
      1. PO
      1. USTom
    2. CO@Tom: "The official IANA-registered MIME type for .ICO files is image/vnd.microsoft.icon." (Wikipedia) So, you don't NEED to use it, but it's the correct MIME type - would you send "image/x-jpg" with JPEG images instead of the standard "image/jpeg"? Is there a technical reason you don't want to return the correct MIME type?
      singulars
      1. PO
      1. USPiskvor
    3. CO@Tom: as to the first question, the server shouldn't care what the MIME type is, as long as it knows about it. Do you have AddType *before* ExpiresByType for this MIME type?
      singulars
      1. PO
      1. USPiskvor
 

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