jeremykendall/lbtaas

Little Bobby Tables as a Service

Little Bobby Tables as a Service

Little Bobby Tables as a Service (LBTaaS) was created as an example of composer create-project for my Composer presentation given at TechCamp Memphis on Nov 2, 2013., _(*1)

Live on the Webs

Check out the production version at http://lbtaas.jeremykendall.net., _(*2)

Installation

• Install Composer
• Run composer create-project jeremykendall/lbtaas lbtaas
• Add 127.0.0.1 lbtaas.dev to /etc/hosts
• Create a vhost with DocumentRoot set to /path/to/lbtaas/public
• Restart apache
• WIN

Usage

Make a GET request to http://lbtaas.dev/lbt?version=1. You should receive the following JSON response:, _(*3)

{
   "status":"success",
   "data":{
      "name":"Exploits of a Mom",
      "permalink":"http:\/\/xkcd.com\/327\/",
      "image":"http:\/\/imgs.xkcd.com\/comics\/exploits_of_a_mom.png",
      "alt":"Her daughter is named Help I'm trapped in a driver's license factory.",
      "link":"\/lbt?version=1&format=json"
   }
}

Official xkcd JSON Interface

Unbeknownst to me, there is an actual, no kidding, in production JSON interface for xkcd. From the xkcd About page:, _(*4)

Is there an interface for automated systems to access comics and metadata?, _(*5)

Yes. You can get comics through the JSON interface, at URLs like http://xkcd.com/info.0.json (current comic) and http://xkcd.com/614/info.0.json (comic #614)., _(*6)

So the "real" LBTaaS would be http://xkcd.com/327/info.0.json, wouldn't it?, _(*7)

Official xkcd JSON Interface Response Body

Here's the response body you'll get for Little Bobby Tables from the official JSON endpoint:, _(*8)

```` { "month":"10", "num":327, "link":"", "year":"2007", "news":"", "safe_title":"Exploits of a Mom", "transcript":"[[A woman is talking on the phone, holding a cup]]\nPhone: Hi, this is your son's school. We're having some computer trouble.\nMom: Oh dear\u00e2\u0080\u0094did he break something?\nPhone: In a way\u00e2\u0080\u0094\nPhone: Did you really name your son \"Robert'); DROP TABLE Students;--\" ?\nMom: Oh, yes. Little Bobby Tables, we call him.\nPhone: Well, we've lost this year's student records. I hope you're happy.\nMom: And I hope you've learned to sanitize your database inputs.\n{{title-text: Her daughter is named Help I'm trapped in a driver's license factory.}}", "alt":"Her daughter is named Help I'm trapped in a driver's license factory.", "img":"http:\/\/imgs.xkcd.com\/comics\/exploits_of_a_mom.png", "title":"Exploits of a Mom", "day":"10" } ```, _(*9)