Squio.blog

Tagged: webdev Toggle Comment Threads | Keyboard Shortcuts

• 

  Joe 11:03 on November 18, 2009 Permalink
  Tags: AR ( 15 ), Flickr ( 3 ), foursquare ( 2 ), layar ( 19 ), webdev, yql   

  Adding Flickr photos to Foursquare using YQL 

  

  Image by miss604 via Flickr

  Browsing the updated Foursquare development documents I came across a real nice hidden gem: it appears that the Flickr folks have enabled so called machine tags to associate a photo with a Foursquare venue.

  The almost hidden quote from the Flickr Developer blog:

  This is the part where I casually mention that we’ve also added machine tags extra love for Four Square venues IDs. I’m just saying…

  Now how cool would it be to display a little photo on my Foursquare Layar venue detail pages?
  Remembering @codepo8‘s execellent talk at the Fronteers conference last week, I realized that this is where the really cool YQL engine comes in really handy.

  And indeed, the following query does it all:

  select * from flickr.photos.search
      where machine_tags="foursquare:venue=132009"
      limit 1

  Just save the REST command url, wrap it in a little PHP handler and we’re good to go (homework for next time: process the YQL response in XML format with js/e4x and skip the PHP part altogether).

  So now you will see a little thumbnail picture for every venue which has a photo tagged on Flickr. There aren’t many yet, but hey, it’s a start!

  See it in action in the Foursquare Layar app on your phone (iPhone, Android) or read my announcement for more background information about the foursquare layar app.

  Somewhat related articles by Zemanta

  • Small pieces, loosely joined by machine tags (adactio.com)
  • Zee.: Noticings is Foursquare for photo sharers (thenextweb.com)
  • Noticings: Geotagging Photo Game Powered by Flickr API (readwriteweb.com)

  

  Tweet This Delicious Reddit This Post Stumble This Post

   
• 

  Joe 15:14 on November 23, 2007 Permalink
  Tags: admin tool, Cloning, drupal, drupal site, similar tool, simplest solution, staged web site, sysadmin, visual tool, web browser ( 3 ), webdev   

  Cloning a drupal site 

  

  Just a quick hack and reminder for myself…

  Situation: you developed a nice website with drupal on one of your local boxes and you want to clone this literally to a new staging host.This can be as simple as using ftp (all of your drupal source files, including modified themes, extra modules and uploaded files).

  Then use phpMyAdmin or a similar tool to dump and restore the corresponding drupal database.

  Now you fire up your web browser, and there is that disappointment: you see just an empty, white page, not even single error message!

  Luckily, the solution is rather simple: use your admin tool to entirely clean (truncate) the cache_menu table from your cloned database. Maybe you should truncate the other cache tables as well, that won’t hurt in any case.

  The next reload will show you the staged web site in all its glory!

  Another small catch to be aware of: if you’re using “Clean URLs” and are depending on a .htaccess file, this might not get copied by FTP if you’re using a visual tool (e.g. Cyberduck for Mac OS-X).

  In that case, the simplest solution may be to create a new .htaccess file remotely (in Cyberduck: right click and choose “new file” from the context menu). Now edit this file over ftp (Cyberduck: right click on file and choose “edit in => TextWrangler” – or similar). Just copy and paste the contents of your local .htaccess file, save and you’re ready to go.

  drupal webdev sysadmin

  [ratings]

  Tweet This Delicious Reddit This Post Stumble This Post

  Dorax is discussing. Toggle Comments

   
  • 

    Dorax 12:40 on December 3, 2007 Permalink

    truncate menu_cache. Excellent tip! You saved my day!