Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The way the server sends the file, and the way the browser is configured to use it depend on the action that the browser will take. The link itself has no input on this. </p> <p>You need to look at <a href="http://en.wikipedia.org/wiki/MIME" rel="nofollow">mime types</a>, and how they're used within HTTP Headers. </p> <p>By way of example: </p> <ol> <li>I click on a link to www.example.com/song.mp3, my browser sends a request to the server. </li> <li>The server sends back the file with a <a href="https://en.wikipedia.org/wiki/List_of_HTTP_header_fields" rel="nofollow">http header</a> saying <code>content-type: audio/mp3</code></li> <li>My browser looks to see if it has anything that can deal with that file. If it does, it may play the file directly. (This is what happens for html, and pictures) </li> <li>If the browser is unable to find a handler then it may prompt you to save the file (or perhaps just start saving the file automatically). </li> </ol> <p>To force the 'download' behavior, you can either configure the server to send a mimetype that the browser won't handle automatically. This approach can generally be done on a server configuration level. Note that you have no control over what the browser does, and some browsers may still try to handle the file anyway.</p> <p>Alternatively, you can send the file as an attachment, if you set the content-disposition header, like <code>Content-Disposition: attachment; filename="song.mp3"</code>. This approach generally requires some form of code (eg php, asp.net, ruby, etc) to do this behaviour. </p>
    singulars
    1. This table or related slice is empty.
    1. POWhat is required to make a downloadable song?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWhat is required to make a downloadable song?
      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. VTAcceptedByOriginator
    1. COGood explanation, Will. @MichaelPitluck In either case (my answer or Will's), essentially all you're doing is confusing the browser so that the settings the person may have saved are no longer applicable (for example, what the browser should do when it encounters a `.mp3` file). See [this article](http://kb.mozillazine.org/Changing_media_handling_behaviour#Unable_to_set_an_automatic_action) for more info.
      singulars
      1. PO
      1. USjerdiggity
    2. CO@will Thanks Will. I read that article on mime types. This seems to be the direction I want. I want the file to work on most browsers -- simply, click the "download song" button and the song downloads. What would be the safest, most reliable way to go be for this? Learning which language? Thanks.
      singulars
      1. PO
      1. USMichael Pitluk
    3. CO@Michael All the popular server-side languages/frameworks should let you do this. I imagine to build your site you're going to need some other form of interactivity (eg log in, preferences, etc) - so this shouldn't need to be a factor in picking one.
      singulars
      1. PO
      1. This table or related slice is empty.
 

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