Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><strong>In short :</strong> your first option is the best</p> <p><strong>Long version:</strong> I'm not sure you can use base64 urls to post on facebook - for the same reasons that you can't use a GET request for huge base64 strings (do they support urls that are that long ?) - so you might actually <em>need</em> to save these pictures. </p> <p>I'm not sure, but i think only pictures that are directly posted by the user (not <em>linked to</em> by a "share" button) are saved facebook-side, the other ones are actually sitting in your server.</p> <p>First of all then, you should test if sending huge base64 strings directly through facebook API works - i tried creating a graph api meta tag for a small image using FB's online tool and it didn't work, so this doesn't look good (though i admit i don't know FB API well).</p> <p>Let's admit you'll have to save this image for good - sending it to your server through an AJAX POST request is not that hard. If you use <a href="http://api.jquery.com/jQuery.post/" rel="nofollow">JQuery</a> it's even really simple. Just use ruby to convert the base64 to an image file afterwards.</p> <p><strong>EDIT:</strong> I just wonder if i undestand well the question. Do you just want your users to be able to download the created image ? if so, they just have to right-click>save the generated image. The <a href="http://www.nihilogic.dk/labs/canvas2image/" rel="nofollow">canvas2image lib</a> can even make this easier for "right-click impaired" users ;)</p> <p><strong>EDIT 2:</strong> Here's an example of an ajax POST request with JQuery :</p> <pre><code>$.post( // first argument : the URL you want to POST to 'url/to/post.js', // second argument: the data to send to the server myData, // third argument : a callback function, // that is called when the request is complete // and is passed the data returned by the server // + response status (success, error...) function( data ){ alert('request completed, returned :' + data); }); </code></pre> <p>so in your case, you could do something like this:</p> <pre><code>$.post( '&lt;%= create_facebook_image_path format: :js %&gt;', { base_64_string: img }, function( data ){ $('#viewport').append( $('&lt;img /&gt;').attr({ src: data.url }) ); }); </code></pre> <p>more examples are available in <a href="http://api.jquery.com/jQuery.post/" rel="nofollow">JQuery's doc</a>, including how to handle success / error status. I advise you to learn using JQuery, you will soon find how it is simple yet powerful !</p>
    singulars
    1. This table or related slice is empty.
    1. PObase64 decoding in rails 3 app without saving on server
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USBenjamin
    1. USm_x
    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. COYou understood the question perfectly. The sole purpose of the image is to have a link with a PNG image on the page so that when posted to facebook, facebook cache the images for display. Then I can just delete the image from a temp folder on the server. Can you give me an example of an AJAX POST request or JQuery code? I'm not very familiar with either (I do have JQuery installed). Thanks!
      singulars
      1. PO
      1. USkevin1
    2. COupdated my answer. are you sure that FB caches the image and that you don't need to keep it ?
      singulars
      1. PO
      1. USm_x
    3. COThanks, I will try that out. (Now I have to figure out how to save a file to the tmp folder in my Rails app! I'm still relatively new to Rails.) FB does cache images from what I've read: it's something people seem to complain about when they want to change to new images. For me, caching is good!
      singulars
      1. PO
      1. USkevin1
 

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