Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Facebook FQL stream limit?

I want to get the full history of my wall. But I seem to hit a limit somewhere back in June.

I do multiple calls like this:

SELECT created_time,message FROM stream WHERE source_id=MY_USER_ID LIMIT 50

SELECT created_time,message FROM stream WHERE source_id=MY_USER_ID LIMIT 51,100

and so on...

But I always end up on the same last (first) post on my wall. Through facebook.com I can go back much longer so Facebook obviously have the data.

Why am I not getting older posts? Is there another way to scrape my history?

like image 318
fdqps Avatar asked Oct 31 '10 06:10

fdqps


People also ask

Is there a limit on Facebook Live streaming?

The limit will change depending on what device you're streaming with. Computer: The time limit for live streaming is 8 hours. External Streaming Software/API: The time limit for streaming is 8 hours. Mobile Device: The time limit for live streaming is 8 hours.

How can I stream more than 8 hours on Facebook?

Here's how to do this:Login to your Facebook profile and look for the "Publishing Tool" or "Videos" links. Click on the "LIVE" or "+Live" links to enter the Facebook Live Studio Creator. Use your camera as video source, or select the "Connect" tab to use a media encoder. Check the "Use a persistent stream key" box.

Is there a limit on how long you can live stream?

Technically, there's no time limit on a YouTube live stream. However, YouTube can only archive live streams up to 12 hours long. So, if you want your stream to be eligible for viewing at a later time or date, 12 hours is the maximum limit.

What is the max bitrate for Facebook Live?

Before you go live on Facebook, your video must meet the following technical specifications and content requirements. Note: The maximum recommended bitrate is 15 Mbps. Video codec: H.


2 Answers

I am experiencing the same thing. I don't understand it at all, but it appears that the offset cannot be greater than the limit * 1.5

Theoretically, this means that always increasing the limit to match the offset would fix it, but I haven't been able to verify this (I'm not sure whether the problems I'm seeing are other bugs in my code or if there are other limitations I don't understand about getting the stream).

Can anyone explain what I'm seeing and whatever I'm missing?

You can reproduce my results by going to the FQL Test Console:

http://developers.facebook.com/docs/reference/rest/fql.query

pasting in this query:

SELECT post_id, created_time, message, likes, comments, attachment, permalink, source_id, actor_id 
FROM stream 
WHERE filter_key IN 
(
      SELECT filter_key 
      FROM stream_filter 
      WHERE uid=me() AND type='newsfeed'
) 
AND is_hidden = 0 limit 100 offset 150

When you click "Test Method" you will see one of the 2 results I am getting:

  1. The results come back: [{post_id:"926... (which I expected)
  2. It returns empty [] (which I didn't expect)

You will likely need to experiment by changing the "offset" value until you find the exact place where it breaks. Just now I found it breaks for me at 155 and 156.

Try changing both the limit and the offset and you'll see that the empty results don't occur at a particular location in the stream. Here are some examples of results I've seen:

  • "...limit 50 offset 100" breaks, returning empty []
  • "...limit 100 offset 50" works, returning expected results
  • "...limit 50 offset 74" works
  • "...limit 50 offset 75" breaks
  • "...limit 20 offset 29" works
  • "...limit 20 offset 30" breaks

Besides seeing the limit=offset*1.5 relationship, I really don't understand what is going on here.

like image 29
Subcreation Avatar answered Nov 15 '22 06:11

Subcreation


From http://developers.facebook.com/docs/reference/fql/stream :

The stream table is limited to the last 30 days or 50 posts, whichever is greater

like image 97
digital illusion Avatar answered Nov 15 '22 06:11

digital illusion