Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Why set your cache expiration so far in the future? If you set it to one day for instance, the only overhead that you will incur (once a day) is the browser revalidating that it is the same file. If you still have not changed it, then you will not re-download the file, the server will respond with a not-modified response.</p> <blockquote> <p>All caches have a set of rules that they use to determine when to serve a representation from the cache, if it’s available. Some of these rules are set in the protocols (HTTP 1.0 and 1.1), and some are set by the administrator of the cache (either the user of the browser cache, or the proxy administrator).</p> <p>Generally speaking, these are the most common rules that are followed (don’t worry if you don’t understand the details, it will be explained below):</p> <ol> <li>If the response’s headers tell the cache not to keep it, it won’t.</li> <li>If the request is authenticated or secure (i.e., HTTPS), it won’t be cached.</li> <li>A cached representation is considered fresh (that is, able to be sent to a client without checking with the origin server) if: * It has an expiry time or other age-controlling header set, and is still within the fresh period, or * If the cache has seen the representation recently, and it was modified relatively long ago. Fresh representations are served directly from the cache, without checking with the origin server.</li> <li>If an representation is stale, the origin server will be asked to validate it, or tell the cache whether the copy that it has is still good.</li> <li>Under certain circumstances — for example, when it’s disconnected from a network — a cache can serve stale responses without checking with the origin server.</li> </ol> <p>If no validator (an ETag or Last-Modified header) is present on a response, and it doesn't have any explicit freshness information, it will usually — but not always — be considered uncacheable.</p> <p>Together, freshness and validation are the most important ways that a cache works with content. A fresh representation will be available instantly from the cache, while a validated representation will avoid sending the entire representation over again if it hasn’t changed.</p> </blockquote> <p><a href="http://www.mnot.net/cache_docs/#BROWSER" rel="nofollow noreferrer">http://www.mnot.net/cache_docs/#BROWSER</a></p>
    singulars
    1. This table or related slice is empty.
    1. POCan I clear a specific URL in the browser's cache (using POST, or otherwise)?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USTommy
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COI am trying to eliminate any roundtrips that need to occur unless they are necessary -- that means using Expires. The reason I'm using far-future is because I'm serving a script whose loading time is extremely important. If it's slow once a day when it should be able to be cached indefinitely, that's a loss on my part. To me, it's absolutely pathetic that there's no domain specific key/value protocol to cache items.
      singulars
      1. PO
      1. USSambo
    2. CO@sambo: after reading the above link, I don't think it would be slow once a day unless you were updating it once a day. Perhaps I am mistaken, but the overhead of a file check should be relatively quick (200 bytes maybe)? But, it was just my 2 cents :) Hopefully, you can find a good solution to your issue.
      singulars
      1. PO
      1. USTommy
    3. COWell, it's sadly a tad more complicated. Instead of foo.js, its actually foo.js?user_id=XYZ. So, I'll have to manually check their If-Modified-Since request header against the last time I changed the code and respond accordingly. The #1 important thing is having foo.js load as instantly as possible. You're right though, a quick roundtrip exchange of headers is probably fast enough, and I'll likely settle for that. Thanks for your 2 cents :)
      singulars
      1. PO
      1. USSambo
 

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